Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 9 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 6 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 15 | 15 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 43 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (43) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (43) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (43) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 43 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 95 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (95) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (95) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (95) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 95 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 104 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (104) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (104) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (104) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 104 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 88 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (88) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (88) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (88) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 88 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 98 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (98) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (98) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (98) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 98 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 214 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (214) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (214) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (214) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 214 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 89 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (89) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (89) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (89) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 89 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 97 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (97) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (97) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (97) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 97 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 215 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (215) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (215) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (215) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 215 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 90 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (90) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (90) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (90) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 90 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 100 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (100) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (100) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (100) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 100 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 19 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (19) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (19) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (19) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 19 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 16 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (16) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 16 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 92 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (92) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (92) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (92) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 92 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 103 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (103) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (103) ORDER BY `id` ASC | 1 | 1 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (103) ORDER BY `id` ASC | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 103 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 10 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 6 | 6 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 61 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (61) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (61) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (61) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 61 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 64 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (64) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (64) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (64) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 64 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 67 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (67) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (67) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (67) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 67 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 70 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (70) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (70) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (70) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 70 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 73 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (73) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (73) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (73) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 73 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 76 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (76) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (76) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (76) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 76 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 7 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 6 | 6 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 24 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (24) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (24) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (24) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 24 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 37 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (37) | 6 | 6 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (37) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (37) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 37 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 25 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (25) | 6 | 6 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (25) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (25) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 25 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 39 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (39) | 7 | 7 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (39) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (39) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 39 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 40 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (40) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (40) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (40) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 40 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 26 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (26) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (26) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (26) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 26 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 14 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 14 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 111 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (111) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (111) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (111) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 111 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 11 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 105 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (105) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (105) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (105) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 105 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 13 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 13 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'spa') WHERE `Article`.`id` = 110 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (110) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (110) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (110) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 110 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Experience`.`id` = 48 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 48 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 3 | 3 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Subcategory`.`id` = 73 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Article`.`id` = 89 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 89 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Experience`.`id` = 480 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 480 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Subcategory`.`id` = 69 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Experience`.`id` = 449 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 449 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 2 | 2 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Subcategory`.`id` = 73 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__titulo_seo`.`content`) AS `Subcategory__i18n_titulo_seo`, (`I18n__descripcion_seo`.`content`) AS `Subcategory__i18n_descripcion_seo`, (`I18n__descripcion`.`content`) AS `Subcategory__i18n_descripcion`, (`I18n__h1`.`content`) AS `Subcategory__i18n_h1`, (`I18n__h2`.`content`) AS `Subcategory__i18n_h2`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug`, (`I18n__lang_hide`.`content`) AS `Subcategory__i18n_lang_hide`, (`I18n__image`.`content`) AS `Subcategory__i18n_image` FROM `vte_core`.`subcategories` AS `Subcategory` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__titulo_seo` ON (`Subcategory`.`id` = `I18n__titulo_seo`.`foreign_key` AND `I18n__titulo_seo`.`model` = 'Subcategory' AND `I18n__titulo_seo`.`field` = 'titulo_seo' AND `I18n__titulo_seo`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__descripcion_seo` ON (`Subcategory`.`id` = `I18n__descripcion_seo`.`foreign_key` AND `I18n__descripcion_seo`.`model` = 'Subcategory' AND `I18n__descripcion_seo`.`field` = 'descripcion_seo' AND `I18n__descripcion_seo`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__descripcion` ON (`Subcategory`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Subcategory' AND `I18n__descripcion`.`field` = 'descripcion' AND `I18n__descripcion`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__h1` ON (`Subcategory`.`id` = `I18n__h1`.`foreign_key` AND `I18n__h1`.`model` = 'Subcategory' AND `I18n__h1`.`field` = 'h1' AND `I18n__h1`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__h2` ON (`Subcategory`.`id` = `I18n__h2`.`foreign_key` AND `I18n__h2`.`model` = 'Subcategory' AND `I18n__h2`.`field` = 'h2' AND `I18n__h2`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__lang_hide` ON (`Subcategory`.`id` = `I18n__lang_hide`.`foreign_key` AND `I18n__lang_hide`.`model` = 'Subcategory' AND `I18n__lang_hide`.`field` = 'lang_hide' AND `I18n__lang_hide`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__image` ON (`Subcategory`.`id` = `I18n__image`.`foreign_key` AND `I18n__image`.`model` = 'Subcategory' AND `I18n__image`.`field` = 'image' AND `I18n__image`.`locale` = 'spa') WHERE `Subcategory`.`category_id` = 16 AND `Subcategory`.`cancelled` = '0' AND `I18n__name`.`content` <> '' AND `I18n__lang_hide`.`content` <> '1' AND NOT (`Subcategory`.`id` = 72) AND `Subcategory`.`deleted` = '0' ORDER BY (case
when `Subcategory`.`id` = 73 then 'a'
when `Subcategory`.`id` = 72 then 'aa'
when `Subcategory`.`id` = 96 then 'aaa'
when `Subcategory`.`id` = 99 then 'aaaa'
when `Subcategory`.`id` = 69 then 'aaaaa'
when `Subcategory`.`id` = 103 then 'aaaaaa'
when `Subcategory`.`id` = 94 then 'aaaaaaa'
when `Subcategory`.`id` = 107 then 'aaaaaaaa'
when `Subcategory`.`id` = 95 then 'aaaaaaaaa'
when `Subcategory`.`id` = 102 then 'aaaaaaaaaa'
when `Subcategory`.`id` = 98 then 'aaaaaaaaaaa'
when `Subcategory`.`id` = 105 then 'aaaaaaaaaaaa'
when `Subcategory`.`id` = 108 then 'aaaaaaaaaaaaa'
when `Subcategory`.`id` = 106 then 'aaaaaaaaaaaaaa'
else `I18n__name`.`content`
end) asc | 11 | 11 | 2 | maybe slow |
SELECT `Experience`.`id`, `Experience`.`gps_lat`, `Experience`.`gps_long`, `Experience`.`promoted`, `Experience`.`cancelled`, `Experience`.`location_id`, `Experience`.`duration`, `Experience`.`duration_days`, `Experience`.`min_pax`, `Experience`.`max_pax`, `Experience`.`fixed_date`, `Experience`.`experience_description_title_id`, `Experience`.`difficulty_id`, `Experience`.`sort_order`, `Experience`.`transport_id`, `Experience`.`activity_id`, `Experience`.`duration_flexible`, `Experience`.`hotel_id`, `Experience`.`supplier_id`, `Experience`.`baby_max_age`, `Experience`.`child_max_age`, `Experience`.`visible_only_on_view`, `Experience`.`island_id`, `Experience`.`in_offer`, `Experience`.`promotur_result`, `Experience`.`canonical`, `Experience`.`canonical_experience_id`, `Experience`.`modified`, `Experience`.`promotur_exported`, `Experience`.`promotur_headers`, `Experience`.`promotur_response_code`, `Experience`.`discounts_only`, `Experience`.`alternatives_exp`, `Experience`.`date_change_limit`, `Experience`.`date_change_number_limit`, `Experience`.`lower_price_criteria`, `Experience`.`auto_refund`, `Experience`.`deleted`, `Experience`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`experiences` AS `Experience` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`subcategory_id` IN (73, 96, 99, 69, 94, 98, 110, 134, 111, 109, 135) AND `ExperiencesSubcategory`.`experience_id` = `Experience`.`id`) WHERE `Experience`.`cancelled` = '0' ORDER BY case when `ExperiencesSubcategory`.`sort_order` is null then 1000 else `ExperiencesSubcategory`.`sort_order` end ASC | 86 | 86 | 1 | |
SELECT `Section`.`id`, `Section`.`category_id`, `Section`.`site_id`, `Section`.`main_article_id`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `I18n__slug`.`content` Like 'teleferico_del_teide' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`cancelled`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `I18n__slug`.`content` Like 'teleferico_teide_cerrado' | 1 | 1 | 2 | maybe slow |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 254 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`cancelled`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `I18n__name`.`content` Like 'Teleferico Teide Cerrado' | 0 | 0 | 3 | maybe slow |
SELECT `ArticleI18n`.`locale` FROM `vte_core`.`article_i18ns` AS `ArticleI18n` WHERE `ArticleI18n`.`model` = 'Article' AND `ArticleI18n`.`foreign_key` = 254 AND `ArticleI18n`.`field` = 'name' AND `ArticleI18n`.`content` <> '' | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `vte_core`.`languages` AS `Language` WHERE `Language`.`code3` IN ('spa', 'eng', 'deu', 'fra', 'ita', 'rus', 'pol', 'nld') AND `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Article`.`id` = 254 AND `I18n__name`.`content` <> '' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (254) | 0 | 0 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 254 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`sites` AS `Site` ON (`Section`.`site_id` = `Site`.`id`) LEFT JOIN `vte_core`.`categories` AS `Category` ON (`Section`.`category_id` = `Category`.`id`) LEFT JOIN `vte_core`.`articles` AS `MainArticle` ON (`Section`.`main_article_id` = `MainArticle`.`id`) LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Section`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`section_i18ns` AS `nameTranslation` WHERE `model` = 'Section' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (9) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`section_i18ns` AS `slugTranslation` WHERE `model` = 'Section' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (9) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 9 AND `ArticlesSection`.`article_id` = `Article`.`id`) | 11 | 11 | 0 | |
SELECT `Article`.`id`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Article`.`id` = 29 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (29) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (29) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (29) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 29 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `vte_core`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 | |