Symfony Profiler

SELECT
  c0_.`id` AS id_0,
  c0_.`unid` AS unid_1,
  c0_.`code` AS code_2,
  c0_.`name` AS name_3,
  c0_.`alternate_name` AS alternate_name_4,
  c0_.`name_full` AS name_full_5,
  c0_.`url` AS url_6,
  c0_.`status` AS status_7,
  c0_.`type` AS type_8,
  c0_.`typeSet` AS typeSet_9,
  c0_.`pc_as_m` AS pc_as_m_10,
  c0_.`publish_date` AS publish_date_11,
  c0_.`update_date` AS update_date_12,
  c0_.`archive` AS archive_13,
  c0_.`pr_min_euro` AS pr_min_euro_14,
  c0_.`pr_min_euro_de` AS pr_min_euro_de_15,
  c0_.`pr_min_euro_at` AS pr_min_euro_at_16,
  c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17,
  c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18,
  c0_.`pr_min_euro_it` AS pr_min_euro_it_19,
  c0_.`pr_min_euro_be` AS pr_min_euro_be_20,
  c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21,
  c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22,
  c0_.`pr_min_euro_es` AS pr_min_euro_es_23,
  c0_.`pr_min_rub` AS pr_min_rub_24,
  c0_.`pr_min_rue` AS pr_min_rue_25,
  c0_.`pr_min_gbp` AS pr_min_gbp_26,
  c0_.`pr_min_gbe` AS pr_min_gbe_27,
  c0_.`pr_min_usd` AS pr_min_usd_28,
  c0_.`pr_min_use` AS pr_min_use_29,
  c0_.`pr_min_f_usd` AS pr_min_f_usd_30,
  c0_.`pr_min_f_use` AS pr_min_f_use_31,
  c0_.`pr_min_chf` AS pr_min_chf_32,
  c0_.`pr_min_che` AS pr_min_che_33,
  c0_.`pr_min_sek` AS pr_min_sek_34,
  c0_.`pr_min_see` AS pr_min_see_35,
  c0_.`pr_min_dkk` AS pr_min_dkk_36,
  c0_.`pr_min_dke` AS pr_min_dke_37,
  c0_.`pr_min_nok` AS pr_min_nok_38,
  c0_.`pr_min_noe` AS pr_min_noe_39,
  c0_.`pr_min_pln` AS pr_min_pln_40,
  c0_.`pr_min_ple` AS pr_min_ple_41,
  c0_.`pr_min_cad` AS pr_min_cad_42,
  c0_.`pr_min_cae` AS pr_min_cae_43,
  c0_.`pr_min_f_cad` AS pr_min_f_cad_44,
  c0_.`pr_min_f_cae` AS pr_min_f_cae_45,
  c0_.`pr_min_ed` AS pr_min_ed_46,
  c0_.`important` AS important_47,
  c0_.`author` AS author_48,
  c0_.`author_id` AS author_id_49,
  c0_.`rating` AS rating_50,
  c0_.`header` AS header_51,
  c0_.`settings` AS settings_52,
  c0_.`fids` AS fids_53,
  c0_.`portal_unid` AS portal_unid_54,
  c0_.`accepted_at` AS accepted_at_55,
  c0_.`accept_state` AS accept_state_56,
  c0_.`description_edit` AS description_edit_57,
  c0_.`link_award` AS link_award_58,
  c0_.`awards` AS awards_59,
  c0_.`video` AS video_60,
  c0_.`stated_at` AS stated_at_61,
  c0_.`state` AS state_62,
  c0_.`description_state` AS description_state_63,
  c0_.`body_hide` AS body_hide_64,
  c0_.`release_year` AS release_year_65,
  c0_.`site` AS site_66,
  c0_.`show_main` AS show_main_67,
  c0_.`glue_url` AS glue_url_68,
  c0_.`accessible` AS accessible_69,
  c0_.`delivery_suspended` AS delivery_suspended_70,
  c0_.`process` AS process_71,
  c0_.`exhibition` AS exhibition_72,
  c0_.`test_access` AS test_access_73,
  c0_.`views` AS views_74,
  c0_.`comment_unid` AS comment_unid_75,
  c0_.`accesible_at` AS accesible_at_76,
  c0_.`created_at` AS created_at_77,
  c0_.`updated_at` AS updated_at_78,
  f1_.`id` AS id_79,
  f1_.`unid` AS unid_80,
  f1_.`name` AS name_81,
  f1_.`name_inv` AS name_inv_82,
  f1_.`url` AS url_83,
  f1_.`alternate_name` AS alternate_name_84,
  f1_.`description_ru` AS description_ru_85,
  f1_.`description_en` AS description_en_86,
  f1_.`description_it` AS description_it_87,
  f1_.`description_es` AS description_es_88,
  f1_.`description_fr` AS description_fr_89,
  f1_.`description_de` AS description_de_90,
  f1_.`description_pt` AS description_pt_91,
  f1_.`description_pl` AS description_pl_92,
  f1_.`description_nl` AS description_nl_93,
  f1_.`description_fi` AS description_fi_94,
  f1_.`description_ua` AS description_ua_95,
  f1_.`description_sv` AS description_sv_96,
  f1_.`description_no` AS description_no_97,
  f1_.`description_da` AS description_da_98,
  f1_.`description_zh` AS description_zh_99,
  f1_.`delivery_time` AS delivery_time_100,
  f1_.`not_regular` AS not_regular_101,
  f1_.`suspended` AS suspended_102,
  f1_.`status` AS status_103,
  f1_.`type` AS type_104,
  f1_.`discount` AS discount_105,
  f1_.`discount_date_start` AS discount_date_start_106,
  f1_.`discount_date_end` AS discount_date_end_107,
  f1_.`transcription` AS transcription_108,
  f1_.`cost_delivery` AS cost_delivery_109,
  f1_.`create_date` AS create_date_110,
  f1_.`is_accepted` AS is_accepted_111,
  f1_.`accepted_at` AS accepted_at_112,
  f1_.`accept_state` AS accept_state_113,
  f1_.`description_edit` AS description_edit_114,
  f1_.`stated_at` AS stated_at_115,
  f1_.`state` AS state_116,
  f1_.`description_state` AS description_state_117,
  f1_.`video` AS video_118,
  f1_.`parser_address` AS parser_address_119,
  f1_.`accessible` AS accessible_120,
  f1_.`sound` AS sound_121,
  f1_.`test_access` AS test_access_122,
  f1_.`total_ideas` AS total_ideas_123,
  f1_.`votes_submit` AS votes_submit_124,
  f1_.`votes_stars` AS votes_stars_125,
  f1_.`brand_link` AS brand_link_126,
  f1_.`brand_logo` AS brand_logo_127,
  f1_.`no_send_portl_message` AS no_send_portl_message_128,
  l2_.`id` AS id_129,
  l2_.`code` AS code_130,
  l2_.`locale` AS locale_131,
  l2_.`phone_code` AS phone_code_132,
  l2_.`phone_mask` AS phone_mask_133,
  l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134,
  l2_.`zip_code_mask` AS zip_code_mask_135,
  l2_.`percent_vat` AS percent_vat_136,
  l2_.`name` AS name_137,
  l2_.`name_en` AS name_en_138,
  l2_.`alias` AS alias_139,
  l2_.`sort` AS sort_140,
  l2_.`count` AS count_141,
  l2_.`hide` AS hide_142,
  l2_.`important` AS important_143,
  l2_.`pay_pal_percent` AS pay_pal_percent_144,
  l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145,
  l2_.`vat` AS vat_146,
  l2_.`pv_type` AS pv_type_147,
  l2_.`capital_timezone_diff` AS capital_timezone_diff_148,
  l2_.`capital` AS capital_149,
  l2_.`free_sample_delivery` AS free_sample_delivery_150,
  l2_.`units` AS units_151
