| query: |
SELECT i.* , c.id as content_id, c.site, c.language, c.admin, c.module, c.layer, c.item, c.parent, c.name, c.title, c.text_content, c.alias, c.custom_alias, c.browser_title, c.metakeywords, c.metadescription, c.canonical, c.robots, c.tags, c.params, c.publish, c.publish_min, c.publish_max, c.status, c.comment, c.disable_sitemap, c.disable_content, c.html, c.javascript, c.link_aria_text, c.position, c.added, c.edited, c.site AS content_site, c.language AS content_language, c.module AS content_module, c.layer AS content_layer, c.item AS content_item FROM `tips_and_education` i INNER JOIN content c ON i.id = c.item AND i.revision = c.revision WHERE c.item = ? AND c.module = ? AND c.layer = ? AND c.revision = ? |