SELECTt0.idASid_1,t0.nameASname_2,t0.slugASslug_3,t0.legal_nameASlegal_name_4,t0.commercial_nameAScommercial_name_5,t0.siretASsiret_6,t0.vat_numberASvat_number_7,t0.hektor_idAShektor_id_8,t0.addressASaddress_9,t0.postal_codeASpostal_code_10,t0.cityAScity_11,t0.countryAScountry_12,t0.phoneASphone_13,t0.emailASemail_14,t0.website_urlASwebsite_url_15,t0.logo_urlASlogo_url_16,t0.primary_colorASprimary_color_17,t0.secondary_colorASsecondary_color_18,t0.google_business_urlASgoogle_business_url_19,t0.google_review_urlASgoogle_review_url_20,t0.linkedin_urlASlinkedin_url_21,t0.facebook_urlASfacebook_url_22,t0.instagram_urlASinstagram_url_23,t0.youtube_urlASyoutube_url_24,t0.latitudeASlatitude_25,t0.longitudeASlongitude_26,t0.statusASstatus_27,t0.seo_titleASseo_title_28,t0.seo_meta_descriptionASseo_meta_description_29,t0.seo_h1ASseo_h1_30,t0.seo_contentASseo_content_31,t0.created_atAScreated_at_32,t0.updated_atASupdated_at_33,t0.deleted_atASdeleted_at_34FROMagenciest0WHEREt0.status=?AND ((t0.deleted_atISNULL)) ORDER BYt0.nameASC
SELECTt0.idASid_1,t0.nameASname_2,t0.slugASslug_3,t0.legal_nameASlegal_name_4,t0.commercial_nameAScommercial_name_5,t0.siretASsiret_6,t0.vat_numberASvat_number_7,t0.hektor_idAShektor_id_8,t0.addressASaddress_9,t0.postal_codeASpostal_code_10,t0.cityAScity_11,t0.countryAScountry_12,t0.phoneASphone_13,t0.emailASemail_14,t0.website_urlASwebsite_url_15,t0.logo_urlASlogo_url_16,t0.primary_colorASprimary_color_17,t0.secondary_colorASsecondary_color_18,t0.google_business_urlASgoogle_business_url_19,t0.google_review_urlASgoogle_review_url_20,t0.linkedin_urlASlinkedin_url_21,t0.facebook_urlASfacebook_url_22,t0.instagram_urlASinstagram_url_23,t0.youtube_urlASyoutube_url_24,t0.latitudeASlatitude_25,t0.longitudeASlongitude_26,t0.statusASstatus_27,t0.seo_titleASseo_title_28,t0.seo_meta_descriptionASseo_meta_description_29,t0.seo_h1ASseo_h1_30,t0.seo_contentASseo_content_31,t0.created_atAScreated_at_32,t0.updated_atASupdated_at_33,t0.deleted_atASdeleted_at_34FROMagenciest0WHEREt0.status=?AND (
(t0.deleted_atISNULL)
)
ORDER BYt0.nameASC
SELECTt0.idASid_1,t0.nameASname_2,t0.slugASslug_3,t0.legal_nameASlegal_name_4,t0.commercial_nameAScommercial_name_5,t0.siretASsiret_6,t0.vat_numberASvat_number_7,t0.hektor_idAShektor_id_8,t0.addressASaddress_9,t0.postal_codeASpostal_code_10,t0.cityAScity_11,t0.countryAScountry_12,t0.phoneASphone_13,t0.emailASemail_14,t0.website_urlASwebsite_url_15,t0.logo_urlASlogo_url_16,t0.primary_colorASprimary_color_17,t0.secondary_colorASsecondary_color_18,t0.google_business_urlASgoogle_business_url_19,t0.google_review_urlASgoogle_review_url_20,t0.linkedin_urlASlinkedin_url_21,t0.facebook_urlASfacebook_url_22,t0.instagram_urlASinstagram_url_23,t0.youtube_urlASyoutube_url_24,t0.latitudeASlatitude_25,t0.longitudeASlongitude_26,t0.statusASstatus_27,t0.seo_titleASseo_title_28,t0.seo_meta_descriptionASseo_meta_description_29,t0.seo_h1ASseo_h1_30,t0.seo_contentASseo_content_31,t0.created_atAScreated_at_32,t0.updated_atASupdated_at_33,t0.deleted_atASdeleted_at_34FROMagenciest0WHEREt0.status='active'AND ((t0.deleted_atISNULL)) ORDER BYt0.nameASC;