FROM
  `collection` c0_
  INNER JOIN `factory` f1_ ON c0_.factory = f1_.id
  INNER JOIN `list_country` l2_ ON f1_.country = l2_.id
WHERE
  f1_.`url` = ?
  AND c0_.`url` = ?
  AND c0_.`status` IN (?)
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
LIMIT
  1

SELECT c0_.`id` AS id_0, c0_.`unid` AS unid_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, c0_.`url` AS url_6, c0_.`status` AS status_7, c0_.`type` AS type_8, c0_.`typeSet` AS typeSet_9, c0_.`pc_as_m` AS pc_as_m_10, c0_.`publish_date` AS publish_date_11, c0_.`update_date` AS update_date_12, c0_.`archive` AS archive_13, c0_.`pr_min_euro` AS pr_min_euro_14, c0_.`pr_min_euro_de` AS pr_min_euro_de_15, c0_.`pr_min_euro_at` AS pr_min_euro_at_16, c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17, c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18, c0_.`pr_min_euro_it` AS pr_min_euro_it_19, c0_.`pr_min_euro_be` AS pr_min_euro_be_20, c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21, c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22, c0_.`pr_min_euro_es` AS pr_min_euro_es_23, c0_.`pr_min_rub` AS pr_min_rub_24, c0_.`pr_min_rue` AS pr_min_rue_25, c0_.`pr_min_gbp` AS pr_min_gbp_26, c0_.`pr_min_gbe` AS pr_min_gbe_27, c0_.`pr_min_usd` AS pr_min_usd_28, c0_.`pr_min_use` AS pr_min_use_29, c0_.`pr_min_f_usd` AS pr_min_f_usd_30, c0_.`pr_min_f_use` AS pr_min_f_use_31, c0_.`pr_min_chf` AS pr_min_chf_32, c0_.`pr_min_che` AS pr_min_che_33, c0_.`pr_min_sek` AS pr_min_sek_34, c0_.`pr_min_see` AS pr_min_see_35, c0_.`pr_min_dkk` AS pr_min_dkk_36, c0_.`pr_min_dke` AS pr_min_dke_37, c0_.`pr_min_nok` AS pr_min_nok_38, c0_.`pr_min_noe` AS pr_min_noe_39, c0_.`pr_min_pln` AS pr_min_pln_40, c0_.`pr_min_ple` AS pr_min_ple_41, c0_.`pr_min_cad` AS pr_min_cad_42, c0_.`pr_min_cae` AS pr_min_cae_43, c0_.`pr_min_f_cad` AS pr_min_f_cad_44, c0_.`pr_min_f_cae` AS pr_min_f_cae_45, c0_.`pr_min_ed` AS pr_min_ed_46, c0_.`important` AS important_47, c0_.`author` AS author_48, c0_.`author_id` AS author_id_49, c0_.`rating` AS rating_50, c0_.`header` AS header_51, c0_.`settings` AS settings_52, c0_.`fids` AS fids_53, c0_.`portal_unid` AS portal_unid_54, c0_.`accepted_at` AS accepted_at_55, c0_.`accept_state` AS accept_state_56, c0_.`description_edit` AS description_edit_57, c0_.`link_award` AS link_award_58, c0_.`awards` AS awards_59, c0_.`video` AS video_60, c0_.`stated_at` AS stated_at_61, c0_.`state` AS state_62, c0_.`description_state` AS description_state_63, c0_.`body_hide` AS body_hide_64, c0_.`release_year` AS release_year_65, c0_.`site` AS site_66, c0_.`show_main` AS show_main_67, c0_.`glue_url` AS glue_url_68, c0_.`accessible` AS accessible_69, c0_.`delivery_suspended` AS delivery_suspended_70, c0_.`process` AS process_71, c0_.`exhibition` AS exhibition_72, c0_.`test_access` AS test_access_73, c0_.`views` AS views_74, c0_.`comment_unid` AS comment_unid_75, c0_.`accesible_at` AS accesible_at_76, c0_.`created_at` AS created_at_77, c0_.`updated_at` AS updated_at_78, f1_.`id` AS id_79, f1_.`unid` AS unid_80, f1_.`name` AS name_81, f1_.`name_inv` AS name_inv_82, f1_.`url` AS url_83, f1_.`alternate_name` AS alternate_name_84, f1_.`description_ru` AS description_ru_85, f1_.`description_en` AS description_en_86, f1_.`description_it` AS description_it_87, f1_.`description_es` AS description_es_88, f1_.`description_fr` AS description_fr_89, f1_.`description_de` AS description_de_90, f1_.`description_pt` AS description_pt_91, f1_.`description_pl` AS description_pl_92, f1_.`description_nl` AS description_nl_93, f1_.`description_fi` AS description_fi_94, f1_.`description_ua` AS description_ua_95, f1_.`description_sv` AS description_sv_96, f1_.`description_no` AS description_no_97, f1_.`description_da` AS description_da_98, f1_.`description_zh` AS description_zh_99, f1_.`delivery_time` AS delivery_time_100, f1_.`not_regular` AS not_regular_101, f1_.`suspended` AS suspended_102, f1_.`status` AS status_103, f1_.`type` AS type_104, f1_.`discount` AS discount_105, f1_.`discount_date_start` AS discount_date_start_106, f1_.`discount_date_end` AS discount_date_end_107, f1_.`transcription` AS transcription_108, f1_.`cost_delivery` AS cost_delivery_109, f1_.`create_date` AS create_date_110, f1_.`is_accepted` AS is_accepted_111, f1_.`accepted_at` AS accepted_at_112, f1_.`accept_state` AS accept_state_113, f1_.`description_edit` AS description_edit_114, f1_.`stated_at` AS stated_at_115, f1_.`state` AS state_116, f1_.`description_state` AS description_state_117, f1_.`video` AS video_118, f1_.`parser_address` AS parser_address_119, f1_.`accessible` AS accessible_120, f1_.`sound` AS sound_121, f1_.`test_access` AS test_access_122, f1_.`total_ideas` AS total_ideas_123, f1_.`votes_submit` AS votes_submit_124, f1_.`votes_stars` AS votes_stars_125, f1_.`brand_link` AS brand_link_126, f1_.`brand_logo` AS brand_logo_127, f1_.`no_send_portl_message` AS no_send_portl_message_128, l2_.`id` AS id_129, l2_.`code` AS code_130, l2_.`locale` AS locale_131, l2_.`phone_code` AS phone_code_132, l2_.`phone_mask` AS phone_mask_133, l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134, l2_.`zip_code_mask` AS zip_code_mask_135, l2_.`percent_vat` AS percent_vat_136, l2_.`name` AS name_137, l2_.`name_en` AS name_en_138, l2_.`alias` AS alias_139, l2_.`sort` AS sort_140, l2_.`count` AS count_141, l2_.`hide` AS hide_142, l2_.`important` AS important_143, l2_.`pay_pal_percent` AS pay_pal_percent_144, l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145, l2_.`vat` AS vat_146, l2_.`pv_type` AS pv_type_147, l2_.`capital_timezone_diff` AS capital_timezone_diff_148, l2_.`capital` AS capital_149, l2_.`free_sample_delivery` AS free_sample_delivery_150, l2_.`units` AS units_151 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `list_country` l2_ ON f1_.country = l2_.id WHERE f1_.`url` = 'sartoria' AND c0_.`url` = 'vernici' AND c0_.`status` IN (1, 2, 3, 7, 4) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) LIMIT 1;

