| 1 |
0.52 ms |
SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = ? AND b2_.`status` <> 12 AND a0_.collection = ? ORDER BY b1_.`amount` DESC
Parameters: [
"abd967c59246026bad734a2f066a2258f343eea4c81d03c0fcc7aaf5e1e6f656"
3244974
]
SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = 'abd967c59246026bad734a2f066a2258f343eea4c81d03c0fcc7aaf5e1e6f656' AND b2_.`status` <> 12 AND a0_.collection = 3244974 ORDER BY b1_.`amount` DESC;
|
| 2 |
6.17 ms |
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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') 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 20 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_usd > 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 = '3244974'
AND a.id IN (
'600709211',
'600708426',
'600708471',
'600708486',
'600708491',
'600708596',
'600708696',
'600708781',
'600708856',
'600708926',
'600708931',
'600708951',
'600709011',
'600709221',
'600709226',
'600709481',
'600709706',
'600709801',
'600709881',
'600709901',
'600709016',
'600708331',
'600708376',
'600708396',
'600708496',
'600708656',
'600709031',
'600709186',
'600709216',
'600709351',
'600709406',
'600709541',
'600709546',
'600709601',
'600709696',
'600709791',
'600709851',
'600709891',
'524138844',
'524138842',
'524138824',
'524138810',
'524138812',
'524138813',
'524138819',
'600708851',
'600709096',
'600709511',
'600708551',
'600709416',
'600709426',
'600709486',
'600709861',
'772722349',
'772722535',
'772722547',
'772722553',
'772722604',
'772722622',
'772722637',
'772722700',
'772722718',
'772722793',
'772722832',
'772722889',
'772722949',
'772723000',
'772723006',
'772723099',
'772723132',
'772723138',
'772723216',
'772723306',
'524138801',
'524138805',
'524138827',
'524138835',
'960164125',
'960177463',
'960181570',
'960200389',
'960237562',
'960389662',
'960404566',
'960401566',
'524138795',
'524138804',
'524138811',
'524138816',
'524138821',
'524138823',
'524138828',
'524138834',
'524138840',
'524138848',
'960226921',
'960249340',
'960289441',
'960370036',
'159918140',
'159918129',
'600709646',
'600708461',
'600708701',
'600709046',
'600709231',
'600709391',
'600709431',
'600709496',
'600709666',
'600709731',
'600709821',
'600708326',
'600708401',
'600708411',
'600708456',
'600708521',
'600708626',
'600708706',
'600708756',
'600708796',
'600708891',
'600708921',
'600709056',
'600709091',
'600709101',
'600709521',
'600709531',
'600709686',
'600709831',
'600709876',
'600709961',
'600708506',
'600708516',
'600708911',
'600709206',
'600709476',
'600709501',
'600709726',
'600709741',
'600709786',
'600709806',
'772722667',
'772722829',
'772723048',
'772723192'
)
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
20 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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') 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 20 OFFSET 0;
|
| 3 |
3.42 ms |
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_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_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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') AND a.id IN ('960164125','772723138','600709861','772722622','960177463','772722637','600709416','772722535','600709541','600708781','600708696','600709666','600709686','600708706','600709501','600709791','600709011','600709186','600708856','600708701') 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_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_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_usd > 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 = '3244974'
AND a.id IN (
'600709211',
'600708426',
'600708471',
'600708486',
'600708491',
'600708596',
'600708696',
'600708781',
'600708856',
'600708926',
'600708931',
'600708951',
'600709011',
'600709221',
'600709226',
'600709481',
'600709706',
'600709801',
'600709881',
'600709901',
'600709016',
'600708331',
'600708376',
'600708396',
'600708496',
'600708656',
'600709031',
'600709186',
'600709216',
'600709351',
'600709406',
'600709541',
'600709546',
'600709601',
'600709696',
'600709791',
'600709851',
'600709891',
'524138844',
'524138842',
'524138824',
'524138810',
'524138812',
'524138813',
'524138819',
'600708851',
'600709096',
'600709511',
'600708551',
'600709416',
'600709426',
'600709486',
'600709861',
'772722349',
'772722535',
'772722547',
'772722553',
'772722604',
'772722622',
'772722637',
'772722700',
'772722718',
'772722793',
'772722832',
'772722889',
'772722949',
'772723000',
'772723006',
'772723099',
'772723132',
'772723138',
'772723216',
'772723306',
'524138801',
'524138805',
'524138827',
'524138835',
'960164125',
'960177463',
'960181570',
'960200389',
'960237562',
'960389662',
'960404566',
'960401566',
'524138795',
'524138804',
'524138811',
'524138816',
'524138821',
'524138823',
'524138828',
'524138834',
'524138840',
'524138848',
'960226921',
'960249340',
'960289441',
'960370036',
'159918140',
'159918129',
'600709646',
'600708461',
'600708701',
'600709046',
'600709231',
'600709391',
'600709431',
'600709496',
'600709666',
'600709731',
'600709821',
'600708326',
'600708401',
'600708411',
'600708456',
'600708521',
'600708626',
'600708706',
'600708756',
'600708796',
'600708891',
'600708921',
'600709056',
'600709091',
'600709101',
'600709521',
'600709531',
'600709686',
'600709831',
'600709876',
'600709961',
'600708506',
'600708516',
'600708911',
'600709206',
'600709476',
'600709501',
'600709726',
'600709741',
'600709786',
'600709806',
'772722667',
'772722829',
'772723048',
'772723192'
)
AND a.id IN (
'960164125', '772723138', '600709861',
'772722622', '960177463', '772722637',
'600709416', '772722535', '600709541',
'600708781', '600708696', '600709666',
'600709686', '600708706', '600709501',
'600709791', '600709011', '600709186',
'600708856', '600708701'
)
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_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_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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') AND a.id IN ('960164125','772723138','600709861','772722622','960177463','772722637','600709416','772722535','600709541','600708781','600708696','600709666','600709686','600708706','600709501','600709791','600709011','600709186','600708856','600708701') 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 ;
|
| 4 |
0.22 ms |
SELECT t0.`id` AS id_1, t0.`currency` AS currency_2, t0.`val` AS val_3 FROM `currency_rate` t0 WHERE t0.`currency` = ? LIMIT 1
SELECT t0.`id` AS id_1, t0.`currency` AS currency_2, t0.`val` AS val_3 FROM `currency_rate` t0 WHERE t0.`currency` = 'HKD' LIMIT 1;
|
| 5 |
5.63 ms |
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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') 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 1 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_usd > 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 = '3244974'
AND a.id IN (
'600709211',
'600708426',
'600708471',
'600708486',
'600708491',
'600708596',
'600708696',
'600708781',
'600708856',
'600708926',
'600708931',
'600708951',
'600709011',
'600709221',
'600709226',
'600709481',
'600709706',
'600709801',
'600709881',
'600709901',
'600709016',
'600708331',
'600708376',
'600708396',
'600708496',
'600708656',
'600709031',
'600709186',
'600709216',
'600709351',
'600709406',
'600709541',
'600709546',
'600709601',
'600709696',
'600709791',
'600709851',
'600709891',
'524138844',
'524138842',
'524138824',
'524138810',
'524138812',
'524138813',
'524138819',
'600708851',
'600709096',
'600709511',
'600708551',
'600709416',
'600709426',
'600709486',
'600709861',
'772722349',
'772722535',
'772722547',
'772722553',
'772722604',
'772722622',
'772722637',
'772722700',
'772722718',
'772722793',
'772722832',
'772722889',
'772722949',
'772723000',
'772723006',
'772723099',
'772723132',
'772723138',
'772723216',
'772723306',
'524138801',
'524138805',
'524138827',
'524138835',
'960164125',
'960177463',
'960181570',
'960200389',
'960237562',
'960389662',
'960404566',
'960401566',
'524138795',
'524138804',
'524138811',
'524138816',
'524138821',
'524138823',
'524138828',
'524138834',
'524138840',
'524138848',
'960226921',
'960249340',
'960289441',
'960370036',
'159918140',
'159918129',
'600709646',
'600708461',
'600708701',
'600709046',
'600709231',
'600709391',
'600709431',
'600709496',
'600709666',
'600709731',
'600709821',
'600708326',
'600708401',
'600708411',
'600708456',
'600708521',
'600708626',
'600708706',
'600708756',
'600708796',
'600708891',
'600708921',
'600709056',
'600709091',
'600709101',
'600709521',
'600709531',
'600709686',
'600709831',
'600709876',
'600709961',
'600708506',
'600708516',
'600708911',
'600709206',
'600709476',
'600709501',
'600709726',
'600709741',
'600709786',
'600709806',
'772722667',
'772722829',
'772723048',
'772723192'
)
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
1 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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') 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 1 OFFSET 0;
|
| 6 |
2.06 ms |
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_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_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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') AND a.id IN ('960164125') 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_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_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_usd > 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 = '3244974'
AND a.id IN (
'600709211',
'600708426',
'600708471',
'600708486',
'600708491',
'600708596',
'600708696',
'600708781',
'600708856',
'600708926',
'600708931',
'600708951',
'600709011',
'600709221',
'600709226',
'600709481',
'600709706',
'600709801',
'600709881',
'600709901',
'600709016',
'600708331',
'600708376',
'600708396',
'600708496',
'600708656',
'600709031',
'600709186',
'600709216',
'600709351',
'600709406',
'600709541',
'600709546',
'600709601',
'600709696',
'600709791',
'600709851',
'600709891',
'524138844',
'524138842',
'524138824',
'524138810',
'524138812',
'524138813',
'524138819',
'600708851',
'600709096',
'600709511',
'600708551',
'600709416',
'600709426',
'600709486',
'600709861',
'772722349',
'772722535',
'772722547',
'772722553',
'772722604',
'772722622',
'772722637',
'772722700',
'772722718',
'772722793',
'772722832',
'772722889',
'772722949',
'772723000',
'772723006',
'772723099',
'772723132',
'772723138',
'772723216',
'772723306',
'524138801',
'524138805',
'524138827',
'524138835',
'960164125',
'960177463',
'960181570',
'960200389',
'960237562',
'960389662',
'960404566',
'960401566',
'524138795',
'524138804',
'524138811',
'524138816',
'524138821',
'524138823',
'524138828',
'524138834',
'524138840',
'524138848',
'960226921',
'960249340',
'960289441',
'960370036',
'159918140',
'159918129',
'600709646',
'600708461',
'600708701',
'600709046',
'600709231',
'600709391',
'600709431',
'600709496',
'600709666',
'600709731',
'600709821',
'600708326',
'600708401',
'600708411',
'600708456',
'600708521',
'600708626',
'600708706',
'600708756',
'600708796',
'600708891',
'600708921',
'600709056',
'600709091',
'600709101',
'600709521',
'600709531',
'600709686',
'600709831',
'600709876',
'600709961',
'600708506',
'600708516',
'600708911',
'600709206',
'600709476',
'600709501',
'600709726',
'600709741',
'600709786',
'600709806',
'772722667',
'772722829',
'772723048',
'772723192'
)
AND a.id IN ('960164125')
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_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_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_usd > 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 = '3244974' AND a.id IN ('600709211','600708426','600708471','600708486','600708491','600708596','600708696','600708781','600708856','600708926','600708931','600708951','600709011','600709221','600709226','600709481','600709706','600709801','600709881','600709901','600709016','600708331','600708376','600708396','600708496','600708656','600709031','600709186','600709216','600709351','600709406','600709541','600709546','600709601','600709696','600709791','600709851','600709891','524138844','524138842','524138824','524138810','524138812','524138813','524138819','600708851','600709096','600709511','600708551','600709416','600709426','600709486','600709861','772722349','772722535','772722547','772722553','772722604','772722622','772722637','772722700','772722718','772722793','772722832','772722889','772722949','772723000','772723006','772723099','772723132','772723138','772723216','772723306','524138801','524138805','524138827','524138835','960164125','960177463','960181570','960200389','960237562','960389662','960404566','960401566','524138795','524138804','524138811','524138816','524138821','524138823','524138828','524138834','524138840','524138848','960226921','960249340','960289441','960370036','159918140','159918129','600709646','600708461','600708701','600709046','600709231','600709391','600709431','600709496','600709666','600709731','600709821','600708326','600708401','600708411','600708456','600708521','600708626','600708706','600708756','600708796','600708891','600708921','600709056','600709091','600709101','600709521','600709531','600709686','600709831','600709876','600709961','600708506','600708516','600708911','600709206','600709476','600709501','600709726','600709741','600709786','600709806','772722667','772722829','772723048','772723192') AND a.id IN ('960164125') 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 ;
|