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.be_createdASbe_created_36,t0.be_editedASbe_edited_37,t0.be_deletedASbe_deleted_38,t0.be_commentASbe_comment_39,t0.pdf_logo_idASpdf_logo_id_40,t41.idASid_42,t41.file_nameASfile_name_43,t41.physical_file_nameASphysical_file_name_44,t41.pathASpath_45,t41.typeAStype_46,t41.file_sizeASfile_size_47,t41.be_createdASbe_created_48,t41.be_editedASbe_edited_49,t41.be_deletedASbe_deleted_50,t41.be_commentASbe_comment_51,t41.be_ownerASbe_owner_52,t0.main_logo_idASmain_logo_id_53,t54.idASid_55,t54.file_nameASfile_name_56,t54.physical_file_nameASphysical_file_name_57,t54.pathASpath_58,t54.typeAStype_59,t54.file_sizeASfile_size_60,t54.be_createdASbe_created_61,t54.be_editedASbe_edited_62,t54.be_deletedASbe_deleted_63,t54.be_commentASbe_comment_64,t54.be_ownerASbe_owner_65,t0.nav_logo_idASnav_logo_id_66,t67.idASid_68,t67.file_nameASfile_name_69,t67.physical_file_nameASphysical_file_name_70,t67.pathASpath_71,t67.typeAStype_72,t67.file_sizeASfile_size_73,t67.be_createdASbe_created_74,t67.be_editedASbe_edited_75,t67.be_deletedASbe_deleted_76,t67.be_commentASbe_comment_77,t67.be_ownerASbe_owner_78,t0.be_ownerASbe_owner_79FROMplatform_clientst0LEFT JOINfilest41ONt0.pdf_logo_id=t41.idAND ((t41.be_deleted=0)) LEFT JOINfilest54ONt0.main_logo_id=t54.idAND ((t54.be_deleted=0)) LEFT JOINfilest67ONt0.nav_logo_id=t67.idAND ((t67.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.be_createdASbe_created_36,t0.be_editedASbe_edited_37,t0.be_deletedASbe_deleted_38,t0.be_commentASbe_comment_39,t0.pdf_logo_idASpdf_logo_id_40,t41.idASid_42,t41.file_nameASfile_name_43,t41.physical_file_nameASphysical_file_name_44,t41.pathASpath_45,t41.typeAStype_46,t41.file_sizeASfile_size_47,t41.be_createdASbe_created_48,t41.be_editedASbe_edited_49,t41.be_deletedASbe_deleted_50,t41.be_commentASbe_comment_51,t41.be_ownerASbe_owner_52,t0.main_logo_idASmain_logo_id_53,t54.idASid_55,t54.file_nameASfile_name_56,t54.physical_file_nameASphysical_file_name_57,t54.pathASpath_58,t54.typeAStype_59,t54.file_sizeASfile_size_60,t54.be_createdASbe_created_61,t54.be_editedASbe_edited_62,t54.be_deletedASbe_deleted_63,t54.be_commentASbe_comment_64,t54.be_ownerASbe_owner_65,t0.nav_logo_idASnav_logo_id_66,t67.idASid_68,t67.file_nameASfile_name_69,t67.physical_file_nameASphysical_file_name_70,t67.pathASpath_71,t67.typeAStype_72,t67.file_sizeASfile_size_73,t67.be_createdASbe_created_74,t67.be_editedASbe_edited_75,t67.be_deletedASbe_deleted_76,t67.be_commentASbe_comment_77,t67.be_ownerASbe_owner_78,t0.be_ownerASbe_owner_79FROMplatform_clientst0LEFT JOINfilest41ONt0.pdf_logo_id=t41.idAND (
(t41.be_deleted=0)
)
LEFT JOINfilest54ONt0.main_logo_id=t54.idAND (
(t54.be_deleted=0)
)
LEFT JOINfilest67ONt0.nav_logo_id=t67.idAND (
(t67.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.be_createdASbe_created_36,t0.be_editedASbe_edited_37,t0.be_deletedASbe_deleted_38,t0.be_commentASbe_comment_39,t0.pdf_logo_idASpdf_logo_id_40,t41.idASid_42,t41.file_nameASfile_name_43,t41.physical_file_nameASphysical_file_name_44,t41.pathASpath_45,t41.typeAStype_46,t41.file_sizeASfile_size_47,t41.be_createdASbe_created_48,t41.be_editedASbe_edited_49,t41.be_deletedASbe_deleted_50,t41.be_commentASbe_comment_51,t41.be_ownerASbe_owner_52,t0.main_logo_idASmain_logo_id_53,t54.idASid_55,t54.file_nameASfile_name_56,t54.physical_file_nameASphysical_file_name_57,t54.pathASpath_58,t54.typeAStype_59,t54.file_sizeASfile_size_60,t54.be_createdASbe_created_61,t54.be_editedASbe_edited_62,t54.be_deletedASbe_deleted_63,t54.be_commentASbe_comment_64,t54.be_ownerASbe_owner_65,t0.nav_logo_idASnav_logo_id_66,t67.idASid_68,t67.file_nameASfile_name_69,t67.physical_file_nameASphysical_file_name_70,t67.pathASpath_71,t67.typeAStype_72,t67.file_sizeASfile_size_73,t67.be_createdASbe_created_74,t67.be_editedASbe_edited_75,t67.be_deletedASbe_deleted_76,t67.be_commentASbe_comment_77,t67.be_ownerASbe_owner_78,t0.be_ownerASbe_owner_79FROMplatform_clientst0LEFT JOINfilest41ONt0.pdf_logo_id=t41.idAND ((t41.be_deleted=0)) LEFT JOINfilest54ONt0.main_logo_id=t54.idAND ((t54.be_deleted=0)) LEFT JOINfilest67ONt0.nav_logo_id=t67.idAND ((t67.be_deleted=0)) WHERE ((t0.be_deleted=0));