Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.date_created AS date_created_2, 
  t0.name AS name_3, 
  t0.url_name AS url_name_4, 
  t0.description AS description_5, 
  t0.logo_id AS logo_id_6, 
  t0.banner_id AS banner_id_7 
FROM 
  company_association t0 
WHERE 
  t0.url_name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.description AS description_5, t0.logo_id AS logo_id_6, t0.banner_id AS banner_id_7 FROM company_association t0 WHERE t0.url_name = 'marchepublicdelamitis' LIMIT 1;

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  c0_.website AS website_2, 
  c0_.description AS description_3, 
  c0_.speciality AS speciality_4, 
  c0_.average_delivery_time AS average_delivery_time_5, 
  c0_.taxe_tps AS taxe_tps_6, 
  c0_.taxe_tvx AS taxe_tvx_7, 
  c0_.company_number AS company_number_8, 
  c0_.number_of_sales AS number_of_sales_9, 
  c0_.total_sales_in_dollars AS total_sales_in_dollars_10, 
  c0_.date_created AS date_created_11, 
  c0_.custom_sale_conditions AS custom_sale_conditions_12, 
  c0_.conditions_shipping AS conditions_shipping_13, 
  c0_.conditions_return AS conditions_return_14, 
  c0_.conditions_cancel AS conditions_cancel_15, 
  c0_.terms_acceptance_date AS terms_acceptance_date_16, 
  c0_.terms_acceptance_ip AS terms_acceptance_ip_17, 
  c0_.solex_id AS solex_id_18, 
  c0_.store_made_by_maturin AS store_made_by_maturin_19, 
  c0_.terms_acceptance_finger_print AS terms_acceptance_finger_print_20, 
  c0_.inventory_last_update AS inventory_last_update_21, 
  c0_.show_publicly AS show_publicly_22, 
  c0_.custom_url AS custom_url_23, 
  c0_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_24, 
  c0_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_25, 
  c0_.export_colabor AS export_colabor_26, 
  c1_.id AS id_27, 
  c1_.country AS country_28, 
  c1_.currency AS currency_29, 
  c1_.account_number AS account_number_30, 
  c1_.account_transit AS account_transit_31, 
  c1_.account_institution AS account_institution_32, 
  c1_.account_other AS account_other_33, 
  c1_.company_owners AS company_owners_34, 
  c1_.legal_city AS legal_city_35, 
  c1_.legal_civic_number AS legal_civic_number_36, 
  c1_.legal_street_name AS legal_street_name_37, 
  c1_.legal_zip_code AS legal_zip_code_38, 
  c1_.legal_province AS legal_province_39, 
  c1_.legal_company_name AS legal_company_name_40, 
  c1_.legal_tax_id AS legal_tax_id_41, 
  c1_.legal_account_owner_dob AS legal_account_owner_dob_42, 
  c1_.legal_account_owner_first_name AS legal_account_owner_first_name_43, 
  c1_.legal_account_owner_last_name AS legal_account_owner_last_name_44, 
  c1_.legal_account_owner_city AS legal_account_owner_city_45, 
  c1_.legal_account_owner_civic_number AS legal_account_owner_civic_number_46, 
  c1_.legal_account_owner_street_name AS legal_account_owner_street_name_47, 
  c1_.legal_account_owner_zip_code AS legal_account_owner_zip_code_48, 
  c1_.legal_account_owner_id AS legal_account_owner_id_49, 
  c1_.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_50, 
  c1_.legal_account_owner_company_type AS legal_account_owner_company_type_51, 
  c1_.stripe_tosaccepted_date AS stripe_tosaccepted_date_52, 
  c1_.stripe_ip AS stripe_ip_53, 
  c1_.legal_account_owner_province AS legal_account_owner_province_54, 
  c1_.minimum_allowed AS minimum_allowed_55, 
  c1_.stripe_account_id AS stripe_account_id_56, 
  c1_.stripe_account_verified AS stripe_account_verified_57, 
  c2_.id AS id_58, 
  c2_.civic_number AS civic_number_59, 
  c2_.street_name AS street_name_60, 
  c2_.city AS city_61, 
  c2_.zip_code AS zip_code_62, 
  c2_.province AS province_63, 
  c2_.country AS country_64, 
  c2_.phone AS phone_65, 
  c2_.phone_extension AS phone_extension_66, 
  c2_.email AS email_67, 
  c2_.mobile_phone AS mobile_phone_68, 
  c2_.name AS name_69, 
  c2_.notes_for_buyer AS notes_for_buyer_70, 
  c2_.pick_up AS pick_up_71, 
  c2_.show_public AS show_public_72, 
  r3_.id AS id_73, 
  r3_.name AS name_74, 
  r3_.province AS province_75, 
  r3_.country AS country_76, 
  c4_.id AS id_77, 
  c4_.delivery_mail AS delivery_mail_78, 
  c4_.delivery_type AS delivery_type_79, 
  c4_.minimum_in_storage AS minimum_in_storage_80, 
  c4_.delivery_pick_up AS delivery_pick_up_81, 
  c4_.action_for_expired_product AS action_for_expired_product_82, 
  c0_.image_id AS image_id_83, 
  c0_.banner_id AS banner_id_84, 
  c0_.main_location_id AS main_location_id_85, 
  c0_.recruiter_id AS recruiter_id_86, 
  c0_.in_group_of_user_id AS in_group_of_user_id_87, 
  c1_.company_id AS company_id_88, 
  c1_.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_89, 
  c1_.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_90, 
  c2_.company_id AS company_id_91, 
  c2_.region_id AS region_id_92, 
  c4_.company_id AS company_id_93, 
  c4_.conservation_id AS conservation_id_94 
FROM 
  company c0_ 
  INNER JOIN company_location c5_ ON c0_.main_location_id = c5_.id 
  INNER JOIN company_association_company c7_ ON c0_.id = c7_.company_id 
  INNER JOIN company_association c6_ ON c6_.id = c7_.company_association_id 
  LEFT JOIN company_deposit c1_ ON c0_.id = c1_.company_id 
  LEFT JOIN company_location c2_ ON c0_.main_location_id = c2_.id 
  LEFT JOIN region r3_ ON c2_.region_id = r3_.id 
  LEFT JOIN company_default_shipping c4_ ON c0_.id = c4_.company_id 