SELECT
  f0_.`id` AS id_0
FROM
  `geo_country` g1_
  LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id
  LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id
WHERE
  g1_.`code` = ?

SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = 'lu';

SELECT
  COUNT(a0_.`id`) AS sclr_0
FROM
  `article` a0_
  LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id
WHERE
  a0_.collection = ?
  AND a0_.`price_euro` > 0
  AND a0_.delivery <> 6
  AND a1_.`file` IS NOT NULL

SELECT COUNT(a0_.`id`) AS sclr_0 FROM `article` a0_ LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id WHERE a0_.collection = 3247975 AND a0_.`price_euro` > 0 AND a0_.delivery <> 6 AND a1_.`file` IS NOT NULL;

SELECT
  a.id
FROM
  article a
  LEFT JOIN list_type lt ON a.type = lt.id
  LEFT JOIN list_delivery ld ON a.delivery = ld.id
  LEFT JOIN list_measure lms ON a.measure = lms.id
  LEFT JOIN list_material lmt ON a.material = lmt.id
  LEFT JOIN list_surface lsf ON a.surface = lsf.id
  LEFT JOIN article_price_discount apd ON a.id = apd.article
  AND apd.price_euro > 0
  LEFT JOIN article_color ac ON a.id = ac.article_id
  LEFT JOIN article_factory_color afc ON a.id = afc.article_id
  LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id
  LEFT JOIN article_texture at ON a.id = at.article_id
  LEFT JOIN list_texture ltx ON ltx.id = at.texture_id
  LEFT JOIN list_style ls ON a.style = ls.id
  LEFT JOIN list_color lc ON lc.id = ac.color_id
  LEFT JOIN collection acl ON acl.id = a.collection
  LEFT JOIN factory acf ON acf.id = acl.factory
  LEFT JOIN list_country lcnt ON lcnt.id = acf.country
  LEFT JOIN article_motiv alm ON a.id = alm.article_id
  LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id
  LEFT JOIN list_shape lsh ON lsh.id = a.shape
  LEFT JOIN article_detail ad ON ad.article_id = a.id
