| 1 |
0.16 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: [
"fa727631bacae71c2b272c1edbae63440529d8bc8a6c4c4f9386e9727db99127"
3246880
]
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` = 'fa727631bacae71c2b272c1edbae63440529d8bc8a6c4c4f9386e9727db99127' AND b2_.`status` <> 12 AND a0_.collection = 3246880 ORDER BY b1_.`amount` DESC;
|
| 2 |
0.12 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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') 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 = '3246880'
AND a.id NOT IN (
'255106824',
'305754385',
'305758265',
'305686136',
'305691269',
'305703610',
'305772335',
'305774737',
'305816060',
'305852012',
'940441648',
'1172431307',
'305658537',
'305773785',
'174910923',
'305698647',
'305773891',
'305836021',
'305844857',
'305875581',
'305687249',
'134363388',
'182003388',
'305658522',
'305719571',
'305745284',
'305778196',
'305840386',
'305880697',
'1160423413',
'1172431305',
'225321455',
'305703481',
'305872993',
'305826071',
'305719143',
'305728311',
'225321456',
'305658524',
'305658529',
'305685081',
'305692284',
'305699193',
'305750234',
'305826724',
'305850720',
'305851155',
'305873747',
'305873827',
'305876105',
'305876825',
'306158105',
'1172881273',
'228629971',
'305740295',
'82274358',
'148534962',
'177791678',
'305658536',
'305696974',
'305700426',
'305719863',
'305838388',
'305876172',
'765817012',
'940441645',
'305476935',
'305795527',
'305864860',
'305875407',
'305796043',
'1274009383',
'305776194',
'182003390',
'305687199',
'305721931',
'305824897',
'305878311',
'148534964',
'244781704',
'292775533',
'305658528',
'305783775',
'305812913',
'305833781',
'305839547',
'305871670',
'305721967',
'305735633',
'305754665',
'305851848',
'305845931',
'225321457',
'228629970',
'305835887',
'148534965',
'305694477',
'305721180',
'305732479',
'305756409',
'305796899',
'305797232',
'305799272',
'305827721',
'305866264',
'305777976',
'305699342',
'305734075',
'305738926',
'305745773',
'305750135',
'305628607',
'305658523',
'305686771',
'305838354',
'305690388',
'305703934',
'305833188',
'305690492',
'305733165',
'305735192',
'305775086',
'305850427',
'1042320202',
'174910924',
'244781705',
'305701901',
'305718310',
'305606387',
'305658521',
'305658535',
'305695377',
'305696999',
'305703324',
'305735717',
'305767454',
'305786216',
'305827732',
'305842514',
'305844350',
'305850735',
'832394743',
'855125713',
'232308959',
'305658514',
'305686137',
'940441651',
'305700316',
'244781702',
'278174949',
'305673581',
'305684278',
'305690330',
'305694320',
'305704218',
'305721167',
'305739538',
'305797660',
'305837572',
'305874777',
'815968330',
'1042320196',
'1359693439',
'232308926',
'232308927',
'305658534',
'305701795',
'305853390',
'305872429',
'888825535',
'305750262',
'305778678',
'305796070',
'305813834',
'305840251',
'305878352',
'855125710',
'305838067',
'305704582',
'305795185',
'278174948',
'182003391',
'305689859',
'305826972',
'182003701',
'305688414',
'305810730',
'182003389',
'305718522',
'305735851',
'305690019',
'305715876',
'305846073',
'305883012',
'305690036',
'305691972',
'305769369',
'305769696',
'305807444',
'305864681',
'305733832',
'182003392',
'305716016',
'305782279',
'305866816',
'399409737',
'488747731',
'488750880',
'488751024',
'510639382',
'720711310',
'739213519',
'743382931',
'832029637',
'855125404',
'940441654',
'1013999563',
'1042320199',
'1103372511',
'1269901372',
'142146382',
'142146383',
'142146384',
'148534960',
'167123671',
'167345329',
'167345330',
'167345332',
'167345333',
'172916424',
'172916425',
'182003387',
'182003393',
'225321458',
'305658519',
'305658530',
'305658533',
'305678421',
'305685100',
'305688386',
'305688801',
'305689274',
'305695745',
'305696308',
'305700343',
'305704462',
'305714849',
'305717494',
'305735867',
'305772088',
'305797900',
'305799655',
'305810804',
'305810835',
'305835386',
'305840779',
'305843348',
'305843592',
'305844824',
'305852043',
'305852138',
'305867743',
'305872403',
'305872961',
'305873061',
'305880375',
'547374727',
'336006914',
'336007837',
'547374687',
'547374692',
'547374717',
'547374722',
'336006915',
'443070683',
'683366068',
'739212655',
'739213516',
'354744795',
'547374697',
'547374702',
'547374707',
'547374712',
'791386594',
'791386597',
'791386600',
'336006916',
'739213522',
'739213525'
)
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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') 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 |
0.29 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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') AND a.id IN ('305721354','501858170','305828184','305715095','305782859','305873083','835851172','305658517','245771874','305843158','305738263','501858171','305838756','177791679','304323065','229710242','774344140','305866129','305824819','305658532') 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 = '3246880'
AND a.id NOT IN (
'255106824',
'305754385',
'305758265',
'305686136',
'305691269',
'305703610',
'305772335',
'305774737',
'305816060',
'305852012',
'940441648',
'1172431307',
'305658537',
'305773785',
'174910923',
'305698647',
'305773891',
'305836021',
'305844857',
'305875581',
'305687249',
'134363388',
'182003388',
'305658522',
'305719571',
'305745284',
'305778196',
'305840386',
'305880697',
'1160423413',
'1172431305',
'225321455',
'305703481',
'305872993',
'305826071',
'305719143',
'305728311',
'225321456',
'305658524',
'305658529',
'305685081',
'305692284',
'305699193',
'305750234',
'305826724',
'305850720',
'305851155',
'305873747',
'305873827',
'305876105',
'305876825',
'306158105',
'1172881273',
'228629971',
'305740295',
'82274358',
'148534962',
'177791678',
'305658536',
'305696974',
'305700426',
'305719863',
'305838388',
'305876172',
'765817012',
'940441645',
'305476935',
'305795527',
'305864860',
'305875407',
'305796043',
'1274009383',
'305776194',
'182003390',
'305687199',
'305721931',
'305824897',
'305878311',
'148534964',
'244781704',
'292775533',
'305658528',
'305783775',
'305812913',
'305833781',
'305839547',
'305871670',
'305721967',
'305735633',
'305754665',
'305851848',
'305845931',
'225321457',
'228629970',
'305835887',
'148534965',
'305694477',
'305721180',
'305732479',
'305756409',
'305796899',
'305797232',
'305799272',
'305827721',
'305866264',
'305777976',
'305699342',
'305734075',
'305738926',
'305745773',
'305750135',
'305628607',
'305658523',
'305686771',
'305838354',
'305690388',
'305703934',
'305833188',
'305690492',
'305733165',
'305735192',
'305775086',
'305850427',
'1042320202',
'174910924',
'244781705',
'305701901',
'305718310',
'305606387',
'305658521',
'305658535',
'305695377',
'305696999',
'305703324',
'305735717',
'305767454',
'305786216',
'305827732',
'305842514',
'305844350',
'305850735',
'832394743',
'855125713',
'232308959',
'305658514',
'305686137',
'940441651',
'305700316',
'244781702',
'278174949',
'305673581',
'305684278',
'305690330',
'305694320',
'305704218',
'305721167',
'305739538',
'305797660',
'305837572',
'305874777',
'815968330',
'1042320196',
'1359693439',
'232308926',
'232308927',
'305658534',
'305701795',
'305853390',
'305872429',
'888825535',
'305750262',
'305778678',
'305796070',
'305813834',
'305840251',
'305878352',
'855125710',
'305838067',
'305704582',
'305795185',
'278174948',
'182003391',
'305689859',
'305826972',
'182003701',
'305688414',
'305810730',
'182003389',
'305718522',
'305735851',
'305690019',
'305715876',
'305846073',
'305883012',
'305690036',
'305691972',
'305769369',
'305769696',
'305807444',
'305864681',
'305733832',
'182003392',
'305716016',
'305782279',
'305866816',
'399409737',
'488747731',
'488750880',
'488751024',
'510639382',
'720711310',
'739213519',
'743382931',
'832029637',
'855125404',
'940441654',
'1013999563',
'1042320199',
'1103372511',
'1269901372',
'142146382',
'142146383',
'142146384',
'148534960',
'167123671',
'167345329',
'167345330',
'167345332',
'167345333',
'172916424',
'172916425',
'182003387',
'182003393',
'225321458',
'305658519',
'305658530',
'305658533',
'305678421',
'305685100',
'305688386',
'305688801',
'305689274',
'305695745',
'305696308',
'305700343',
'305704462',
'305714849',
'305717494',
'305735867',
'305772088',
'305797900',
'305799655',
'305810804',
'305810835',
'305835386',
'305840779',
'305843348',
'305843592',
'305844824',
'305852043',
'305852138',
'305867743',
'305872403',
'305872961',
'305873061',
'305880375',
'547374727',
'336006914',
'336007837',
'547374687',
'547374692',
'547374717',
'547374722',
'336006915',
'443070683',
'683366068',
'739212655',
'739213516',
'354744795',
'547374697',
'547374702',
'547374707',
'547374712',
'791386594',
'791386597',
'791386600',
'336006916',
'739213522',
'739213525'
)
AND a.id IN (
'305721354', '501858170', '305828184',
'305715095', '305782859', '305873083',
'835851172', '305658517', '245771874',
'305843158', '305738263', '501858171',
'305838756', '177791679', '304323065',
'229710242', '774344140', '305866129',
'305824819', '305658532'
)
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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') AND a.id IN ('305721354','501858170','305828184','305715095','305782859','305873083','835851172','305658517','245771874','305843158','305738263','501858171','305838756','177791679','304323065','229710242','774344140','305866129','305824819','305658532') 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.11 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 |
0.15 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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') 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 = '3246880'
AND a.id NOT IN (
'255106824',
'305754385',
'305758265',
'305686136',
'305691269',
'305703610',
'305772335',
'305774737',
'305816060',
'305852012',
'940441648',
'1172431307',
'305658537',
'305773785',
'174910923',
'305698647',
'305773891',
'305836021',
'305844857',
'305875581',
'305687249',
'134363388',
'182003388',
'305658522',
'305719571',
'305745284',
'305778196',
'305840386',
'305880697',
'1160423413',
'1172431305',
'225321455',
'305703481',
'305872993',
'305826071',
'305719143',
'305728311',
'225321456',
'305658524',
'305658529',
'305685081',
'305692284',
'305699193',
'305750234',
'305826724',
'305850720',
'305851155',
'305873747',
'305873827',
'305876105',
'305876825',
'306158105',
'1172881273',
'228629971',
'305740295',
'82274358',
'148534962',
'177791678',
'305658536',
'305696974',
'305700426',
'305719863',
'305838388',
'305876172',
'765817012',
'940441645',
'305476935',
'305795527',
'305864860',
'305875407',
'305796043',
'1274009383',
'305776194',
'182003390',
'305687199',
'305721931',
'305824897',
'305878311',
'148534964',
'244781704',
'292775533',
'305658528',
'305783775',
'305812913',
'305833781',
'305839547',
'305871670',
'305721967',
'305735633',
'305754665',
'305851848',
'305845931',
'225321457',
'228629970',
'305835887',
'148534965',
'305694477',
'305721180',
'305732479',
'305756409',
'305796899',
'305797232',
'305799272',
'305827721',
'305866264',
'305777976',
'305699342',
'305734075',
'305738926',
'305745773',
'305750135',
'305628607',
'305658523',
'305686771',
'305838354',
'305690388',
'305703934',
'305833188',
'305690492',
'305733165',
'305735192',
'305775086',
'305850427',
'1042320202',
'174910924',
'244781705',
'305701901',
'305718310',
'305606387',
'305658521',
'305658535',
'305695377',
'305696999',
'305703324',
'305735717',
'305767454',
'305786216',
'305827732',
'305842514',
'305844350',
'305850735',
'832394743',
'855125713',
'232308959',
'305658514',
'305686137',
'940441651',
'305700316',
'244781702',
'278174949',
'305673581',
'305684278',
'305690330',
'305694320',
'305704218',
'305721167',
'305739538',
'305797660',
'305837572',
'305874777',
'815968330',
'1042320196',
'1359693439',
'232308926',
'232308927',
'305658534',
'305701795',
'305853390',
'305872429',
'888825535',
'305750262',
'305778678',
'305796070',
'305813834',
'305840251',
'305878352',
'855125710',
'305838067',
'305704582',
'305795185',
'278174948',
'182003391',
'305689859',
'305826972',
'182003701',
'305688414',
'305810730',
'182003389',
'305718522',
'305735851',
'305690019',
'305715876',
'305846073',
'305883012',
'305690036',
'305691972',
'305769369',
'305769696',
'305807444',
'305864681',
'305733832',
'182003392',
'305716016',
'305782279',
'305866816',
'399409737',
'488747731',
'488750880',
'488751024',
'510639382',
'720711310',
'739213519',
'743382931',
'832029637',
'855125404',
'940441654',
'1013999563',
'1042320199',
'1103372511',
'1269901372',
'142146382',
'142146383',
'142146384',
'148534960',
'167123671',
'167345329',
'167345330',
'167345332',
'167345333',
'172916424',
'172916425',
'182003387',
'182003393',
'225321458',
'305658519',
'305658530',
'305658533',
'305678421',
'305685100',
'305688386',
'305688801',
'305689274',
'305695745',
'305696308',
'305700343',
'305704462',
'305714849',
'305717494',
'305735867',
'305772088',
'305797900',
'305799655',
'305810804',
'305810835',
'305835386',
'305840779',
'305843348',
'305843592',
'305844824',
'305852043',
'305852138',
'305867743',
'305872403',
'305872961',
'305873061',
'305880375',
'547374727',
'336006914',
'336007837',
'547374687',
'547374692',
'547374717',
'547374722',
'336006915',
'443070683',
'683366068',
'739212655',
'739213516',
'354744795',
'547374697',
'547374702',
'547374707',
'547374712',
'791386594',
'791386597',
'791386600',
'336006916',
'739213522',
'739213525'
)
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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') 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 |
0.16 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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') AND a.id IN ('305721354') 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 = '3246880'
AND a.id NOT IN (
'255106824',
'305754385',
'305758265',
'305686136',
'305691269',
'305703610',
'305772335',
'305774737',
'305816060',
'305852012',
'940441648',
'1172431307',
'305658537',
'305773785',
'174910923',
'305698647',
'305773891',
'305836021',
'305844857',
'305875581',
'305687249',
'134363388',
'182003388',
'305658522',
'305719571',
'305745284',
'305778196',
'305840386',
'305880697',
'1160423413',
'1172431305',
'225321455',
'305703481',
'305872993',
'305826071',
'305719143',
'305728311',
'225321456',
'305658524',
'305658529',
'305685081',
'305692284',
'305699193',
'305750234',
'305826724',
'305850720',
'305851155',
'305873747',
'305873827',
'305876105',
'305876825',
'306158105',
'1172881273',
'228629971',
'305740295',
'82274358',
'148534962',
'177791678',
'305658536',
'305696974',
'305700426',
'305719863',
'305838388',
'305876172',
'765817012',
'940441645',
'305476935',
'305795527',
'305864860',
'305875407',
'305796043',
'1274009383',
'305776194',
'182003390',
'305687199',
'305721931',
'305824897',
'305878311',
'148534964',
'244781704',
'292775533',
'305658528',
'305783775',
'305812913',
'305833781',
'305839547',
'305871670',
'305721967',
'305735633',
'305754665',
'305851848',
'305845931',
'225321457',
'228629970',
'305835887',
'148534965',
'305694477',
'305721180',
'305732479',
'305756409',
'305796899',
'305797232',
'305799272',
'305827721',
'305866264',
'305777976',
'305699342',
'305734075',
'305738926',
'305745773',
'305750135',
'305628607',
'305658523',
'305686771',
'305838354',
'305690388',
'305703934',
'305833188',
'305690492',
'305733165',
'305735192',
'305775086',
'305850427',
'1042320202',
'174910924',
'244781705',
'305701901',
'305718310',
'305606387',
'305658521',
'305658535',
'305695377',
'305696999',
'305703324',
'305735717',
'305767454',
'305786216',
'305827732',
'305842514',
'305844350',
'305850735',
'832394743',
'855125713',
'232308959',
'305658514',
'305686137',
'940441651',
'305700316',
'244781702',
'278174949',
'305673581',
'305684278',
'305690330',
'305694320',
'305704218',
'305721167',
'305739538',
'305797660',
'305837572',
'305874777',
'815968330',
'1042320196',
'1359693439',
'232308926',
'232308927',
'305658534',
'305701795',
'305853390',
'305872429',
'888825535',
'305750262',
'305778678',
'305796070',
'305813834',
'305840251',
'305878352',
'855125710',
'305838067',
'305704582',
'305795185',
'278174948',
'182003391',
'305689859',
'305826972',
'182003701',
'305688414',
'305810730',
'182003389',
'305718522',
'305735851',
'305690019',
'305715876',
'305846073',
'305883012',
'305690036',
'305691972',
'305769369',
'305769696',
'305807444',
'305864681',
'305733832',
'182003392',
'305716016',
'305782279',
'305866816',
'399409737',
'488747731',
'488750880',
'488751024',
'510639382',
'720711310',
'739213519',
'743382931',
'832029637',
'855125404',
'940441654',
'1013999563',
'1042320199',
'1103372511',
'1269901372',
'142146382',
'142146383',
'142146384',
'148534960',
'167123671',
'167345329',
'167345330',
'167345332',
'167345333',
'172916424',
'172916425',
'182003387',
'182003393',
'225321458',
'305658519',
'305658530',
'305658533',
'305678421',
'305685100',
'305688386',
'305688801',
'305689274',
'305695745',
'305696308',
'305700343',
'305704462',
'305714849',
'305717494',
'305735867',
'305772088',
'305797900',
'305799655',
'305810804',
'305810835',
'305835386',
'305840779',
'305843348',
'305843592',
'305844824',
'305852043',
'305852138',
'305867743',
'305872403',
'305872961',
'305873061',
'305880375',
'547374727',
'336006914',
'336007837',
'547374687',
'547374692',
'547374717',
'547374722',
'336006915',
'443070683',
'683366068',
'739212655',
'739213516',
'354744795',
'547374697',
'547374702',
'547374707',
'547374712',
'791386594',
'791386597',
'791386600',
'336006916',
'739213522',
'739213525'
)
AND a.id IN ('305721354')
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 = '3246880' AND a.id NOT IN ('255106824','305754385','305758265','305686136','305691269','305703610','305772335','305774737','305816060','305852012','940441648','1172431307','305658537','305773785','174910923','305698647','305773891','305836021','305844857','305875581','305687249','134363388','182003388','305658522','305719571','305745284','305778196','305840386','305880697','1160423413','1172431305','225321455','305703481','305872993','305826071','305719143','305728311','225321456','305658524','305658529','305685081','305692284','305699193','305750234','305826724','305850720','305851155','305873747','305873827','305876105','305876825','306158105','1172881273','228629971','305740295','82274358','148534962','177791678','305658536','305696974','305700426','305719863','305838388','305876172','765817012','940441645','305476935','305795527','305864860','305875407','305796043','1274009383','305776194','182003390','305687199','305721931','305824897','305878311','148534964','244781704','292775533','305658528','305783775','305812913','305833781','305839547','305871670','305721967','305735633','305754665','305851848','305845931','225321457','228629970','305835887','148534965','305694477','305721180','305732479','305756409','305796899','305797232','305799272','305827721','305866264','305777976','305699342','305734075','305738926','305745773','305750135','305628607','305658523','305686771','305838354','305690388','305703934','305833188','305690492','305733165','305735192','305775086','305850427','1042320202','174910924','244781705','305701901','305718310','305606387','305658521','305658535','305695377','305696999','305703324','305735717','305767454','305786216','305827732','305842514','305844350','305850735','832394743','855125713','232308959','305658514','305686137','940441651','305700316','244781702','278174949','305673581','305684278','305690330','305694320','305704218','305721167','305739538','305797660','305837572','305874777','815968330','1042320196','1359693439','232308926','232308927','305658534','305701795','305853390','305872429','888825535','305750262','305778678','305796070','305813834','305840251','305878352','855125710','305838067','305704582','305795185','278174948','182003391','305689859','305826972','182003701','305688414','305810730','182003389','305718522','305735851','305690019','305715876','305846073','305883012','305690036','305691972','305769369','305769696','305807444','305864681','305733832','182003392','305716016','305782279','305866816','399409737','488747731','488750880','488751024','510639382','720711310','739213519','743382931','832029637','855125404','940441654','1013999563','1042320199','1103372511','1269901372','142146382','142146383','142146384','148534960','167123671','167345329','167345330','167345332','167345333','172916424','172916425','182003387','182003393','225321458','305658519','305658530','305658533','305678421','305685100','305688386','305688801','305689274','305695745','305696308','305700343','305704462','305714849','305717494','305735867','305772088','305797900','305799655','305810804','305810835','305835386','305840779','305843348','305843592','305844824','305852043','305852138','305867743','305872403','305872961','305873061','305880375','547374727','336006914','336007837','547374687','547374692','547374717','547374722','336006915','443070683','683366068','739212655','739213516','354744795','547374697','547374702','547374707','547374712','791386594','791386597','791386600','336006916','739213522','739213525') AND a.id IN ('305721354') 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 ;
|