WHERE 
  c6_.id = ? 
  AND c0_.show_publicly = 1 
ORDER BY 
  c5_.city ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.website AS website_2, c0_.description AS description_3, c0_.speciality AS speciality_4, c0_.average_delivery_time AS average_delivery_time_5, c0_.taxe_tps AS taxe_tps_6, c0_.taxe_tvx AS taxe_tvx_7, c0_.company_number AS company_number_8, c0_.number_of_sales AS number_of_sales_9, c0_.total_sales_in_dollars AS total_sales_in_dollars_10, c0_.date_created AS date_created_11, c0_.custom_sale_conditions AS custom_sale_conditions_12, c0_.conditions_shipping AS conditions_shipping_13, c0_.conditions_return AS conditions_return_14, c0_.conditions_cancel AS conditions_cancel_15, c0_.terms_acceptance_date AS terms_acceptance_date_16, c0_.terms_acceptance_ip AS terms_acceptance_ip_17, c0_.solex_id AS solex_id_18, c0_.store_made_by_maturin AS store_made_by_maturin_19, c0_.terms_acceptance_finger_print AS terms_acceptance_finger_print_20, c0_.inventory_last_update AS inventory_last_update_21, c0_.show_publicly AS show_publicly_22, c0_.custom_url AS custom_url_23, c0_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_24, c0_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_25, c0_.export_colabor AS export_colabor_26, c1_.id AS id_27, c1_.country AS country_28, c1_.currency AS currency_29, c1_.account_number AS account_number_30, c1_.account_transit AS account_transit_31, c1_.account_institution AS account_institution_32, c1_.account_other AS account_other_33, c1_.company_owners AS company_owners_34, c1_.legal_city AS legal_city_35, c1_.legal_civic_number AS legal_civic_number_36, c1_.legal_street_name AS legal_street_name_37, c1_.legal_zip_code AS legal_zip_code_38, c1_.legal_province AS legal_province_39, c1_.legal_company_name AS legal_company_name_40, c1_.legal_tax_id AS legal_tax_id_41, c1_.legal_account_owner_dob AS legal_account_owner_dob_42, c1_.legal_account_owner_first_name AS legal_account_owner_first_name_43, c1_.legal_account_owner_last_name AS legal_account_owner_last_name_44, c1_.legal_account_owner_city AS legal_account_owner_city_45, c1_.legal_account_owner_civic_number AS legal_account_owner_civic_number_46, c1_.legal_account_owner_street_name AS legal_account_owner_street_name_47, c1_.legal_account_owner_zip_code AS legal_account_owner_zip_code_48, c1_.legal_account_owner_id AS legal_account_owner_id_49, c1_.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_50, c1_.legal_account_owner_company_type AS legal_account_owner_company_type_51, c1_.stripe_tosaccepted_date AS stripe_tosaccepted_date_52, c1_.stripe_ip AS stripe_ip_53, c1_.legal_account_owner_province AS legal_account_owner_province_54, c1_.minimum_allowed AS minimum_allowed_55, c1_.stripe_account_id AS stripe_account_id_56, c1_.stripe_account_verified AS stripe_account_verified_57, c2_.id AS id_58, c2_.civic_number AS civic_number_59, c2_.street_name AS street_name_60, c2_.city AS city_61, c2_.zip_code AS zip_code_62, c2_.province AS province_63, c2_.country AS country_64, c2_.phone AS phone_65, c2_.phone_extension AS phone_extension_66, c2_.email AS email_67, c2_.mobile_phone AS mobile_phone_68, c2_.name AS name_69, c2_.notes_for_buyer AS notes_for_buyer_70, c2_.pick_up AS pick_up_71, c2_.show_public AS show_public_72, r3_.id AS id_73, r3_.name AS name_74, r3_.province AS province_75, r3_.country AS country_76, c4_.id AS id_77, c4_.delivery_mail AS delivery_mail_78, c4_.delivery_type AS delivery_type_79, c4_.minimum_in_storage AS minimum_in_storage_80, c4_.delivery_pick_up AS delivery_pick_up_81, c4_.action_for_expired_product AS action_for_expired_product_82, c0_.image_id AS image_id_83, c0_.banner_id AS banner_id_84, c0_.main_location_id AS main_location_id_85, c0_.recruiter_id AS recruiter_id_86, c0_.in_group_of_user_id AS in_group_of_user_id_87, c1_.company_id AS company_id_88, c1_.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_89, c1_.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_90, c2_.company_id AS company_id_91, c2_.region_id AS region_id_92, c4_.company_id AS company_id_93, c4_.conservation_id AS conservation_id_94 FROM company c0_ INNER JOIN company_location c5_ ON c0_.main_location_id = c5_.id INNER JOIN company_association_company c7_ ON c0_.id = c7_.company_id INNER JOIN company_association c6_ ON c6_.id = c7_.company_association_id LEFT JOIN company_deposit c1_ ON c0_.id = c1_.company_id LEFT JOIN company_location c2_ ON c0_.main_location_id = c2_.id LEFT JOIN region r3_ ON c2_.region_id = r3_.id LEFT JOIN company_default_shipping c4_ ON c0_.id = c4_.company_id WHERE c6_.id = 22 AND c0_.show_publicly = 1 ORDER BY c5_.city ASC;

SELECT 
  t0.id AS id_1, 
  t0.date_created AS date_created_2, 
  t0.name AS name_3, 
  t0.url_name AS url_name_4, 
  t0.description AS description_5, 
  t0.logo_id AS logo_id_6, 
  t0.banner_id AS banner_id_7 
