| 1 |
0.66 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: [
"e5f67231055d09ff62fc9e59d75ad29b30c26c79257ed70d9c066e5d4d88b6cf"
3244986
]
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` = 'e5f67231055d09ff62fc9e59d75ad29b30c26c79257ed70d9c066e5d4d88b6cf' AND b2_.`status` <> 12 AND a0_.collection = 3244986 ORDER BY b1_.`amount` DESC;
|
| 2 |
0.10 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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') 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 = '3244986'
AND a.id IN (
'145759164', '145759097', '145759176',
'145759029', '145759065', '145759120',
'145759037', '145759047', '145759061',
'145759071', '145759129', '564942201',
'564942211', '564942246', '564942251',
'564942261', '564942301', '564942306',
'564942316', '564942321', '564942346',
'145759133', '145759115', '145759138',
'145759069', '145759055', '145759134',
'145759073', '145759137', '145759117',
'145759034', '145759085', '145759038',
'145759096', '145759169', '145759114',
'145759101', '145759155', '564942181',
'564942231', '564942336', '564942326',
'564942331', '564942176', '564942196',
'564942206', '564942191', '564942216',
'564942311', '564942186', '564942256',
'564942291', '145759053', '145759062',
'145759095', '145759106', '145759143',
'145759048', '145759064', '145759099',
'145759124', '145759159', '564942226',
'564942236', '564942241', '564942286',
'564942341', '145759075', '145759100',
'145759102', '145759139', '145759162',
'145759042', '145759050', '145759056',
'145759154', '145759173', '564942171',
'564942221', '564942266', '564942296',
'145759046', '145759077', '145759148',
'145759031', '145759086', '145759092',
'145759156', '145759172', '145759052',
'145759057', '145759082', '145759066',
'145759091', '145759107', '145759110',
'145759122', '178677497'
)
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') 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 |
6.40 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_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') AND a.id IN ('564942186','564942331','145759155','145759034','145759122','145759050','145759031','564942236','145759062','145759048','564942251','564942211','145759047','145759139','564942191','564942206','564942336','145759038','145759073','145759055') 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_de AS a_price_euro_de,
a.price_mq_euro_de AS a_price_mq_euro_de,
apd.price_euro_de AS apd_price_euro_de,
acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986'
AND a.id IN (
'145759164', '145759097', '145759176',
'145759029', '145759065', '145759120',
'145759037', '145759047', '145759061',
'145759071', '145759129', '564942201',
'564942211', '564942246', '564942251',
'564942261', '564942301', '564942306',
'564942316', '564942321', '564942346',
'145759133', '145759115', '145759138',
'145759069', '145759055', '145759134',
'145759073', '145759137', '145759117',
'145759034', '145759085', '145759038',
'145759096', '145759169', '145759114',
'145759101', '145759155', '564942181',
'564942231', '564942336', '564942326',
'564942331', '564942176', '564942196',
'564942206', '564942191', '564942216',
'564942311', '564942186', '564942256',
'564942291', '145759053', '145759062',
'145759095', '145759106', '145759143',
'145759048', '145759064', '145759099',
'145759124', '145759159', '564942226',
'564942236', '564942241', '564942286',
'564942341', '145759075', '145759100',
'145759102', '145759139', '145759162',
'145759042', '145759050', '145759056',
'145759154', '145759173', '564942171',
'564942221', '564942266', '564942296',
'145759046', '145759077', '145759148',
'145759031', '145759086', '145759092',
'145759156', '145759172', '145759052',
'145759057', '145759082', '145759066',
'145759091', '145759107', '145759110',
'145759122', '178677497'
)
AND a.id IN (
'564942186', '564942331', '145759155',
'145759034', '145759122', '145759050',
'145759031', '564942236', '145759062',
'145759048', '564942251', '564942211',
'145759047', '145759139', '564942191',
'564942206', '564942336', '145759038',
'145759073', '145759055'
)
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_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') AND a.id IN ('564942186','564942331','145759155','145759034','145759122','145759050','145759031','564942236','145759062','145759048','564942251','564942211','145759047','145759139','564942191','564942206','564942336','145759038','145759073','145759055') 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.24 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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') 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 = '3244986'
AND a.id IN (
'145759164', '145759097', '145759176',
'145759029', '145759065', '145759120',
'145759037', '145759047', '145759061',
'145759071', '145759129', '564942201',
'564942211', '564942246', '564942251',
'564942261', '564942301', '564942306',
'564942316', '564942321', '564942346',
'145759133', '145759115', '145759138',
'145759069', '145759055', '145759134',
'145759073', '145759137', '145759117',
'145759034', '145759085', '145759038',
'145759096', '145759169', '145759114',
'145759101', '145759155', '564942181',
'564942231', '564942336', '564942326',
'564942331', '564942176', '564942196',
'564942206', '564942191', '564942216',
'564942311', '564942186', '564942256',
'564942291', '145759053', '145759062',
'145759095', '145759106', '145759143',
'145759048', '145759064', '145759099',
'145759124', '145759159', '564942226',
'564942236', '564942241', '564942286',
'564942341', '145759075', '145759100',
'145759102', '145759139', '145759162',
'145759042', '145759050', '145759056',
'145759154', '145759173', '564942171',
'564942221', '564942266', '564942296',
'145759046', '145759077', '145759148',
'145759031', '145759086', '145759092',
'145759156', '145759172', '145759052',
'145759057', '145759082', '145759066',
'145759091', '145759107', '145759110',
'145759122', '178677497'
)
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') 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;
|
| 5 |
1.87 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_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') AND a.id IN ('564942186') 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_de AS a_price_euro_de,
a.price_mq_euro_de AS a_price_mq_euro_de,
apd.price_euro_de AS apd_price_euro_de,
acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986'
AND a.id IN (
'145759164', '145759097', '145759176',
'145759029', '145759065', '145759120',
'145759037', '145759047', '145759061',
'145759071', '145759129', '564942201',
'564942211', '564942246', '564942251',
'564942261', '564942301', '564942306',
'564942316', '564942321', '564942346',
'145759133', '145759115', '145759138',
'145759069', '145759055', '145759134',
'145759073', '145759137', '145759117',
'145759034', '145759085', '145759038',
'145759096', '145759169', '145759114',
'145759101', '145759155', '564942181',
'564942231', '564942336', '564942326',
'564942331', '564942176', '564942196',
'564942206', '564942191', '564942216',
'564942311', '564942186', '564942256',
'564942291', '145759053', '145759062',
'145759095', '145759106', '145759143',
'145759048', '145759064', '145759099',
'145759124', '145759159', '564942226',
'564942236', '564942241', '564942286',
'564942341', '145759075', '145759100',
'145759102', '145759139', '145759162',
'145759042', '145759050', '145759056',
'145759154', '145759173', '564942171',
'564942221', '564942266', '564942296',
'145759046', '145759077', '145759148',
'145759031', '145759086', '145759092',
'145759156', '145759172', '145759052',
'145759057', '145759082', '145759066',
'145759091', '145759107', '145759110',
'145759122', '178677497'
)
AND a.id IN ('564942186')
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_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de,
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 = '3244986' AND a.id IN ('145759164','145759097','145759176','145759029','145759065','145759120','145759037','145759047','145759061','145759071','145759129','564942201','564942211','564942246','564942251','564942261','564942301','564942306','564942316','564942321','564942346','145759133','145759115','145759138','145759069','145759055','145759134','145759073','145759137','145759117','145759034','145759085','145759038','145759096','145759169','145759114','145759101','145759155','564942181','564942231','564942336','564942326','564942331','564942176','564942196','564942206','564942191','564942216','564942311','564942186','564942256','564942291','145759053','145759062','145759095','145759106','145759143','145759048','145759064','145759099','145759124','145759159','564942226','564942236','564942241','564942286','564942341','145759075','145759100','145759102','145759139','145759162','145759042','145759050','145759056','145759154','145759173','564942171','564942221','564942266','564942296','145759046','145759077','145759148','145759031','145759086','145759092','145759156','145759172','145759052','145759057','145759082','145759066','145759091','145759107','145759110','145759122','178677497') AND a.id IN ('564942186') 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 ;
|