WHERE
  a.collection IS NOT NULL
  AND (
    a.price_euro > 0
    OR ld.id = 6
  )
  AND ld.id <> 6
  AND ad.file IS NOT NULL
  AND a.collection = '3247975'
GROUP BY
  a.id
ORDER BY
  lfc.name ASC,
  lt.sort DESC,
  a.size_x DESC,
  a.size_y DESC,
  apd.price_euro DESC,
  apd.amount DESC,
  a.scheme ASC,
  lc.id,
  lms.id,
  a.thick,
  a.id DESC
LIMIT
  200000 OFFSET 0

SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_euro > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3247975' GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 200000 OFFSET 0;

SELECT
  a.id,
  a.code,
  a.name,
  a.not_sample,
  a.alternate_name,
  REPLACE(a.file, "~q~", "'") AS FILE,
  a.express_sample,
  a.variant_image,
  a.size_x,
  a.size_y,
  a.size_z,
  a.file_size2_x,
  a.file_size2_y,
  a.file_size3_x,
  a.file_size3_y,
  a.file_size8_x,
  a.file_size8_y,
  a.type_constraint,
  a.packaging_count,
  a.packaging_count_ft,
  a.packaging_count_pc,
  a.price_prx,
  a.pallet,
  a.pallet_ft,
  a.min_order,
  a.m2one_ps,
  a.multiple_pallet,
  a.urla,
  a.background_white,
  a.border_grey,
  a.image_setting,
  a.file_w,
  a.file_h,
  a.file_w4000,
  a.file_h4000,
  a.scheme,
  a.rotate,
  a.file_rotation,
  a.file_edit,
  a.comment_scheme_image,
  a.description_fr,
  a.description_en,
  ad.id AS ad_id,
  ad.file AS ad_file,
  ad.picture_in_title AS ad_picture_in_title,
  ad.gtin AS ad_gtin,
  ad.file_size1_x AS ad_file_size1_x,
  ad.file_size1_y AS ad_file_size1_y,
  ad.file_size2_x AS ad_file_size2_x,
  ad.file_size2_y AS ad_file_size2_y,
  ad.file_size3_x AS ad_file_size3_x,
  ad.file_size3_y AS ad_file_size3_y,
  ad.file_size8_x AS ad_file_size8_x,
  ad.file_size8_y AS ad_file_size8_y,
  ad.file_size500_x AS ad_file_size500_x,
  ad.file_size500_y AS ad_file_size500_y,
  ad.file_size740_x AS ad_file_size740_x,
  ad.file_size740_y AS ad_file_size740_y,
  ad.file_size1_x AS ad_file_size1_x,
  ad.file_size1_y AS ad_file_size1_y,
  ad.description_fr AS ad_description_fr,
  ad.description_en AS ad_description_en,
  ad.comment AS ad_comment,
  ad.file_edit AS ad_file_edit,
  ad.image_setting AS ad_image_setting,
  ad.file_w AS ad_file_w,
  ad.file_h AS ad_file_h,
  ad.file_w4000 AS ad_file_w4000,
  ad.file_h4000 AS ad_file_h4000,
  ad.comment_scheme_image AS ad_comment_scheme_image,
  ad.variant_image AS ad_variant_image,
  ad.file_rotation AS ad_file_rotation,
  ad.rotate AS ad_rotate,
  ad.type_painting AS ad_type_painting,
  ad.big_size_scheme AS ad_big_size_scheme,
  ld.id AS ld_id,
  lt.id AS lt_id,
  lt.alias AS lt_alias,
  lt.name AS lt_name,
  lms.id AS lms_id,
  lms.alias AS lms_alias,
  lms.name AS lms_name,
  lmt.id AS lmt_id,
  lmt.alias AS lmt_alias,
  lmt.name AS lmt_name,
  lsf.id AS lsf_id,
  lsf.alias AS lsf_alias,
  lsf.name AS lsf_name,
  lfc.id AS lfc_id,
  ltx.id AS ltx_id,
  ltx.alias AS ltx_alias,
  ltx.name AS ltx_name,
  ls.id AS ls_id,
  ls.alias AS ls_alias,
  ls.name AS ls_name,
  lsh.id AS lsh_id,
  lsh.alias AS lsh_alias,
  lsh.name AS lsh_name,
  llm.id AS llm_id,
  llm.alias AS llm_alias,
  llm.name AS llm_name,
  lmss.id AS lmss_id,
  lmss.alias AS lmss_alias,
  apd.id AS apd_id,
  apd.amount AS apd_amount,
  apd.amount_ft AS apd_amount_ft,
  apd.fold AS apd_fold,
  acl.id AS acl_id,
  acl.url AS acl_url,
  acl.name AS acl_name,
  acl.alternate_name AS acl_aname,
  acl.status AS acl_status,
  acl.process AS acl_process,
  acl.settings AS acl_settings,
  acf.id AS acf_id,
  acf.url AS acf_url,
  acf.name AS acf_name,
  acf.alternate_name AS acf_aname,
  acf.status AS acf_status,
  acf.suspended AS acf_suspended,
  acf.stated_at AS acf_stated_at,
  a.price_euro AS a_price_euro,
  a.price_mq_euro AS a_price_mq_euro,
  apd.price_euro AS apd_price_euro,
  acl.pr_min_euro AS acl_pr_min_euro,
  lcnt.id AS lcnt_id,
  lcnt.code AS lcnt_code,
  lcnt.alias AS lcnt_alias,
  lc.id AS lc_id,
  lc.name AS lc_name,
  lc.alias AS lc_alias
