SELECTa0_.idASid_0,a0_.created_atAScreated_at_1,a0_.updated_atASupdated_at_2,a0_.published_atASpublished_at_3,a0_.slugASslug_4,a0_.titleAStitle_5,a0_.title_linkAStitle_link_6,a0_.shortTitleASshortTitle_7,a0_.subtitleASsubtitle_8,a0_.typeAStype_9,a0_.short_descriptionASshort_description_10,a0_.descriptionASdescription_11,a0_.description_startASdescription_start_12,a0_.image_altASimage_alt_13,a0_.image_titleASimage_title_14,a0_.visibilityASvisibility_15,a0_.autopublished_atASautopublished_at_16,a0_.sitemapASsitemap_17,a0_.robotsASrobots_18,a0_.canonicalAScanonical_19,a0_.authorASauthor_20,a0_.urlASurl_21,a0_.recruiterASrecruiter_22,a0_.companyAScompany_23,a0_.websiteASwebsite_24,a0_.localeASlocale_25,a0_.banner_titleASbanner_title_26,a0_.banner_descriptionASbanner_description_27,a0_.banner_linkASbanner_link_28,a0_.banner_buttonASbanner_button_29,a0_.pageslugASpageslug_30,a0_.pageslug2ASpageslug2_31,a0_.pageslug3ASpageslug3_32,a0_.onlyPageASonlyPage_33,a0_.onlyArticlesASonlyArticles_34,a0_.recruiterDirectoryASrecruiterDirectory_35,a0_.employerDirectoryASemployerDirectory_36,a0_.title_arianeAStitle_ariane_37,a0_.identifiantASidentifiant_38,a0_.keywordASkeyword_39,a0_.months_updateASmonths_update_40,a0_.volumeASvolume_41,a0_.links_infoASlinks_info_42,a0_.schema_infoASschema_info_43,a0_.video_infoASvideo_info_44,a0_.message_alertASmessage_alert_45,a0_.editor_htmlASeditor_html_46,a0_.image_nameASimage_name_47,a0_.image_original_nameASimage_original_name_48,a0_.image_mime_typeASimage_mime_type_49,a0_.image_sizeASimage_size_50,a0_.image_dimensionsASimage_dimensions_51,a0_.category_idAScategory_id_52,a0_.author_article_idASauthor_article_id_53FROMarticles_articlesa0_LEFT JOINarticles_articles_has_categoriesa1_ONa0_.category_id=a1_.idLEFT JOINarticles_articles_has_categoriesa2_ONa1_.category_id=a2_.idWHERE (a0_.visibility=1ANDa0_.published_atISNOTNULLANDa0_.website=1ANDa0_.locale=?ANDa0_.onlyArticles=1ANDa0_.recruiterDirectory=0) AND ((a0_.category_id=?ORa2_.id=?)) ORDER BYa0_.published_atDESC
SELECTa0_.idASid_0,a0_.created_atAScreated_at_1,a0_.updated_atASupdated_at_2,a0_.published_atASpublished_at_3,a0_.slugASslug_4,a0_.titleAStitle_5,a0_.title_linkAStitle_link_6,a0_.shortTitleASshortTitle_7,a0_.subtitleASsubtitle_8,a0_.typeAStype_9,a0_.short_descriptionASshort_description_10,a0_.descriptionASdescription_11,a0_.description_startASdescription_start_12,a0_.image_altASimage_alt_13,a0_.image_titleASimage_title_14,a0_.visibilityASvisibility_15,a0_.autopublished_atASautopublished_at_16,a0_.sitemapASsitemap_17,a0_.robotsASrobots_18,a0_.canonicalAScanonical_19,a0_.authorASauthor_20,a0_.urlASurl_21,a0_.recruiterASrecruiter_22,a0_.companyAScompany_23,a0_.websiteASwebsite_24,a0_.localeASlocale_25,a0_.banner_titleASbanner_title_26,a0_.banner_descriptionASbanner_description_27,a0_.banner_linkASbanner_link_28,a0_.banner_buttonASbanner_button_29,a0_.pageslugASpageslug_30,a0_.pageslug2ASpageslug2_31,a0_.pageslug3ASpageslug3_32,a0_.onlyPageASonlyPage_33,a0_.onlyArticlesASonlyArticles_34,a0_.recruiterDirectoryASrecruiterDirectory_35,a0_.employerDirectoryASemployerDirectory_36,a0_.title_arianeAStitle_ariane_37,a0_.identifiantASidentifiant_38,a0_.keywordASkeyword_39,a0_.months_updateASmonths_update_40,a0_.volumeASvolume_41,a0_.links_infoASlinks_info_42,a0_.schema_infoASschema_info_43,a0_.video_infoASvideo_info_44,a0_.message_alertASmessage_alert_45,a0_.editor_htmlASeditor_html_46,a0_.image_nameASimage_name_47,a0_.image_original_nameASimage_original_name_48,a0_.image_mime_typeASimage_mime_type_49,a0_.image_sizeASimage_size_50,a0_.image_dimensionsASimage_dimensions_51,a0_.category_idAScategory_id_52,a0_.author_article_idASauthor_article_id_53FROMarticles_articlesa0_LEFT JOINarticles_articles_has_categoriesa1_ONa0_.category_id=a1_.idLEFT JOINarticles_articles_has_categoriesa2_ONa1_.category_id=a2_.idWHERE
(
a0_.visibility=1ANDa0_.published_atISNOTNULLANDa0_.website=1ANDa0_.locale=?ANDa0_.onlyArticles=1ANDa0_.recruiterDirectory=0
)
AND (
(
a0_.category_id=?ORa2_.id=?
)
)
ORDER BYa0_.published_atDESC
SELECTa0_.idASid_0,a0_.created_atAScreated_at_1,a0_.updated_atASupdated_at_2,a0_.published_atASpublished_at_3,a0_.slugASslug_4,a0_.titleAStitle_5,a0_.title_linkAStitle_link_6,a0_.shortTitleASshortTitle_7,a0_.subtitleASsubtitle_8,a0_.typeAStype_9,a0_.short_descriptionASshort_description_10,a0_.descriptionASdescription_11,a0_.description_startASdescription_start_12,a0_.image_altASimage_alt_13,a0_.image_titleASimage_title_14,a0_.visibilityASvisibility_15,a0_.autopublished_atASautopublished_at_16,a0_.sitemapASsitemap_17,a0_.robotsASrobots_18,a0_.canonicalAScanonical_19,a0_.authorASauthor_20,a0_.urlASurl_21,a0_.recruiterASrecruiter_22,a0_.companyAScompany_23,a0_.websiteASwebsite_24,a0_.localeASlocale_25,a0_.banner_titleASbanner_title_26,a0_.banner_descriptionASbanner_description_27,a0_.banner_linkASbanner_link_28,a0_.banner_buttonASbanner_button_29,a0_.pageslugASpageslug_30,a0_.pageslug2ASpageslug2_31,a0_.pageslug3ASpageslug3_32,a0_.onlyPageASonlyPage_33,a0_.onlyArticlesASonlyArticles_34,a0_.recruiterDirectoryASrecruiterDirectory_35,a0_.employerDirectoryASemployerDirectory_36,a0_.title_arianeAStitle_ariane_37,a0_.identifiantASidentifiant_38,a0_.keywordASkeyword_39,a0_.months_updateASmonths_update_40,a0_.volumeASvolume_41,a0_.links_infoASlinks_info_42,a0_.schema_infoASschema_info_43,a0_.video_infoASvideo_info_44,a0_.message_alertASmessage_alert_45,a0_.editor_htmlASeditor_html_46,a0_.image_nameASimage_name_47,a0_.image_original_nameASimage_original_name_48,a0_.image_mime_typeASimage_mime_type_49,a0_.image_sizeASimage_size_50,a0_.image_dimensionsASimage_dimensions_51,a0_.category_idAScategory_id_52,a0_.author_article_idASauthor_article_id_53FROMarticles_articlesa0_LEFT JOINarticles_articles_has_categoriesa1_ONa0_.category_id=a1_.idLEFT JOINarticles_articles_has_categoriesa2_ONa1_.category_id=a2_.idWHERE (a0_.visibility=1ANDa0_.published_atISNOTNULLANDa0_.website=1ANDa0_.locale='en'ANDa0_.onlyArticles=1ANDa0_.recruiterDirectory=0) AND ((a0_.category_id=1ORa2_.id=1)) ORDER BYa0_.published_atDESC;