| 0.0024 |
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.0015 |
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.0031 |
SHOW TABLES FROM qi_cms_artuk_staging
|
| 0.0020 |
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.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 = '14'
AND c.parent_id IS NULL
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 = '15'
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 = '15'
AND c.parent_id = '182'
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 = '15'
AND c.parent_id = '41'
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 = '15'
AND c.parent_id = '43'
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 = '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.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 = '15'
AND c.parent_id = '298'
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 = '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.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 = '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.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 = '299'
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 = '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.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 = '19'
AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0010 |
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.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 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.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 = '149'
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 = '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.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 = '420'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 0.0004 |
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.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.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 = '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.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 = '18'
AND c.parent_id = '173'
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 = '435'
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 = '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.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 = '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.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 = '82'
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 = '24'
AND c.parent_id = '78'
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 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 = '25'
AND c.parent_id = '119'
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 = '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.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 = '122'
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 = '125'
GROUP BY c.id
ORDER BY c.`rank`, c.name
|
| 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 = 'contact'
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 = 'news'
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 = 'newsletter'
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 = 'object'
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 = '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.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 = 'venue'
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 = 'story'
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 = 'story_author'
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 = 'sub_category'
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 = '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.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 = 'search'
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 = 'album'
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 = 'show_curation'
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_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.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 = '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.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 = 'saved_search'
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 = 'learning_resources'
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_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.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_import'
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 = '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.0008 |
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.0003 |
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.0008 |
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.0016 |
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.0006 |
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.0006 |
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.0014 |
SELECT w.id as work_id, w.reference, yp.in_copyright, yp.copyright_holder_type, yp.media_copyright_holder as media_copyright_holder_type, coalesce(w.no_bbc, c.no_bbc) as excluded, w.pwr, w.image_restricted, w.out_of_copyright, w.collection_rights_reserved
FROM (work w)
JOIN yaydr_work yp ON w.id = yp.id
LEFT JOIN collection c ON c.id = w.collection_id
WHERE w.reference = 'the-hunters-105077'
|
| 0.0004 |
SELECT ylt.id, ylt.name, alt.code
FROM (yaydr_licence_type ylt)
JOIN artuk_licence_type alt ON alt.id = ylt.artuk_licence_type_id
|
| 0.0004 |
SELECT id, name, art_uk_licence_title, art_uk_url, art_uk_copyright_description, licence_notes
FROM (yaydr_licence)
WHERE yaydr_licence_type_id = 14
|
| 0.0007 |
SELECT yl.id, yl.name, alt.url, yl.art_uk_url, yl.art_uk_copyright_description, alt.name as art_uk_licence_title, alt.description as art_uk_licence_type_description, alt.code, yl.description, yl.yaydr_licence_type_id, lx.yaydr_right_id, lx.ad_user_id, ut.name as user_type, lx.work_id
FROM (yaydr_licence_work_xrefs lx)
JOIN yaydr_licence yl ON yl.id = lx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
JOIN artuk_licence_type alt ON alt.id = ylt.artuk_licence_type_id
LEFT JOIN ad_user u ON u.id = lx.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE lx.work_id = '105077'
AND (if(lx.id is not null, lx.online = 1 and not (lx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND (if(alt.id is not null, alt.online = 1 and not (alt.deleted <=> 2), 1))
|
| 0.0010 |
SELECT yl.id, yl.name, alt.url, yl.art_uk_url, yl.art_uk_copyright_description, alt.code, alt.name as art_uk_licence_title, alt.description as art_uk_licence_type_description, yl.description, yl.yaydr_licence_type_id, ylax.yaydr_right_id, ylax.ad_user_id, ut.name as user_type, wax.artist_id
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND ( wax.relationship = 'work_artist' )
JOIN yaydr_licence_artist_xrefs ylax ON ylax.artist_id = wax.artist_id
JOIN yaydr_licence yl ON yl.id = ylax.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
JOIN artuk_licence_type alt ON alt.id = ylt.artuk_licence_type_id
LEFT JOIN ad_user u ON u.id = ylax.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE w.id = '105077'
AND ( wax.relationship = 'work_artist' )
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylax.id is not null, ylax.online = 1 and not (ylax.deleted <=> 2), 1))
AND (if(wax.id is not null, wax.online = 1 and not (wax.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND (if(alt.id is not null, alt.online = 1 and not (alt.deleted <=> 2), 1))
|
| 0.0005 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '5'
|
| 0.0012 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id = '6907'
GROUP BY u.id
|
| 0.0008 |
SELECT yl.id, yl.name, alt.url, yl.art_uk_url, yl.art_uk_copyright_description, alt.code, alt.name as art_uk_licence_title, alt.description as art_uk_licence_type_description, yl.description, yl.yaydr_licence_type_id, ylcx.yaydr_right_id, ylcx.ad_user_id, ut.name as user_type, w.collection_id
FROM (work w)
JOIN yaydr_licence_collection_xrefs ylcx ON ylcx.collection_id = w.collection_id
JOIN yaydr_licence yl ON yl.id = ylcx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
JOIN artuk_licence_type alt ON alt.id = ylt.artuk_licence_type_id
LEFT JOIN ad_user u ON u.id = ylcx.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE w.id = '105077'
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylcx.id is not null, ylcx.online = 1 and not (ylcx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND (if(alt.id is not null, alt.online = 1 and not (alt.deleted <=> 2), 1))
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '7'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '18'
|
| 0.0002 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '19'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '20'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '13'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '4'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '15'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '5'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '18'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = '13'
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = ''
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = ''
|
| 0.0009 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id = '6368'
GROUP BY u.id
|
| 0.0003 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id IS NULL
GROUP BY u.id
|
| 0.0003 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id IS NULL
GROUP BY u.id
|
| 0.0010 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id = '12740'
GROUP BY u.id
|
| 0.0008 |
SELECT w.copyright_credit_line, w.copyright_credit_line_url, group_concat(a.copyright_credit_line) as artist_copyright_credit_line, group_concat(a.copyright_credit_line_url) as artist_copyright_credit_line_url, coalesce(c.collection_artwork_copyright_credit_line, c.name) as collection_copyright_credit_line, c.copyright_credit_line_url as collection_copyright_credit_line_url
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND wax.online = 1 AND NOT wax.deleted <=> 2 AND ( wax.relationship = 'work_artist' )
LEFT JOIN artist a ON a.id = wax.artist_id AND a.online = 1 AND NOT a.deleted <=> 2
LEFT JOIN collection c ON c.id = w.collection_id AND c.online = 1 AND NOT c.deleted <=> 2
WHERE w.id = '105077'
GROUP BY w.id
|
| 0.0006 |
SELECT w.media_credit_line, w.media_credit_line_url, group_concat(a.artist_media_credit_line) as artist_media_credit_line, group_concat(a.media_credit_line_url) as artist_media_credit_line_url, coalesce(c.collection_media_credit_line, c.name) as collection_media_credit_line, c.media_credit_line_url as collection_media_credit_line_url
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND wax.online = 1 AND NOT wax.deleted <=> 2
LEFT JOIN artist a ON a.id = wax.artist_id AND a.online = 1 AND NOT a.deleted <=> 2 AND ( wax.relationship = 'work_artist' )
LEFT JOIN collection c ON c.id = w.collection_id AND c.online = 1 AND NOT c.deleted <=> 2
WHERE w.id = '105077'
GROUP BY w.id
|
| 0.0004 |
SELECT yl.id, yl.name, yl.yaydr_licence_type_id, lx.yaydr_right_id, lx.ad_user_id, lx.work_id
FROM (yaydr_licence_work_xrefs lx)
JOIN yaydr_licence yl ON yl.id = lx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
WHERE lx.work_id = '105077'
AND (if(lx.id is not null, lx.online = 1 and not (lx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND yl.id IN (40, 41, 42, 43)
|
| 0.0007 |
SELECT yl.id, yl.name, yl.yaydr_licence_type_id, ylax.yaydr_right_id, ylax.ad_user_id, wax.artist_id
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND ( wax.relationship = 'work_artist' )
JOIN yaydr_licence_artist_xrefs ylax ON ylax.artist_id = wax.artist_id
JOIN yaydr_licence yl ON yl.id = ylax.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
WHERE w.id = '105077'
AND ( wax.relationship = 'work_artist' )
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylax.id is not null, ylax.online = 1 and not (ylax.deleted <=> 2), 1))
AND (if(wax.id is not null, wax.online = 1 and not (wax.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND yl.id IN (40, 41, 42, 43)
|
| 0.0005 |
SELECT yl.id, yl.name, yl.yaydr_licence_type_id, ylcx.yaydr_right_id, ylcx.ad_user_id, w.collection_id
FROM (work w)
JOIN yaydr_licence_collection_xrefs ylcx ON ylcx.collection_id = w.collection_id
JOIN yaydr_licence yl ON yl.id = ylcx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
WHERE w.id = '105077'
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylcx.id is not null, ylcx.online = 1 and not (ylcx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
AND yl.id IN (40, 41, 42, 43)
|
| 0.0004 |
SELECT yl.id, yl.name, yl.art_uk_url, yl.art_uk_copyright_description, yl.description, yl.yaydr_licence_type_id, lx.yaydr_right_id, lx.ad_user_id, ut.name as user_type, lx.work_id
FROM (yaydr_licence_work_xrefs lx)
JOIN yaydr_licence yl ON yl.id = lx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
LEFT JOIN ad_user u ON u.id = lx.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE lx.work_id = '105077'
AND yl.name LIKE 'BBC%'
AND (if(lx.id is not null, lx.online = 1 and not (lx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
|
| 0.0007 |
SELECT yl.id, yl.name, yl.art_uk_url, yl.art_uk_copyright_description, yl.description, yl.yaydr_licence_type_id, ylax.yaydr_right_id, ylax.ad_user_id, ut.name as user_type, wax.artist_id
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND ( wax.relationship = 'work_artist' )
JOIN yaydr_licence_artist_xrefs ylax ON ylax.artist_id = wax.artist_id
JOIN yaydr_licence yl ON yl.id = ylax.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
LEFT JOIN ad_user u ON u.id = ylax.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE w.id = '105077'
AND ( wax.relationship = 'work_artist' )
AND yl.name LIKE 'BBC%'
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylax.id is not null, ylax.online = 1 and not (ylax.deleted <=> 2), 1))
AND (if(wax.id is not null, wax.online = 1 and not (wax.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
|
| 0.0006 |
SELECT yl.id, yl.name, yl.art_uk_url, yl.art_uk_copyright_description, yl.description, yl.yaydr_licence_type_id, ylcx.yaydr_right_id, ylcx.ad_user_id, ut.name as user_type, w.collection_id
FROM (work w)
JOIN yaydr_licence_collection_xrefs ylcx ON ylcx.collection_id = w.collection_id
JOIN yaydr_licence yl ON yl.id = ylcx.yaydr_licence_id
JOIN yaydr_licence_type ylt ON ylt.id = yl.yaydr_licence_type_id
LEFT JOIN ad_user u ON u.id = ylcx.ad_user_id
LEFT JOIN ad_user_type ut ON ut.id = u.ad_user_type_id
WHERE w.id = '105077'
AND yl.name LIKE 'BBC%'
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(ylcx.id is not null, ylcx.online = 1 and not (ylcx.deleted <=> 2), 1))
AND (if(yl.id is not null, yl.online = 1 and not (yl.deleted <=> 2), 1))
AND (if(ylt.id is not null, ylt.online = 1 and not (ylt.deleted <=> 2), 1))
|
| 0.0003 |
SELECT yr.name, yr.description
FROM (yaydr_right yr)
JOIN yaydr_right_group yrg ON yrg.id = yr.yaydr_right_group_id
WHERE yrg.name = 'Image'
AND (if(yr.id is not null, yr.online = 1 and not (yr.deleted <=> 2), 1))
AND (if(yrg.id is not null, yrg.online = 1 and not (yrg.deleted <=> 2), 1))
AND yr.id = ''
|
| 0.0006 |
SELECT u.name, group_concat(distinct uc.collection_id) as collection_id, group_concat(distinct ua.artist_id) as artist_id, group_concat(distinct uw.work_id) as work_id, group_concat(distinct ucr.name) as collection_licence_role, group_concat(distinct uar.name) as artist_licence_role, group_concat(distinct uwr.name) as painting_licence_role
FROM (ad_user u)
LEFT JOIN ad_user_collection_xrefs uc ON uc.ad_user_id = u.id AND (if(uc.id is not null, uc.online = 1 and not (uc.deleted <=> 2), 1))
LEFT JOIN user_licence_role ucr ON ucr.id = uc.user_licence_role_id
LEFT JOIN ad_user_artist_xrefs ua ON ua.ad_user_id = u.id AND (if(ua.id is not null, ua.online = 1 and not (ua.deleted <=> 2), 1))
LEFT JOIN user_licence_role uar ON ua.user_licence_role_id = uar.id
LEFT JOIN ad_user_work_xrefs uw ON uw.ad_user_id = u.id AND (if(uw.id is not null, uw.online = 1 and not (uw.deleted <=> 2), 1))
LEFT JOIN user_licence_role uwr ON uw.user_licence_role_id = uwr.id
WHERE u.id = '6368'
GROUP BY u.id
|
| 0.0004 |
SELECT a.id, a.name, a.copyright_contact, a.copyright_holder, a.copyright_dacs, a.copyright_bridgeman_artist
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND wax.online = 1 AND NOT wax.deleted <=> 2
LEFT JOIN artist a ON a.id = wax.artist_id AND a.online = 1 AND NOT a.deleted <=> 2 AND ( wax.relationship = 'work_artist' )
WHERE w.id = '105077'
ORDER BY wax.`rank`
|
| 0.0005 |
SELECT a.id, a.name, a.copyright_contact, a.copyright_holder, a.copyright_dacs, a.copyright_bridgeman_artist
FROM (work w)
LEFT JOIN work_artist_xrefs wax ON wax.work_id = w.id AND wax.online = 1 AND NOT wax.deleted <=> 2
LEFT JOIN artist a ON a.id = wax.artist_id AND a.online = 1 AND NOT a.deleted <=> 2 AND ( wax.relationship = 'work_artist' )
WHERE w.id = '105077'
ORDER BY wax.`rank`
|
| 0.0005 |
SELECT aft.name
FROM (collection c)
JOIN artuk_founder_type aft ON aft.id = c.artuk_founder_type_id
WHERE (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(aft.id is not null, aft.online = 1 and not (aft.deleted <=> 2), 1))
AND c.reference = 'university-of-aberdeen-1420'
|
| 0.0006 |
SELECT wax.work_id
FROM (work_artist_xrefs wax)
JOIN artist a ON a.id = wax.artist_id
WHERE (if(wax.id is not null, wax.online = 1 and not (wax.deleted <=> 2), 1))
AND (if(a.id is not null, a.online = 1 and not (a.deleted <=> 2), 1))
AND a.reference = 'ugarte-bernardino-olivares'
AND wax.relationship = 'artist_portrait'
|
| 0.0012 |
SELECT d.id, d.name, d.reference, rs.name as status
FROM (ad_discussion d)
JOIN ad_response_status rs ON rs.id = d.ad_response_status_id
JOIN work w ON w.id = d.work_id
WHERE w.reference = 'the-hunters-105077'
AND (if(d.id is not null, d.online = 1 and not (d.deleted <=> 2), 1))
AND (if(w.id is not null, w.online = 1 and not (w.deleted <=> 2), 1))
AND (if(rs.id is not null, rs.online = 1 and not (rs.deleted <=> 2), 1))
|
| 0.0006 |
SELECT n.id, n.name, n.news_date, n.reference
FROM (work c)
JOIN ad_news_work_xrefs nwx ON nwx.work_id = c.id
JOIN ad_news n ON n.id = nwx.ad_news_id
WHERE c.reference = 'the-hunters-105077'
AND (if(c.id is not null, c.online = 1 and not (c.deleted <=> 2), 1))
AND (if(n.id is not null, n.online = 1 and not (n.deleted <=> 2), 1))
AND (if(nwx.id is not null, nwx.online = 1 and not (nwx.deleted <=> 2), 1))
|
| 0.0006 |
SELECT s.id, s.name, s.publication_date, s.author, s.reference
FROM (work c)
JOIN ad_story_work_xrefs swx ON swx.work_id = c.id
JOIN ad_story s ON s.id = swx.ad_story_id
WHERE c.reference = 'the-hunters-105077'
AND s.list_languages_id = 1
AND IF(s.valid_from IS NOT NULL, s.valid_from <= NOW(), 1) AND IF(s.valid_to IS NOT NULL, s.valid_to >= NOW(), 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 (if(swx.id is not null, swx.online = 1 and not (swx.deleted <=> 2), 1))
ORDER BY swx.`rank` asc
|
| 0.0005 |
SELECT vt.name as embedded_code
FROM (ad_video_work_xrefs vt)
WHERE vt.work_id = '105077'
AND (if(vt.id is not null, vt.online = 1 and not (vt.deleted <=> 2), 1))
|
| 0.0006 |
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`
|
