SELECTt0.idASid_1,t0.nameASname_2,t0.pdf_sender_shortASpdf_sender_short_3,t0.pdf_sender_longASpdf_sender_long_4,t0.pdf_footerASpdf_footer_5,t0.pdf_confirmation_textASpdf_confirmation_text_6,t0.mail_sender_nameASmail_sender_name_7,t0.mail_sender_addressASmail_sender_address_8,t0.mail_bccASmail_bcc_9,t0.mail_reply_toASmail_reply_to_10,t0.mail_dsnASmail_dsn_11,t0.mail_footerASmail_footer_12,t0.info_noticeASinfo_notice_13,t0.info_supportASinfo_support_14,t0.car_type_personsAScar_type_persons_15,t0.order_time_offset_on_new_orderASorder_time_offset_on_new_order_16,t0.ignore_taxameter_for_payment_calcASignore_taxameter_for_payment_calc_17,t0.hide_prices_for_customerAShide_prices_for_customer_18,t0.alternate_job_list_viewASalternate_job_list_view_19,t0.extra_fieldsASextra_fields_20,t0.job_always_recalculate_customer_priceASjob_always_recalculate_customer_price_21,t0.deduct_km_on_fra_combi_ride_for_calcASdeduct_km_on_fra_combi_ride_for_calc_22,t0.km_secure_plus_if_gteASkm_secure_plus_if_gte_23,t0.km_secure_plusASkm_secure_plus_24,t0.add_taxi_geld_aufschlag_to_customer_priceASadd_taxi_geld_aufschlag_to_customer_price_25,t0.taxi_km_aufschlag_kurzstreckeAStaxi_km_aufschlag_kurzstrecke_26,t0.order_noticeASorder_notice_27,t0.spry_api_keyASspry_api_key_28,t0.stripe_api_keyASstripe_api_key_29,t0.stripe_public_keyASstripe_public_key_30,t0.sms_senderASsms_sender_31,t0.use_rating_mailASuse_rating_mail_32,t0.datenschutz_urlASdatenschutz_url_33,t0.member_order_export_textASmember_order_export_text_34,t0.member_order_export_detailedASmember_order_export_detailed_35,t0.dashboard_categoriesASdashboard_categories_36,t0.be_createdASbe_created_37,t0.be_editedASbe_edited_38,t0.be_deletedASbe_deleted_39,t0.be_commentASbe_comment_40,t0.pdf_logo_idASpdf_logo_id_41,t42.idASid_43,t42.file_nameASfile_name_44,t42.physical_file_nameASphysical_file_name_45,t42.pathASpath_46,t42.typeAStype_47,t42.file_sizeASfile_size_48,t42.be_createdASbe_created_49,t42.be_editedASbe_edited_50,t42.be_deletedASbe_deleted_51,t42.be_commentASbe_comment_52,t42.be_ownerASbe_owner_53,t0.main_logo_idASmain_logo_id_54,t55.idASid_56,t55.file_nameASfile_name_57,t55.physical_file_nameASphysical_file_name_58,t55.pathASpath_59,t55.typeAStype_60,t55.file_sizeASfile_size_61,t55.be_createdASbe_created_62,t55.be_editedASbe_edited_63,t55.be_deletedASbe_deleted_64,t55.be_commentASbe_comment_65,t55.be_ownerASbe_owner_66,t0.nav_logo_idASnav_logo_id_67,t68.idASid_69,t68.file_nameASfile_name_70,t68.physical_file_nameASphysical_file_name_71,t68.pathASpath_72,t68.typeAStype_73,t68.file_sizeASfile_size_74,t68.be_createdASbe_created_75,t68.be_editedASbe_edited_76,t68.be_deletedASbe_deleted_77,t68.be_commentASbe_comment_78,t68.be_ownerASbe_owner_79,t0.be_ownerASbe_owner_80FROMplatform_clientst0LEFT JOINfilest42ONt0.pdf_logo_id=t42.idAND ((t42.be_deleted=0)) LEFT JOINfilest55ONt0.main_logo_id=t55.idAND ((t55.be_deleted=0)) LEFT JOINfilest68ONt0.nav_logo_id=t68.idAND ((t68.be_deleted=0)) WHERE ((t0.be_deleted=0))
SELECTt0.idASid_1,t0.nameASname_2,t0.pdf_sender_shortASpdf_sender_short_3,t0.pdf_sender_longASpdf_sender_long_4,t0.pdf_footerASpdf_footer_5,t0.pdf_confirmation_textASpdf_confirmation_text_6,t0.mail_sender_nameASmail_sender_name_7,t0.mail_sender_addressASmail_sender_address_8,t0.mail_bccASmail_bcc_9,t0.mail_reply_toASmail_reply_to_10,t0.mail_dsnASmail_dsn_11,t0.mail_footerASmail_footer_12,t0.info_noticeASinfo_notice_13,t0.info_supportASinfo_support_14,t0.car_type_personsAScar_type_persons_15,t0.order_time_offset_on_new_orderASorder_time_offset_on_new_order_16,t0.ignore_taxameter_for_payment_calcASignore_taxameter_for_payment_calc_17,t0.hide_prices_for_customerAShide_prices_for_customer_18,t0.alternate_job_list_viewASalternate_job_list_view_19,t0.extra_fieldsASextra_fields_20,t0.job_always_recalculate_customer_priceASjob_always_recalculate_customer_price_21,t0.deduct_km_on_fra_combi_ride_for_calcASdeduct_km_on_fra_combi_ride_for_calc_22,t0.km_secure_plus_if_gteASkm_secure_plus_if_gte_23,t0.km_secure_plusASkm_secure_plus_24,t0.add_taxi_geld_aufschlag_to_customer_priceASadd_taxi_geld_aufschlag_to_customer_price_25,t0.taxi_km_aufschlag_kurzstreckeAStaxi_km_aufschlag_kurzstrecke_26,t0.order_noticeASorder_notice_27,t0.spry_api_keyASspry_api_key_28,t0.stripe_api_keyASstripe_api_key_29,t0.stripe_public_keyASstripe_public_key_30,t0.sms_senderASsms_sender_31,t0.use_rating_mailASuse_rating_mail_32,t0.datenschutz_urlASdatenschutz_url_33,t0.member_order_export_textASmember_order_export_text_34,t0.member_order_export_detailedASmember_order_export_detailed_35,t0.dashboard_categoriesASdashboard_categories_36,t0.be_createdASbe_created_37,t0.be_editedASbe_edited_38,t0.be_deletedASbe_deleted_39,t0.be_commentASbe_comment_40,t0.pdf_logo_idASpdf_logo_id_41,t42.idASid_43,t42.file_nameASfile_name_44,t42.physical_file_nameASphysical_file_name_45,t42.pathASpath_46,t42.typeAStype_47,t42.file_sizeASfile_size_48,t42.be_createdASbe_created_49,t42.be_editedASbe_edited_50,t42.be_deletedASbe_deleted_51,t42.be_commentASbe_comment_52,t42.be_ownerASbe_owner_53,t0.main_logo_idASmain_logo_id_54,t55.idASid_56,t55.file_nameASfile_name_57,t55.physical_file_nameASphysical_file_name_58,t55.pathASpath_59,t55.typeAStype_60,t55.file_sizeASfile_size_61,t55.be_createdASbe_created_62,t55.be_editedASbe_edited_63,t55.be_deletedASbe_deleted_64,t55.be_commentASbe_comment_65,t55.be_ownerASbe_owner_66,t0.nav_logo_idASnav_logo_id_67,t68.idASid_69,t68.file_nameASfile_name_70,t68.physical_file_nameASphysical_file_name_71,t68.pathASpath_72,t68.typeAStype_73,t68.file_sizeASfile_size_74,t68.be_createdASbe_created_75,t68.be_editedASbe_edited_76,t68.be_deletedASbe_deleted_77,t68.be_commentASbe_comment_78,t68.be_ownerASbe_owner_79,t0.be_ownerASbe_owner_80FROMplatform_clientst0LEFT JOINfilest42ONt0.pdf_logo_id=t42.idAND (
(t42.be_deleted=0)
)
LEFT JOINfilest55ONt0.main_logo_id=t55.idAND (
(t55.be_deleted=0)
)
LEFT JOINfilest68ONt0.nav_logo_id=t68.idAND (
(t68.be_deleted=0)
)
WHERE
(
(t0.be_deleted=0)
)
SELECTt0.idASid_1,t0.nameASname_2,t0.pdf_sender_shortASpdf_sender_short_3,t0.pdf_sender_longASpdf_sender_long_4,t0.pdf_footerASpdf_footer_5,t0.pdf_confirmation_textASpdf_confirmation_text_6,t0.mail_sender_nameASmail_sender_name_7,t0.mail_sender_addressASmail_sender_address_8,t0.mail_bccASmail_bcc_9,t0.mail_reply_toASmail_reply_to_10,t0.mail_dsnASmail_dsn_11,t0.mail_footerASmail_footer_12,t0.info_noticeASinfo_notice_13,t0.info_supportASinfo_support_14,t0.car_type_personsAScar_type_persons_15,t0.order_time_offset_on_new_orderASorder_time_offset_on_new_order_16,t0.ignore_taxameter_for_payment_calcASignore_taxameter_for_payment_calc_17,t0.hide_prices_for_customerAShide_prices_for_customer_18,t0.alternate_job_list_viewASalternate_job_list_view_19,t0.extra_fieldsASextra_fields_20,t0.job_always_recalculate_customer_priceASjob_always_recalculate_customer_price_21,t0.deduct_km_on_fra_combi_ride_for_calcASdeduct_km_on_fra_combi_ride_for_calc_22,t0.km_secure_plus_if_gteASkm_secure_plus_if_gte_23,t0.km_secure_plusASkm_secure_plus_24,t0.add_taxi_geld_aufschlag_to_customer_priceASadd_taxi_geld_aufschlag_to_customer_price_25,t0.taxi_km_aufschlag_kurzstreckeAStaxi_km_aufschlag_kurzstrecke_26,t0.order_noticeASorder_notice_27,t0.spry_api_keyASspry_api_key_28,t0.stripe_api_keyASstripe_api_key_29,t0.stripe_public_keyASstripe_public_key_30,t0.sms_senderASsms_sender_31,t0.use_rating_mailASuse_rating_mail_32,t0.datenschutz_urlASdatenschutz_url_33,t0.member_order_export_textASmember_order_export_text_34,t0.member_order_export_detailedASmember_order_export_detailed_35,t0.dashboard_categoriesASdashboard_categories_36,t0.be_createdASbe_created_37,t0.be_editedASbe_edited_38,t0.be_deletedASbe_deleted_39,t0.be_commentASbe_comment_40,t0.pdf_logo_idASpdf_logo_id_41,t42.idASid_43,t42.file_nameASfile_name_44,t42.physical_file_nameASphysical_file_name_45,t42.pathASpath_46,t42.typeAStype_47,t42.file_sizeASfile_size_48,t42.be_createdASbe_created_49,t42.be_editedASbe_edited_50,t42.be_deletedASbe_deleted_51,t42.be_commentASbe_comment_52,t42.be_ownerASbe_owner_53,t0.main_logo_idASmain_logo_id_54,t55.idASid_56,t55.file_nameASfile_name_57,t55.physical_file_nameASphysical_file_name_58,t55.pathASpath_59,t55.typeAStype_60,t55.file_sizeASfile_size_61,t55.be_createdASbe_created_62,t55.be_editedASbe_edited_63,t55.be_deletedASbe_deleted_64,t55.be_commentASbe_comment_65,t55.be_ownerASbe_owner_66,t0.nav_logo_idASnav_logo_id_67,t68.idASid_69,t68.file_nameASfile_name_70,t68.physical_file_nameASphysical_file_name_71,t68.pathASpath_72,t68.typeAStype_73,t68.file_sizeASfile_size_74,t68.be_createdASbe_created_75,t68.be_editedASbe_edited_76,t68.be_deletedASbe_deleted_77,t68.be_commentASbe_comment_78,t68.be_ownerASbe_owner_79,t0.be_ownerASbe_owner_80FROMplatform_clientst0LEFT JOINfilest42ONt0.pdf_logo_id=t42.idAND ((t42.be_deleted=0)) LEFT JOINfilest55ONt0.main_logo_id=t55.idAND ((t55.be_deleted=0)) LEFT JOINfilest68ONt0.nav_logo_id=t68.idAND ((t68.be_deleted=0)) WHERE ((t0.be_deleted=0));