FROM
  article a
  LEFT JOIN list_type lt ON a.type = lt.id
  LEFT JOIN list_delivery ld ON a.delivery = ld.id
  LEFT JOIN list_measure lms ON a.measure = lms.id
  LEFT JOIN list_material lmt ON a.material = lmt.id
  LEFT JOIN list_surface lsf ON a.surface = lsf.id
  LEFT JOIN article_price_discount apd ON a.id = apd.article
  AND apd.price_euro > 0
  LEFT JOIN article_color ac ON a.id = ac.article_id
  LEFT JOIN list_color lc ON lc.id = ac.color_id
  LEFT JOIN article_factory_color afc ON a.id = afc.article_id
  LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id
  LEFT JOIN article_texture at ON a.id = at.article_id
  LEFT JOIN list_texture ltx ON ltx.id = at.texture_id
  LEFT JOIN list_style ls ON a.style = ls.id
  LEFT JOIN collection acl ON acl.id = a.collection
  LEFT JOIN factory acf ON acf.id = acl.factory
  LEFT JOIN list_country lcnt ON lcnt.id = acf.country
  LEFT JOIN article_motiv alm ON a.id = alm.article_id
  LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id
  LEFT JOIN list_shape lsh ON lsh.id = a.shape
  LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id
  LEFT JOIN article_detail ad ON ad.article_id = a.id