FROM 
  company_association t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.description AS description_5, t0.logo_id AS logo_id_6, t0.banner_id AS banner_id_7 FROM company_association t0 WHERE t0.id = 22 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  date_created, stripe_token, stripe_response, 
  is_paid, solex_order_id, date_payment, 
  shipping_estimation_raw, shipping_maturin_cost, 
  shipping_maturin_carrier_name, 
  shipping_maturin_service_name, 
  shipping_maturin_estimated_date, 
  picking_and_packing_fee, payment_fee, 
  maturin_fee, taxes_products, taxes_maturin, 
  taxes_shipping_maturin, taxes_shipping_company, 
  taxes_packing, shipping_maturin_service_id, 
  solex_order_raw, maturin_tracking_info, 
  order_no, is_on_hold, just_in_time_email_sent, 
  reminder_sent, raw_distributor_billing, 
  taxes_products_calculations, taxes_shipping_maturin_calculations, 
  taxes_shipping_company_calculations, 
  taxes_packing_calculations, amount_saved_by_coupon, 
  shipping_signature_required, signature_mandatory, 
  extra_priority_points, warehouse_group_id, 
  is_refunded, refund_stripe_response, 
  note_from_buyer, is_bulk_order, 
  track_link, track_pod_status_id, 
  delivery_choice_date, pre_order, 
  pre_order_now, shipping_address_id, 
  user_id, used_coupon_id, logistic_invoice_id, 
  send_with_subscription_id, from_subscription_id
) 
VALUES 
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?
  )

