| 0.0023 |
SELECT
TABLE_NAME AS table_name
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = DATABASE()
AND TABLE_NAME LIKE 'ad_%'
|
| 0.0010 |
SELECT p.variable `key`, p.value, concat(ifnull(concat(mf.path, '/'), ''), m.filename) as full_path, m.alt_text, m.caption, m.name as title, m.filename
FROM (ad_preference p)
LEFT JOIN media_xrefs mx ON mx.source_table = 'ad_preference' and mx.source_id = p.id and mx.online = 1 and mx.rank = 1
LEFT JOIN media m ON m.id = mx.media_id and m.online = 1 and m.media_type = 'image'
LEFT JOIN media_folder mf ON mf.id = m.media_folder_id
WHERE (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
GROUP BY p.id
|
| 0.0016 |
SELECT p.*, 'footer_page' as template, coalesce(page_node.controller, node.controller) as controller, coalesce(ad_page.reference, p.reference) as reference
FROM (ad_footer_page p)
JOIN _conf_node node ON node.id = p.node_id
LEFT JOIN link_xrefs lx ON lx.source_id = p.id and lx.source_table = 'ad_footer_page' and lx.rank = 1
LEFT JOIN ad_page ON ad_page.id = lx.target_id and ( (if(ad_page.id is not null, ad_page.online = 1 and not (ad_page.deleted <=> 2), 1)))
LEFT JOIN _conf_node page_node ON page_node.id = ad_page.node_id
WHERE (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
AND node.cluster_id = 4
ORDER BY p.`rank`
|
| 0.0033 |
SHOW TABLES FROM qi_cms_artuk_staging
|
| 0.0022 |
SELECT n.id, coalesce(s.name, n.name) as name, coalesce(s.controller, n.controller) as controller, c.reference, coalesce(t.method, 'page') AS template, c.`rank` as page_rank
FROM (_conf_node n)
JOIN ad_page c ON c.node_id = n.id
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
JOIN ad_section s ON s.id = n.id
WHERE c.`rank` = 1
AND (NOT c.hidden <=> 1)
AND (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(s.id is not null, s.online = 1 and not (s.deleted <=> 2), 1))
AND n.cluster_id = 4
GROUP BY n.id
ORDER BY s.`rank`
|
| 0.0009 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '14'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '182'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '41'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '43'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '425'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '309'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '42'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '298'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id = '325'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id = '282'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id = '290'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id = '433'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '26'
AND c.parent_id = '422'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '17'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '17'
AND c.parent_id = '181'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '17'
AND c.parent_id = '395'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '17'
AND c.parent_id = '299'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '16'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '16'
AND c.parent_id = '45'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '16'
AND c.parent_id = '71'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '19'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0009 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT link.*, n.controller
FROM (ad_page link)
JOIN _conf_node n ON n.id = link.node_id
WHERE link.id = '54'
AND ( NOT link.deleted <=> 2 )
AND (if(link.id is not null, link.online = 1 and not (link.deleted <=> 2), 1))
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '196'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0008 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '149'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '426'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '328'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '420'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0003 |
SELECT link.*, n.controller
FROM (ad_page link)
JOIN _conf_node n ON n.id = link.node_id
WHERE link.id = '54'
AND ( NOT link.deleted <=> 2 )
AND (if(link.id is not null, link.online = 1 and not (link.deleted <=> 2), 1))
|
| 0.0005 |
SELECT link.*, n.controller
FROM (ad_page link)
JOIN _conf_node n ON n.id = link.node_id
WHERE link.id = '54'
AND ( NOT link.deleted <=> 2 )
AND (if(link.id is not null, link.online = 1 and not (link.deleted <=> 2), 1))
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '20'
AND c.parent_id = '320'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '18'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '18'
AND c.parent_id = '234'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '18'
AND c.parent_id = '173'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '18'
AND c.parent_id = '435'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '23'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '23'
AND c.parent_id = '70'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '79'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '394'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '80'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '81'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '82'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '24'
AND c.parent_id = '78'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id = '119'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id = '120'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id = '121'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id = '122'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '25'
AND c.parent_id = '125'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0006 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'contact'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'news'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'newsletter'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'object'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'actor'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'people'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'venue'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0006 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'story'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'story_author'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'sub_category'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'movement'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'region'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'collection'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'event'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'search'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'album'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'show_curation'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'edit_artwork'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'edit_venue'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'my_artworks'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'my_venues'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0005 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'saved_search'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'learning_resources'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0004 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'batch_process'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'batch_validation'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'batch_import'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'tagger_landing'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0003 |
SELECT p.reference, concat(n.controller, '/', p.reference) as reference
FROM (ad_page p)
JOIN ad_page_template pt ON pt.id = p.ad_page_template_id
JOIN _conf_node n ON n.id = p.node_id
WHERE pt.method = 'donate'
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
|
| 0.0006 |
SELECT pup.*
FROM (ad_popup pup)
JOIN ad_popup_ad_page_xrefs xref ON xref.ad_popup_id = pup.id
JOIN ad_page p ON xref.ad_page_id = p.id
WHERE p.reference = 'artworks'
AND (if(pup.id is not null, pup.online = 1 and not (pup.deleted <=> 2), 1))
AND (if(xref.id is not null, xref.online = 1 and not (xref.deleted <=> 2), 1))
AND (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
ORDER BY xref.id desc
|
| 0.0004 |
SELECT pup.*
FROM (ad_popup pup)
WHERE pup.global_popup = 1
AND (if(pup.id is not null, pup.online = 1 and not (pup.deleted <=> 2), 1))
ORDER BY pup.id desc
|
| 0.0006 |
SELECT DISTINCT p.id, p.node_id, n.controller, p.name, p.name_alt, p.intro, p.bodytext, COALESCE(t.method, 'page') as template, p.ad_landing_feature_type_id as template_landing_page_modifier, p.section_type_id as is_section_landing_page, p.reference as reference, p.enable_social_links, p.`rank`, 'ad_page' as table_name, p.parent_id, parent_page.name as parent_name, parent_page.reference as parent_reference, IFNULL(parent_page.`rank`, 0) as parent_page_rank, linkx.target_table as linkx_table, linkx.target_id as linkx_id
FROM (ad_page p)
LEFT JOIN ad_page_template t ON t.id = p.ad_page_template_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = p.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_external_link link ON link.id = linkx.target_id
LEFT JOIN ad_page parent_page ON parent_page.id = p.parent_id
JOIN _conf_node n ON n.id = p.node_id and n.controller = 'discover'
WHERE (if(p.id is not null, p.online = 1 and not (p.deleted <=> 2), 1))
AND p.reference = 'artworks'
ORDER BY p.`rank`
|
| 0.0007 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.id = '41'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '41'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT DISTINCT c.id, c.parent_id, c.node_id, c.name, c.intro, c.`rank`, c.section_type_id as is_section_landing_page, n.controller, t.name AS template, t.method AS template_method, IFNULL(c.section_landing_sub_page_type_id, 0) as section_landing_sub_page_type, c.reference, linkx.target_table as ext_link_table, linkx.target_id as ext_link_id
FROM (ad_page c)
JOIN _conf_node n ON n.id = c.node_id
LEFT JOIN link_xrefs linkx ON linkx.source_id = c.id AND linkx.source_table = 'ad_page'
LEFT JOIN ad_page_template t ON t.id = c.ad_page_template_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(linkx.id is not null, linkx.online = 1 and not (linkx.deleted <=> 2), 1))
AND ( NOT linkx.deleted <=> 2 )
AND ( NOT c.hidden <=> 1 )
AND c.node_id = '15'
AND c.parent_id = '41'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0005 |
SELECT m.id, COALESCE(NULLIF(mx.name, ''), m.name) as title, COALESCE(NULLIF(mx.caption, ''), m.caption) as caption, m.credits, m.copyright, COALESCE(m.alt_text, m.name, m.filename) as alt_text, m.filename, mf.path, IF(mf.path is not null, CONCAT(mf.path, '/', m.filename), m.filename) as full_path, mx.`rank`, mf.`rank` as folder_rank, m.filesize, m.width, m.height, m.extension, m.media_type, m.metadata
FROM (media m)
JOIN media_xrefs mx ON mx.media_id = m.id
JOIN media_folder mf ON mf.id = m.media_folder_id and (if(mf.id is not null, mf.online = 1 and not (mf.deleted <=> 2), 1))
WHERE mx.source_id = '41'
AND mx.source_table = 'ad_page'
AND (if(mx.id is not null, mx.online = 1 and not (mx.deleted <=> 2), 1))
AND m.media_type = 'image'
AND mf.`rank` = 60
ORDER BY mx.`rank`
|
| 0.0005 |
SELECT m.id, COALESCE(NULLIF(mx.name, ''), m.name) as title, COALESCE(NULLIF(mx.caption, ''), m.caption) as caption, m.credits, m.copyright, COALESCE(m.alt_text, m.name, m.filename) as alt_text, m.filename, mf.path, IF(mf.path is not null, CONCAT(mf.path, '/', m.filename), m.filename) as full_path, mx.`rank`, mf.`rank` as folder_rank, m.filesize, m.width, m.height, m.extension, m.media_type, m.metadata
FROM (media m)
JOIN media_xrefs mx ON mx.media_id = m.id
JOIN media_folder mf ON mf.id = m.media_folder_id and (if(mf.id is not null, mf.online = 1 and not (mf.deleted <=> 2), 1))
WHERE mx.source_id = '41'
AND mx.source_table = 'ad_page'
AND (if(mx.id is not null, mx.online = 1 and not (mx.deleted <=> 2), 1))
AND m.media_type = 'image'
AND mf.`rank` = 65
ORDER BY mx.`rank`
|
| 0.0022 |
SELECT sc.id, sc.reference, c.name as category, sc.name
FROM (sub_category sc)
JOIN category c ON c.id = sc.category_id
WHERE (if(sc.id is not null, sc.online = 1 and not (sc.deleted <=> 2), 1))
AND (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND sc.id IN (153, 151, 134, 49, 139, 54, 133, 152, 53, 88, 143, 142, 219, 92, 138, 58, 141, 217, 148, 26, 116, 100, 56, 124, 93, 28, 101, 186, 55, 131, 20, 60, 97, 95, 128, 91, 126, 136, 98, 135, 96, 147, 104, 21, 150, 109, 62, 102, 44, 149, 122, 214, 119, 123, 130, 202, 200, 22, 64, 78, 47, 211, 209, 140, 71, 2, 112, 216, 69, 90, 145, 125, 45, 12, 68, 99, 79, 7, 52, 121, 108, 198, 208, 212, 19, 87, 194, 105, 111, 155, 80, 13, 63, 74, 221, 144, 9, 27, 42, 83, 201, 203, 154, 137, 94, 215, 86, 129, 70, 114, 193, 11, 77, 81, 210, 76, 206, 106, 18, 197, 4, 85, 16, 10, 118, 195, 205, 127, 75, 187, 146, 107, 113, 213, 3, 1, 207, 196, 51, 115, 73, 132, 189, 204, 110, 67, 199, 120, 5, 103, 117, 17, 14, 15, 223, 84)
ORDER BY c.name, sc.name
|
| 0.0006 |
SELECT sc.id, sc.reference, c.name as category, sc.name
FROM (sub_category sc)
JOIN category c ON c.id = sc.category_id
WHERE (if(sc.id is not null, sc.online = 1 and not (sc.deleted <=> 2), 1))
AND (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND sc.id IN (139, 151, 26, 28, 93, 135, 137, 142, 148, 150, 152, 153, 187, 200, 215, 42, 54, 78, 96, 98)
ORDER BY c.name, sc.name
|
| 0.0005 |
SELECT nav.name as nav_name, cn.controller, link.*
FROM (ad_menu_navbar nav)
LEFT JOIN ad_page link ON link.id = nav.ad_page_id
JOIN _conf_node cn ON cn.id = link.node_id
WHERE ( NOT nav.deleted <=> 2 )
AND (if(nav.id is not null, nav.online = 1 and not (nav.deleted <=> 2), 1))
ORDER BY nav.`rank`
|
