| 0.0021 |
SELECT *
FROM exp_channel_fields
WHERE group_id = 2
|
| 0.0018 |
SELECT DISTINCT ct.title, ct.url_title, ct.entry_date, ct.entry_id, field_id_7 AS story, field_ft_7 AS story_ft, field_id_77 AS event_start_date, field_ft_77 AS event_start_date_ft, field_id_78 AS event_end_date, field_ft_78 AS event_end_date_ft, field_id_79 AS feature_item, field_ft_79 AS feature_item_ft, field_id_102 AS banner_summary, field_ft_102 AS banner_summary_ft, field_id_103 AS banner_title, field_ft_103 AS banner_title_ft
FROM exp_channel_titles ct, exp_channel_data cd, exp_category_posts cp, exp_categories c
WHERE ct.entry_id = cd.entry_id
AND c.cat_id = cp.cat_id
AND ct.channel_id = 3
AND c.cat_name = 'ok-first'
AND cp.entry_id = ct.entry_id
AND ct.status = 'Open'
ORDER BY ct.entry_date DESC
|
| 0.0018 |
SELECT *
FROM exp_channel_fields
WHERE group_id = 2
|
| 0.0016 |
SELECT ct.title, ct.url_title, ct.entry_date, field_id_7 AS story, field_ft_7 AS story_ft, field_id_77 AS event_start_date, field_ft_77 AS event_start_date_ft, field_id_78 AS event_end_date, field_ft_78 AS event_end_date_ft, field_id_79 AS feature_item, field_ft_79 AS feature_item_ft, field_id_102 AS banner_summary, field_ft_102 AS banner_summary_ft, field_id_103 AS banner_title, field_ft_103 AS banner_title_ft
FROM exp_channel_titles ct, exp_channel_data cd, exp_category_posts cp, exp_categories c
WHERE ct.entry_id = cd.entry_id
AND c.cat_id = cp.cat_id
AND ct.channel_id = 3
AND c.cat_name = 'ok-first'
AND cp.entry_id = ct.entry_id
AND ct.status = 'Open'
ORDER BY ct.entry_date DESC
LIMIT 1
|
| 0.0015 |
SELECT cat_id FROM exp_categories WHERE cat_url_title = 'ok-first_1'
|
| 0.0016 |
SELECT *
FROM exp_category_fields
WHERE group_id = 2
|
| 0.0014 |
SELECT cat_id
FROM exp_categories
WHERE parent_id = 372
|
| 0.0015 |
SELECT c.cat_name, c.cat_url_title, c.cat_description, c.parent_id, c.cat_id, cfd.field_id_6, field_id_2 AS controller, field_ft_2 AS controller_ft, field_id_6 AS cat_status, field_ft_6 AS cat_status_ft
FROM exp_categories c, exp_category_field_data cfd
WHERE c.cat_id = cfd.cat_id
AND (cfd.field_id_6 = '' OR cfd.field_id_6 IS NULL OR cfd.field_id_6 = 'Open')
AND (c.cat_id IN (373,375,376,377,378,385,386,387,388,389,390) OR c.parent_id IN (373,375,376,377,378,385,386,387,388,389,390))
AND c.group_id = 2
ORDER BY c.cat_order ASC
|