INSERT INTO cart (date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id) VALUES ('2025-07-27 09:10:02', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'a:0:{}', NULL, 0, 0, 0, 'N;', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', 0, 0, 0, 0, NULL, 0, 'N;', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = '9jUGImv6E1nT2dxc823AvNVNDi5UYGoEyoyjvRWZwxg=<ENC>', account_transit = 'nCLjNlrlSxhIrRmZnQLY4pX1GsM5BQcsbjR6+/P6tXQ=<ENC>', account_institution = 'ZpIWlg4K1WLJyp7iNw8j0JuIwZNBSkSn0xxRFC4CS4A=<ENC>', legal_account_owner_first_name = 'YalDu3NGy1Ncs1h/Z2BpcJF4/9pM1TjGRh3usLdNV9E=<ENC>', legal_account_owner_last_name = 'Co3hy2AoL/5y7KPSHtPK+8aIfDLWp1JMFpzZBk+7dt4=<ENC>', stripe_account_id = 'WW5PnOPVri95AR34wYgtzbgAytF/CTNbOqAYSYVPaTWmvlByQowNPaJDQzQhjRLI<ENC>' WHERE id = 346;

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = 'pomngznK4l9gGVrmZGf9c41ZmnlxTQBPRvAj2v7yPYE=<ENC>', account_transit = 'USOncA6MQ9TjjRidHdbzs4QdkwJFPxv0raVbRqGJukI=<ENC>', account_institution = 'kBbkEv4WxCJY8tUHekMnMdXFIhFK0VZlXF6y+hjAQs4=<ENC>', legal_account_owner_first_name = 'wLPlT/I4Ms25D1VzoNn+vbi9cxmQc/QsRj6Qg1LHHds=<ENC>', legal_account_owner_last_name = 'SkOxrPG4gCivSZLF1lHrmnxqnGeU/rcKNe0F19XiATY=<ENC>', stripe_account_id = 'pko+VcvrWYQaHq9H5Rj0Ul6fFW35XfENNVYqJNjSSNqffxXDb/ov2TdS6465ijnw<ENC>' WHERE id = 310;

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = 'eTfE/pcaSAzQkBJkSBGBI2XpqUEAbZPAf3WUhaebBEM=<ENC>', account_transit = 'nM6KlOA071kr4vD+wFKhj31ZxNwBznNv9IAC2aTRFgk=<ENC>', account_institution = 'IciGIDYINj0jpxH/3DjIaOnxbgztKouc84KdSXs4qB4=<ENC>', legal_account_owner_first_name = '9T14N5PBSaszqz6XpPuHyDeVEOmgsxukzccCOyviCKU=<ENC>', legal_account_owner_last_name = 'sgcxdxOdBdiQyu1z6vY1Q1JYk4o9dac292jtxe4jsvI=<ENC>', stripe_account_id = '4PKiQttZJ7syQ56Vj+fWNKP2F9Cnud5nkUPy7hv8/PD3l9NYNrWx6P/pJxaDAKmN<ENC>' WHERE id = 382;

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = 'ZJ3/Ufv7zC+JtzxOGQ5oBbZDKFJIGNDzQIWvOJLxe4k=<ENC>', account_transit = 'r/74TwpkXfqigyxmVxa3BnZ0xos5ENmsocSjt7bnb3w=<ENC>', account_institution = '5X6lSodG2Nj9y6Gi6HWQiIeP/CkPZlkqmsOb23qzCE4=<ENC>', legal_account_owner_first_name = 'be9Nl1ymKyLNVPrtxJeGpbFybEHXFM1Dw+b0SrRlSX8=<ENC>', legal_account_owner_last_name = 'b0nTehif9Ts5yPAwFiRHhSXOC0CRj7n3Ba8WXHPYVNQ=<ENC>', stripe_account_id = 'WeL5AcMZt9bNfh1tPdIAfjy5nUP6fjhHfnFU5ohDaMfL+tA9RdXYKuH2KFBbZZLp<ENC>' WHERE id = 345;

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = 'wAeqNycpgs5mfvka1/weiIknG58PbeE/CA8Lu3s7e8w=<ENC>', account_transit = '9o2VE6mTLK3Bvuq40/my7Tquk4nsuYXnXWDv68qjlhg=<ENC>', account_institution = 'hl+JSmudofKegqbd2CXWk9YE2vZxUTa8CmmjeJs34QM=<ENC>', legal_account_owner_first_name = '0TKOZvVEUOaAuiuiqcbky2kqNYL0OF58lwQScRr28rM=<ENC>', legal_account_owner_last_name = 'o2dJSv4Qe08Mj/n3EBpMkx3gNAlzvDL+OYgVISYnoRQ4jhJOK8mzZqwff7Fpi7TN<ENC>', stripe_account_id = 'EYURO+6dgqs0GuODYsP+eo6O2vuzCNitgU0cbzBCpQblqWFfMGjv7szPUGg9mg6v<ENC>' WHERE id = 386;

UPDATE 
  company_deposit 
SET 
  account_number = ?, 
  account_transit = ?, 
  account_institution = ?, 
  legal_account_owner_first_name = ?, 
  legal_account_owner_last_name = ?, 
  stripe_account_id = ? 
WHERE 
  id = ?

UPDATE company_deposit SET account_number = 'TlVh5TYGl98tqcivZx7VQuPpQ7evR5SGGgWu56mXN9A=<ENC>', account_transit = 'gwCPzXr92PB9Yn2nU4E8xb4Z9YfgYW2rIxKJKFbIXmg=<ENC>', account_institution = 'QCi6YDU5/MfgSgHYvAcjUxHOkutgIuXouxnhSu0MAc4=<ENC>', legal_account_owner_first_name = 'ycTxtspadoP2FEFKNFWd7yzjtyZDAoqKHTCccZ5Cy8Y=<ENC>', legal_account_owner_last_name = 'duUZ2dRLn/s8hxOBX3YvVbvBRc56YnGM1fJU+Xm6AIw=<ENC>', stripe_account_id = '7zlc69D8YCn5hNRdPGPGHwKQ+KoymGgFPmRXrVXjHTssf0N7lPWFCJypxf++oL2e<ENC>' WHERE id = 322;

"COMMIT"

"COMMIT";

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  c0_.placement AS placement_2, 
  c0_.title AS title_3, 
  c0_.description AS description_4, 
  c0_.tier1maturin_fees_pc AS tier1maturin_fees_pc_5, 
  c0_.tier2maturin_fees_pc AS tier2maturin_fees_pc_6, 
  c0_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_7, 
  c0_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_8, 
  c0_.packing_fees_amount AS packing_fees_amount_9, 
  c0_.packing_supplies_fees_amount AS packing_supplies_fees_amount_10, 
  c0_.meta_description AS meta_description_11, 
  c0_.is_displayed_for_buyer AS is_displayed_for_buyer_12, 
  c1_.id AS id_13, 
  c1_.name AS name_14, 
  c1_.placement AS placement_15, 
  c1_.title AS title_16, 
  c1_.description AS description_17, 
  c1_.tier1maturin_fees_pc AS tier1maturin_fees_pc_18, 
  c1_.tier2maturin_fees_pc AS tier2maturin_fees_pc_19, 
  c1_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_20, 
  c1_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_21, 
  c1_.packing_fees_amount AS packing_fees_amount_22, 
  c1_.packing_supplies_fees_amount AS packing_supplies_fees_amount_23, 
  c1_.meta_description AS meta_description_24, 
  c1_.is_displayed_for_buyer AS is_displayed_for_buyer_25, 
  c2_.id AS id_26, 
  c2_.name AS name_27, 
  c2_.placement AS placement_28, 
  c2_.title AS title_29, 
  c2_.description AS description_30, 
  c2_.tier1maturin_fees_pc AS tier1maturin_fees_pc_31, 
  c2_.tier2maturin_fees_pc AS tier2maturin_fees_pc_32, 
  c2_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_33, 
  c2_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_34, 
  c2_.packing_fees_amount AS packing_fees_amount_35, 
  c2_.packing_supplies_fees_amount AS packing_supplies_fees_amount_36, 
  c2_.meta_description AS meta_description_37, 
  c2_.is_displayed_for_buyer AS is_displayed_for_buyer_38, 
  c3_.id AS id_39, 
  c3_.name AS name_40, 
  c3_.placement AS placement_41, 
  c3_.title AS title_42, 
  c3_.description AS description_43, 
  c3_.tier1maturin_fees_pc AS tier1maturin_fees_pc_44, 
  c3_.tier2maturin_fees_pc AS tier2maturin_fees_pc_45, 
  c3_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_46, 
  c3_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_47, 
  c3_.packing_fees_amount AS packing_fees_amount_48, 
  c3_.packing_supplies_fees_amount AS packing_supplies_fees_amount_49, 
  c3_.meta_description AS meta_description_50, 
  c3_.is_displayed_for_buyer AS is_displayed_for_buyer_51, 
  c4_.id AS id_52, 
  c4_.name AS name_53, 
  c4_.placement AS placement_54, 
  c4_.title AS title_55, 
  c4_.description AS description_56, 
  c4_.tier1maturin_fees_pc AS tier1maturin_fees_pc_57, 
  c4_.tier2maturin_fees_pc AS tier2maturin_fees_pc_58, 
  c4_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_59, 
  c4_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_60, 
  c4_.packing_fees_amount AS packing_fees_amount_61, 
  c4_.packing_supplies_fees_amount AS packing_supplies_fees_amount_62, 
  c4_.meta_description AS meta_description_63, 
  c4_.is_displayed_for_buyer AS is_displayed_for_buyer_64, 
  c5_.id AS id_65, 
  c5_.name AS name_66, 
  c5_.placement AS placement_67, 
  c5_.title AS title_68, 
  c5_.description AS description_69, 
  c5_.tier1maturin_fees_pc AS tier1maturin_fees_pc_70, 
  c5_.tier2maturin_fees_pc AS tier2maturin_fees_pc_71, 
  c5_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_72, 
  c5_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_73, 
  c5_.packing_fees_amount AS packing_fees_amount_74, 
  c5_.packing_supplies_fees_amount AS packing_supplies_fees_amount_75, 
  c5_.meta_description AS meta_description_76, 
  c5_.is_displayed_for_buyer AS is_displayed_for_buyer_77, 
  c6_.id AS id_78, 
  c6_.name AS name_79, 
  c6_.placement AS placement_80, 
  c6_.title AS title_81, 
  c6_.description AS description_82, 
  c6_.tier1maturin_fees_pc AS tier1maturin_fees_pc_83, 
  c6_.tier2maturin_fees_pc AS tier2maturin_fees_pc_84, 
  c6_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_85, 
  c6_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_86, 
  c6_.packing_fees_amount AS packing_fees_amount_87, 
  c6_.packing_supplies_fees_amount AS packing_supplies_fees_amount_88, 
  c6_.meta_description AS meta_description_89, 
  c6_.is_displayed_for_buyer AS is_displayed_for_buyer_90, 
  c7_.id AS id_91, 
  c7_.name AS name_92, 
  c7_.placement AS placement_93, 
  c7_.title AS title_94, 
  c7_.description AS description_95, 
  c7_.tier1maturin_fees_pc AS tier1maturin_fees_pc_96, 
  c7_.tier2maturin_fees_pc AS tier2maturin_fees_pc_97, 
  c7_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_98, 
  c7_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_99, 
  c7_.packing_fees_amount AS packing_fees_amount_100, 
  c7_.packing_supplies_fees_amount AS packing_supplies_fees_amount_101, 
  c7_.meta_description AS meta_description_102, 
  c7_.is_displayed_for_buyer AS is_displayed_for_buyer_103, 
  c8_.id AS id_104, 
  c8_.name AS name_105, 
  c8_.placement AS placement_106, 
  c8_.title AS title_107, 
  c8_.description AS description_108, 
  c8_.tier1maturin_fees_pc AS tier1maturin_fees_pc_109, 
  c8_.tier2maturin_fees_pc AS tier2maturin_fees_pc_110, 
  c8_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_111, 
  c8_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_112, 
  c8_.packing_fees_amount AS packing_fees_amount_113, 
  c8_.packing_supplies_fees_amount AS packing_supplies_fees_amount_114, 
  c8_.meta_description AS meta_description_115, 
  c8_.is_displayed_for_buyer AS is_displayed_for_buyer_116, 
  c9_.id AS id_117, 
  c9_.name AS name_118, 
  c9_.placement AS placement_119, 
  c9_.title AS title_120, 
  c9_.description AS description_121, 
  c9_.tier1maturin_fees_pc AS tier1maturin_fees_pc_122, 
  c9_.tier2maturin_fees_pc AS tier2maturin_fees_pc_123, 
  c9_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_124, 
  c9_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_125, 
  c9_.packing_fees_amount AS packing_fees_amount_126, 
  c9_.packing_supplies_fees_amount AS packing_supplies_fees_amount_127, 
  c9_.meta_description AS meta_description_128, 
  c9_.is_displayed_for_buyer AS is_displayed_for_buyer_129, 
  c10_.id AS id_130, 
  c10_.name AS name_131, 
  c10_.placement AS placement_132, 
  c10_.title AS title_133, 
  c10_.description AS description_134, 
  c10_.tier1maturin_fees_pc AS tier1maturin_fees_pc_135, 
  c10_.tier2maturin_fees_pc AS tier2maturin_fees_pc_136, 
  c10_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_137, 
  c10_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_138, 
  c10_.packing_fees_amount AS packing_fees_amount_139, 
  c10_.packing_supplies_fees_amount AS packing_supplies_fees_amount_140, 
  c10_.meta_description AS meta_description_141, 
  c10_.is_displayed_for_buyer AS is_displayed_for_buyer_142, 
  c11_.id AS id_143, 
  c11_.name AS name_144, 
  c11_.placement AS placement_145, 
  c11_.title AS title_146, 
  c11_.description AS description_147, 
  c11_.tier1maturin_fees_pc AS tier1maturin_fees_pc_148, 
  c11_.tier2maturin_fees_pc AS tier2maturin_fees_pc_149, 
  c11_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_150, 
  c11_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_151, 
  c11_.packing_fees_amount AS packing_fees_amount_152, 
  c11_.packing_supplies_fees_amount AS packing_supplies_fees_amount_153, 
  c11_.meta_description AS meta_description_154, 
  c11_.is_displayed_for_buyer AS is_displayed_for_buyer_155, 
  c12_.id AS id_156, 
  c12_.name AS name_157, 
  c12_.placement AS placement_158, 
  c12_.title AS title_159, 
  c12_.description AS description_160, 
  c12_.tier1maturin_fees_pc AS tier1maturin_fees_pc_161, 
  c12_.tier2maturin_fees_pc AS tier2maturin_fees_pc_162, 
  c12_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_163, 
  c12_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_164, 
  c12_.packing_fees_amount AS packing_fees_amount_165, 
  c12_.packing_supplies_fees_amount AS packing_supplies_fees_amount_166, 
  c12_.meta_description AS meta_description_167, 
  c12_.is_displayed_for_buyer AS is_displayed_for_buyer_168, 
  c13_.id AS id_169, 
  c13_.name AS name_170, 
  c13_.placement AS placement_171, 
  c13_.title AS title_172, 
  c13_.description AS description_173, 
  c13_.tier1maturin_fees_pc AS tier1maturin_fees_pc_174, 
  c13_.tier2maturin_fees_pc AS tier2maturin_fees_pc_175, 
  c13_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_176, 
  c13_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_177, 
  c13_.packing_fees_amount AS packing_fees_amount_178, 
  c13_.packing_supplies_fees_amount AS packing_supplies_fees_amount_179, 
  c13_.meta_description AS meta_description_180, 
  c13_.is_displayed_for_buyer AS is_displayed_for_buyer_181, 
  c14_.id AS id_182, 
  c14_.name AS name_183, 
  c14_.placement AS placement_184, 
  c14_.title AS title_185, 
  c14_.description AS description_186, 
  c14_.tier1maturin_fees_pc AS tier1maturin_fees_pc_187, 
  c14_.tier2maturin_fees_pc AS tier2maturin_fees_pc_188, 
  c14_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_189, 
  c14_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_190, 
  c14_.packing_fees_amount AS packing_fees_amount_191, 
  c14_.packing_supplies_fees_amount AS packing_supplies_fees_amount_192, 
  c14_.meta_description AS meta_description_193, 
  c14_.is_displayed_for_buyer AS is_displayed_for_buyer_194, 
  c15_.id AS id_195, 
  c15_.name AS name_196, 
  c15_.placement AS placement_197, 
  c15_.title AS title_198, 
  c15_.description AS description_199, 
  c15_.tier1maturin_fees_pc AS tier1maturin_fees_pc_200, 
  c15_.tier2maturin_fees_pc AS tier2maturin_fees_pc_201, 
  c15_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_202, 
  c15_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_203, 
  c15_.packing_fees_amount AS packing_fees_amount_204, 
  c15_.packing_supplies_fees_amount AS packing_supplies_fees_amount_205, 
  c15_.meta_description AS meta_description_206, 
  c15_.is_displayed_for_buyer AS is_displayed_for_buyer_207, 
  c16_.id AS id_208, 
  c16_.name AS name_209, 
  c16_.placement AS placement_210, 
  c16_.title AS title_211, 
  c16_.description AS description_212, 
  c16_.tier1maturin_fees_pc AS tier1maturin_fees_pc_213, 
  c16_.tier2maturin_fees_pc AS tier2maturin_fees_pc_214, 
  c16_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_215, 
  c16_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_216, 
  c16_.packing_fees_amount AS packing_fees_amount_217, 
  c16_.packing_supplies_fees_amount AS packing_supplies_fees_amount_218, 
  c16_.meta_description AS meta_description_219, 
  c16_.is_displayed_for_buyer AS is_displayed_for_buyer_220, 
  c0_.sub_category_id AS sub_category_id_221, 
  c0_.image_id AS image_id_222, 
  c0_.banner_id AS banner_id_223, 
  c1_.sub_category_id AS sub_category_id_224, 
  c1_.image_id AS image_id_225, 
  c1_.banner_id AS banner_id_226, 
  c2_.sub_category_id AS sub_category_id_227, 
  c2_.image_id AS image_id_228, 
  c2_.banner_id AS banner_id_229, 
  c3_.sub_category_id AS sub_category_id_230, 
  c3_.image_id AS image_id_231, 
  c3_.banner_id AS banner_id_232, 
  c4_.sub_category_id AS sub_category_id_233, 
  c4_.image_id AS image_id_234, 
  c4_.banner_id AS banner_id_235, 
  c5_.sub_category_id AS sub_category_id_236, 
  c5_.image_id AS image_id_237, 
  c5_.banner_id AS banner_id_238, 
  c6_.sub_category_id AS sub_category_id_239, 
  c6_.image_id AS image_id_240, 
  c6_.banner_id AS banner_id_241, 
  c7_.sub_category_id AS sub_category_id_242, 
  c7_.image_id AS image_id_243, 
  c7_.banner_id AS banner_id_244, 
  c8_.sub_category_id AS sub_category_id_245, 
  c8_.image_id AS image_id_246, 
  c8_.banner_id AS banner_id_247, 
  c9_.sub_category_id AS sub_category_id_248, 
  c9_.image_id AS image_id_249, 
  c9_.banner_id AS banner_id_250, 
  c10_.sub_category_id AS sub_category_id_251, 
  c10_.image_id AS image_id_252, 
  c10_.banner_id AS banner_id_253, 
  c11_.sub_category_id AS sub_category_id_254, 
  c11_.image_id AS image_id_255, 
  c11_.banner_id AS banner_id_256, 
  c12_.sub_category_id AS sub_category_id_257, 
  c12_.image_id AS image_id_258, 
  c12_.banner_id AS banner_id_259, 
  c13_.sub_category_id AS sub_category_id_260, 
  c13_.image_id AS image_id_261, 
  c13_.banner_id AS banner_id_262, 
  c14_.sub_category_id AS sub_category_id_263, 
  c14_.image_id AS image_id_264, 
  c14_.banner_id AS banner_id_265, 
  c15_.sub_category_id AS sub_category_id_266, 
  c15_.image_id AS image_id_267, 
  c15_.banner_id AS banner_id_268, 
  c16_.sub_category_id AS sub_category_id_269, 
  c16_.image_id AS image_id_270, 
  c16_.banner_id AS banner_id_271 
FROM 
  category c0_ 
  LEFT JOIN category c1_ ON c0_.sub_category_id = c1_.id 
  LEFT JOIN category c2_ ON c1_.sub_category_id = c2_.id 
  LEFT JOIN category c3_ ON c2_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN category c5_ ON c1_.id = c5_.sub_category_id 
  LEFT JOIN category c6_ ON c5_.id = c6_.sub_category_id 
  LEFT JOIN category c7_ ON c6_.id = c7_.sub_category_id 
  LEFT JOIN category c8_ ON c7_.id = c8_.sub_category_id 
  LEFT JOIN category c9_ ON c8_.id = c9_.sub_category_id 
  LEFT JOIN category c10_ ON c0_.id = c10_.sub_category_id 
  LEFT JOIN category c11_ ON c10_.id = c11_.sub_category_id 
  LEFT JOIN category c12_ ON c11_.id = c12_.sub_category_id 
  LEFT JOIN category c13_ ON c12_.id = c13_.sub_category_id 
  LEFT JOIN category c14_ ON c13_.id = c14_.sub_category_id 
  LEFT JOIN category c15_ ON c14_.id = c15_.sub_category_id 
  LEFT JOIN category c16_ ON c10_.sub_category_id = c16_.id 
WHERE 
  c0_.sub_category_id IS NULL 
ORDER BY 
  c0_.placement ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.placement AS placement_2, c0_.title AS title_3, c0_.description AS description_4, c0_.tier1maturin_fees_pc AS tier1maturin_fees_pc_5, c0_.tier2maturin_fees_pc AS tier2maturin_fees_pc_6, c0_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_7, c0_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_8, c0_.packing_fees_amount AS packing_fees_amount_9, c0_.packing_supplies_fees_amount AS packing_supplies_fees_amount_10, c0_.meta_description AS meta_description_11, c0_.is_displayed_for_buyer AS is_displayed_for_buyer_12, c1_.id AS id_13, c1_.name AS name_14, c1_.placement AS placement_15, c1_.title AS title_16, c1_.description AS description_17, c1_.tier1maturin_fees_pc AS tier1maturin_fees_pc_18, c1_.tier2maturin_fees_pc AS tier2maturin_fees_pc_19, c1_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_20, c1_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_21, c1_.packing_fees_amount AS packing_fees_amount_22, c1_.packing_supplies_fees_amount AS packing_supplies_fees_amount_23, c1_.meta_description AS meta_description_24, c1_.is_displayed_for_buyer AS is_displayed_for_buyer_25, c2_.id AS id_26, c2_.name AS name_27, c2_.placement AS placement_28, c2_.title AS title_29, c2_.description AS description_30, c2_.tier1maturin_fees_pc AS tier1maturin_fees_pc_31, c2_.tier2maturin_fees_pc AS tier2maturin_fees_pc_32, c2_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_33, c2_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_34, c2_.packing_fees_amount AS packing_fees_amount_35, c2_.packing_supplies_fees_amount AS packing_supplies_fees_amount_36, c2_.meta_description AS meta_description_37, c2_.is_displayed_for_buyer AS is_displayed_for_buyer_38, c3_.id AS id_39, c3_.name AS name_40, c3_.placement AS placement_41, c3_.title AS title_42, c3_.description AS description_43, c3_.tier1maturin_fees_pc AS tier1maturin_fees_pc_44, c3_.tier2maturin_fees_pc AS tier2maturin_fees_pc_45, c3_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_46, c3_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_47, c3_.packing_fees_amount AS packing_fees_amount_48, c3_.packing_supplies_fees_amount AS packing_supplies_fees_amount_49, c3_.meta_description AS meta_description_50, c3_.is_displayed_for_buyer AS is_displayed_for_buyer_51, c4_.id AS id_52, c4_.name AS name_53, c4_.placement AS placement_54, c4_.title AS title_55, c4_.description AS description_56, c4_.tier1maturin_fees_pc AS tier1maturin_fees_pc_57, c4_.tier2maturin_fees_pc AS tier2maturin_fees_pc_58, c4_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_59, c4_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_60, c4_.packing_fees_amount AS packing_fees_amount_61, c4_.packing_supplies_fees_amount AS packing_supplies_fees_amount_62, c4_.meta_description AS meta_description_63, c4_.is_displayed_for_buyer AS is_displayed_for_buyer_64, c5_.id AS id_65, c5_.name AS name_66, c5_.placement AS placement_67, c5_.title AS title_68, c5_.description AS description_69, c5_.tier1maturin_fees_pc AS tier1maturin_fees_pc_70, c5_.tier2maturin_fees_pc AS tier2maturin_fees_pc_71, c5_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_72, c5_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_73, c5_.packing_fees_amount AS packing_fees_amount_74, c5_.packing_supplies_fees_amount AS packing_supplies_fees_amount_75, c5_.meta_description AS meta_description_76, c5_.is_displayed_for_buyer AS is_displayed_for_buyer_77, c6_.id AS id_78, c6_.name AS name_79, c6_.placement AS placement_80, c6_.title AS title_81, c6_.description AS description_82, c6_.tier1maturin_fees_pc AS tier1maturin_fees_pc_83, c6_.tier2maturin_fees_pc AS tier2maturin_fees_pc_84, c6_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_85, c6_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_86, c6_.packing_fees_amount AS packing_fees_amount_87, c6_.packing_supplies_fees_amount AS packing_supplies_fees_amount_88, c6_.meta_description AS meta_description_89, c6_.is_displayed_for_buyer AS is_displayed_for_buyer_90, c7_.id AS id_91, c7_.name AS name_92, c7_.placement AS placement_93, c7_.title AS title_94, c7_.description AS description_95, c7_.tier1maturin_fees_pc AS tier1maturin_fees_pc_96, c7_.tier2maturin_fees_pc AS tier2maturin_fees_pc_97, c7_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_98, c7_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_99, c7_.packing_fees_amount AS packing_fees_amount_100, c7_.packing_supplies_fees_amount AS packing_supplies_fees_amount_101, c7_.meta_description AS meta_description_102, c7_.is_displayed_for_buyer AS is_displayed_for_buyer_103, c8_.id AS id_104, c8_.name AS name_105, c8_.placement AS placement_106, c8_.title AS title_107, c8_.description AS description_108, c8_.tier1maturin_fees_pc AS tier1maturin_fees_pc_109, c8_.tier2maturin_fees_pc AS tier2maturin_fees_pc_110, c8_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_111, c8_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_112, c8_.packing_fees_amount AS packing_fees_amount_113, c8_.packing_supplies_fees_amount AS packing_supplies_fees_amount_114, c8_.meta_description AS meta_description_115, c8_.is_displayed_for_buyer AS is_displayed_for_buyer_116, c9_.id AS id_117, c9_.name AS name_118, c9_.placement AS placement_119, c9_.title AS title_120, c9_.description AS description_121, c9_.tier1maturin_fees_pc AS tier1maturin_fees_pc_122, c9_.tier2maturin_fees_pc AS tier2maturin_fees_pc_123, c9_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_124, c9_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_125, c9_.packing_fees_amount AS packing_fees_amount_126, c9_.packing_supplies_fees_amount AS packing_supplies_fees_amount_127, c9_.meta_description AS meta_description_128, c9_.is_displayed_for_buyer AS is_displayed_for_buyer_129, c10_.id AS id_130, c10_.name AS name_131, c10_.placement AS placement_132, c10_.title AS title_133, c10_.description AS description_134, c10_.tier1maturin_fees_pc AS tier1maturin_fees_pc_135, c10_.tier2maturin_fees_pc AS tier2maturin_fees_pc_136, c10_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_137, c10_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_138, c10_.packing_fees_amount AS packing_fees_amount_139, c10_.packing_supplies_fees_amount AS packing_supplies_fees_amount_140, c10_.meta_description AS meta_description_141, c10_.is_displayed_for_buyer AS is_displayed_for_buyer_142, c11_.id AS id_143, c11_.name AS name_144, c11_.placement AS placement_145, c11_.title AS title_146, c11_.description AS description_147, c11_.tier1maturin_fees_pc AS tier1maturin_fees_pc_148, c11_.tier2maturin_fees_pc AS tier2maturin_fees_pc_149, c11_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_150, c11_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_151, c11_.packing_fees_amount AS packing_fees_amount_152, c11_.packing_supplies_fees_amount AS packing_supplies_fees_amount_153, c11_.meta_description AS meta_description_154, c11_.is_displayed_for_buyer AS is_displayed_for_buyer_155, c12_.id AS id_156, c12_.name AS name_157, c12_.placement AS placement_158, c12_.title AS title_159, c12_.description AS description_160, c12_.tier1maturin_fees_pc AS tier1maturin_fees_pc_161, c12_.tier2maturin_fees_pc AS tier2maturin_fees_pc_162, c12_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_163, c12_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_164, c12_.packing_fees_amount AS packing_fees_amount_165, c12_.packing_supplies_fees_amount AS packing_supplies_fees_amount_166, c12_.meta_description AS meta_description_167, c12_.is_displayed_for_buyer AS is_displayed_for_buyer_168, c13_.id AS id_169, c13_.name AS name_170, c13_.placement AS placement_171, c13_.title AS title_172, c13_.description AS description_173, c13_.tier1maturin_fees_pc AS tier1maturin_fees_pc_174, c13_.tier2maturin_fees_pc AS tier2maturin_fees_pc_175, c13_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_176, c13_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_177, c13_.packing_fees_amount AS packing_fees_amount_178, c13_.packing_supplies_fees_amount AS packing_supplies_fees_amount_179, c13_.meta_description AS meta_description_180, c13_.is_displayed_for_buyer AS is_displayed_for_buyer_181, c14_.id AS id_182, c14_.name AS name_183, c14_.placement AS placement_184, c14_.title AS title_185, c14_.description AS description_186, c14_.tier1maturin_fees_pc AS tier1maturin_fees_pc_187, c14_.tier2maturin_fees_pc AS tier2maturin_fees_pc_188, c14_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_189, c14_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_190, c14_.packing_fees_amount AS packing_fees_amount_191, c14_.packing_supplies_fees_amount AS packing_supplies_fees_amount_192, c14_.meta_description AS meta_description_193, c14_.is_displayed_for_buyer AS is_displayed_for_buyer_194, c15_.id AS id_195, c15_.name AS name_196, c15_.placement AS placement_197, c15_.title AS title_198, c15_.description AS description_199, c15_.tier1maturin_fees_pc AS tier1maturin_fees_pc_200, c15_.tier2maturin_fees_pc AS tier2maturin_fees_pc_201, c15_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_202, c15_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_203, c15_.packing_fees_amount AS packing_fees_amount_204, c15_.packing_supplies_fees_amount AS packing_supplies_fees_amount_205, c15_.meta_description AS meta_description_206, c15_.is_displayed_for_buyer AS is_displayed_for_buyer_207, c16_.id AS id_208, c16_.name AS name_209, c16_.placement AS placement_210, c16_.title AS title_211, c16_.description AS description_212, c16_.tier1maturin_fees_pc AS tier1maturin_fees_pc_213, c16_.tier2maturin_fees_pc AS tier2maturin_fees_pc_214, c16_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_215, c16_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_216, c16_.packing_fees_amount AS packing_fees_amount_217, c16_.packing_supplies_fees_amount AS packing_supplies_fees_amount_218, c16_.meta_description AS meta_description_219, c16_.is_displayed_for_buyer AS is_displayed_for_buyer_220, c0_.sub_category_id AS sub_category_id_221, c0_.image_id AS image_id_222, c0_.banner_id AS banner_id_223, c1_.sub_category_id AS sub_category_id_224, c1_.image_id AS image_id_225, c1_.banner_id AS banner_id_226, c2_.sub_category_id AS sub_category_id_227, c2_.image_id AS image_id_228, c2_.banner_id AS banner_id_229, c3_.sub_category_id AS sub_category_id_230, c3_.image_id AS image_id_231, c3_.banner_id AS banner_id_232, c4_.sub_category_id AS sub_category_id_233, c4_.image_id AS image_id_234, c4_.banner_id AS banner_id_235, c5_.sub_category_id AS sub_category_id_236, c5_.image_id AS image_id_237, c5_.banner_id AS banner_id_238, c6_.sub_category_id AS sub_category_id_239, c6_.image_id AS image_id_240, c6_.banner_id AS banner_id_241, c7_.sub_category_id AS sub_category_id_242, c7_.image_id AS image_id_243, c7_.banner_id AS banner_id_244, c8_.sub_category_id AS sub_category_id_245, c8_.image_id AS image_id_246, c8_.banner_id AS banner_id_247, c9_.sub_category_id AS sub_category_id_248, c9_.image_id AS image_id_249, c9_.banner_id AS banner_id_250, c10_.sub_category_id AS sub_category_id_251, c10_.image_id AS image_id_252, c10_.banner_id AS banner_id_253, c11_.sub_category_id AS sub_category_id_254, c11_.image_id AS image_id_255, c11_.banner_id AS banner_id_256, c12_.sub_category_id AS sub_category_id_257, c12_.image_id AS image_id_258, c12_.banner_id AS banner_id_259, c13_.sub_category_id AS sub_category_id_260, c13_.image_id AS image_id_261, c13_.banner_id AS banner_id_262, c14_.sub_category_id AS sub_category_id_263, c14_.image_id AS image_id_264, c14_.banner_id AS banner_id_265, c15_.sub_category_id AS sub_category_id_266, c15_.image_id AS image_id_267, c15_.banner_id AS banner_id_268, c16_.sub_category_id AS sub_category_id_269, c16_.image_id AS image_id_270, c16_.banner_id AS banner_id_271 FROM category c0_ LEFT JOIN category c1_ ON c0_.sub_category_id = c1_.id LEFT JOIN category c2_ ON c1_.sub_category_id = c2_.id LEFT JOIN category c3_ ON c2_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN category c5_ ON c1_.id = c5_.sub_category_id LEFT JOIN category c6_ ON c5_.id = c6_.sub_category_id LEFT JOIN category c7_ ON c6_.id = c7_.sub_category_id LEFT JOIN category c8_ ON c7_.id = c8_.sub_category_id LEFT JOIN category c9_ ON c8_.id = c9_.sub_category_id LEFT JOIN category c10_ ON c0_.id = c10_.sub_category_id LEFT JOIN category c11_ ON c10_.id = c11_.sub_category_id LEFT JOIN category c12_ ON c11_.id = c12_.sub_category_id LEFT JOIN category c13_ ON c12_.id = c13_.sub_category_id LEFT JOIN category c14_ ON c13_.id = c14_.sub_category_id LEFT JOIN category c15_ ON c14_.id = c15_.sub_category_id LEFT JOIN category c16_ ON c10_.sub_category_id = c16_.id WHERE c0_.sub_category_id IS NULL ORDER BY c0_.placement ASC;