WHERE
  a.collection IS NOT NULL
  AND (
    a.price_euro > 0
    OR a.delivery = 6
  )
  AND ld.id <> 6
  AND ad.file IS NOT NULL
  AND a.collection = '3247975'
  AND a.id IN (
    '384343738', '835852894', '384343664',
    '835852861', '384343680', '835852891',
    '384343712', '835852849', '384343731',
    '835852879', '384343707', '835852840',
    '384343678', '835852834', '384343693',
    '835852819', '835852864', '384343711',
    '384343714', '835852870', '384343730',
    '835852831', '384343704', '835852882',
    '384343685', '835852855', '384343736',
    '835852825'
  )
ORDER BY
  lfc.name ASC,
  lt.sort DESC,
  a.size_x DESC,
  a.size_y DESC,
  apd.price_euro DESC,
  apd.amount DESC,
  a.scheme ASC,
  lc.id,
  lms.id,
  a.thick,
  a.id DESC

SELECT
                a.id,
                a.code,
                a.name,
                a.not_sample,
                a.alternate_name,
                REPLACE(a.file, "~q~", "'") AS FILE,
                a.express_sample,
                a.variant_image,
                a.size_x,
                a.size_y,
                a.size_z,
                a.file_size2_x,
                a.file_size2_y,
                a.file_size3_x,
                a.file_size3_y,
                a.file_size8_x,
                a.file_size8_y,
                a.type_constraint,
                a.packaging_count,
                a.packaging_count_ft,
                a.packaging_count_pc,
                a.price_prx,
                a.pallet,
                a.pallet_ft,
                a.min_order,
                a.m2one_ps,
                a.multiple_pallet,
                a.urla,
                a.background_white,
                a.border_grey,
                a.image_setting,
                a.file_w,
                a.file_h,
                a.file_w4000,
                a.file_h4000,
                a.scheme,
                a.rotate,
                a.file_rotation,
                a.file_edit,
                a.comment_scheme_image,
                a.description_fr,
                a.description_en,

                ad.id AS ad_id,
                ad.file AS ad_file,
                ad.picture_in_title AS ad_picture_in_title,
                ad.gtin AS ad_gtin,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.file_size2_x AS ad_file_size2_x,
                ad.file_size2_y AS ad_file_size2_y,
                ad.file_size3_x AS ad_file_size3_x,
                ad.file_size3_y AS ad_file_size3_y,
                ad.file_size8_x AS ad_file_size8_x,
                ad.file_size8_y AS ad_file_size8_y,
                ad.file_size500_x AS ad_file_size500_x,
                ad.file_size500_y AS ad_file_size500_y,
                ad.file_size740_x AS ad_file_size740_x,
                ad.file_size740_y AS ad_file_size740_y,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.description_fr AS ad_description_fr,
                ad.description_en AS ad_description_en,

                ad.comment AS ad_comment,
                ad.file_edit AS ad_file_edit,
                ad.image_setting AS ad_image_setting,
                ad.file_w AS ad_file_w,
                ad.file_h AS ad_file_h,
                ad.file_w4000 AS ad_file_w4000,
                ad.file_h4000 AS ad_file_h4000,
                ad.comment_scheme_image AS ad_comment_scheme_image,
                ad.variant_image AS ad_variant_image,
                ad.file_rotation AS ad_file_rotation,
                ad.rotate AS ad_rotate,
                ad.type_painting AS ad_type_painting,
                ad.big_size_scheme AS ad_big_size_scheme,

                ld.id AS ld_id,
                lt.id AS lt_id,
                lt.alias AS lt_alias,
                lt.name AS lt_name,
                lms.id AS lms_id,
                lms.alias AS lms_alias,
                lms.name AS lms_name,
                lmt.id AS lmt_id,
                lmt.alias AS lmt_alias,
                lmt.name AS lmt_name,
                lsf.id AS lsf_id,
                lsf.alias AS lsf_alias,
                lsf.name AS lsf_name,
                lfc.id AS lfc_id,
                ltx.id AS ltx_id,
                ltx.alias AS ltx_alias,
                ltx.name AS ltx_name,
                ls.id AS ls_id,
                ls.alias AS ls_alias,
                ls.name AS ls_name,
                lsh.id AS lsh_id,
                lsh.alias AS lsh_alias,
                lsh.name AS lsh_name,
                llm.id AS llm_id,
                llm.alias AS llm_alias,
                llm.name AS llm_name,
                lmss.id AS lmss_id,
                lmss.alias AS lmss_alias,
                apd.id AS apd_id,
                apd.amount AS apd_amount,
                apd.amount_ft AS apd_amount_ft,
                apd.fold AS apd_fold,
                acl.id AS acl_id,
                acl.url AS acl_url,
                acl.name AS acl_name,
                acl.alternate_name AS acl_aname,
                acl.status AS acl_status,
                acl.process AS acl_process,
                acl.settings AS acl_settings,
                acf.id AS acf_id,
                acf.url AS acf_url,
                acf.name AS acf_name,
                acf.alternate_name AS acf_aname,
                acf.status AS acf_status,
                acf.suspended AS acf_suspended,
                acf.stated_at AS acf_stated_at,
                a.price_euro AS a_price_euro, a.price_mq_euro AS a_price_mq_euro, apd.price_euro AS apd_price_euro, acl.pr_min_euro AS acl_pr_min_euro, 
                
                lcnt.id AS lcnt_id,
                lcnt.code AS lcnt_code,
                lcnt.alias AS lcnt_alias,
                lc.id AS lc_id,
                lc.name AS lc_name,
                lc.alias AS lc_alias
            FROM
                article a
            LEFT JOIN list_type lt ON a.type = lt.id
            LEFT JOIN list_delivery ld ON a.delivery = ld.id
            LEFT JOIN list_measure lms ON a.measure = lms.id
            LEFT JOIN list_material lmt ON a.material = lmt.id
            LEFT JOIN list_surface lsf ON a.surface = lsf.id
            LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_euro > 0
            LEFT JOIN article_color ac ON a.id = ac.article_id
            LEFT JOIN list_color lc ON lc.id = ac.color_id
            LEFT JOIN article_factory_color afc ON a.id = afc.article_id
            LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id
            LEFT JOIN article_texture at ON a.id = at.article_id
            LEFT JOIN list_texture ltx ON ltx.id = at.texture_id
            LEFT JOIN list_style ls ON a.style = ls.id
            LEFT JOIN collection acl ON acl.id = a.collection
            LEFT JOIN factory acf ON acf.id = acl.factory
            LEFT JOIN list_country lcnt ON lcnt.id = acf.country
            LEFT JOIN article_motiv alm ON a.id = alm.article_id
            LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id
            LEFT JOIN list_shape lsh ON lsh.id = a.shape
            LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id
            LEFT JOIN article_detail ad         ON ad.article_id = a.id

            
            WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL  AND a.collection = '3247975' AND a.id IN ('384343738','835852894','384343664','835852861','384343680','835852891','384343712','835852849','384343731','835852879','384343707','835852840','384343678','835852834','384343693','835852819','835852864','384343711','384343714','835852870','384343730','835852831','384343704','835852882','384343685','835852855','384343736','835852825') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC  ;