QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(8911484,10871871,7202211,7202212,7202213,3899513,7202271,10104307,10104308,8560174,10104366,7202516,7202517,5654627,10933314,8629275,10859955,10199519,10873170,8837430,8837470,10437713,10437714,10275176,10275177,10275178,10275179,10275180,10275181,10275182,10275183,10275184,10275185,10275186,10275187,10275188,10275189,10275190,10275191,10275192,10275193,10275194,10275195,10275196,10275197,10275198,10275199,10275200,10275201,10275202,7200752,7075109,10858179,4430540,8558889,8911022,7201231,7201232,7201233,7201243,7201244,8911255,8911256,8911257,8911258,8911259,8911260,8911261,8911262,8625141,3236277,3236278,3236279,7072460,3926695,10261625,10261626,10261627,3237336,10261628,10261629,3237338,10261630,10261631,3237342,3237350,10857458,10857459,10857460,8861325,7068999,8579009,10837698,3233440,10257801,10257802,10837892,10837893,10837900,10837901,10837985,10837986,3233922,3233923,3233924,3233925,3233926,3233927,8906883,8906884,7157453,10867210,10867211,8860355,10838957,10850656,10863747,10190222,10190223,9217349,9217350,10433364,10623502,8540598,10256105,8577602,10619078,10256266,10256274,10256275,10864934,10864936,10864939,10864942,10864947,10864950,10864955,10864961,10864968,10864973,10864975,8634461,10852315,10852321,10852328,10852332,10852334,10852338,10852341,10852344,10852347,10852349,10852352,10852354,10852358,10852365,10852398,10282867,8634933,10849781,10617207,8584159,8584160,10922917,10922918,10922919,10922920,10922921,10922922,10922923,10922924,10922925,10622413,10622414,10460643,10614985,8569867,8569868,10845200,8630221,10925780,10925781,10925782,10925783,10925784,10925785,8620514,10278505,10278506,10278507,10278508,10278509,10278510,10278511,10278512,10278513,10278514,10278515,10278516,10278517,10278518,10278519,10278520,10278521,10278522,10278523,10278524,10252582,8620771,10265646,10930363,10252893,10252894,10252895,8631003,8621312,8621313,10253242,10253243,10253244,10848880,10846625,10846626,10846627,10846628,10846963,10846964,10846965,10253995,7059505,7059506,9915880,9198030,9206059,9206060,9206061,9206062,9206063,9206064,9206065,9206066,9206067,9206068,8549456,7017441,7017442,7017447,7017448,7017453,7017454,7017459,7017460,7017465,7017466,7017471,7017472,7017477,7017478,7017483,7017484,7017489,7017490,7017495,7017496,7017501,7017502,7017507,7017508,10120455,7058909,7058910,7058911,7058912,7058913,7058914,7058915,7058916,7058917,7058918,7058919,7058920,7058921,7058922,7058923,7058924,7058925,7058926,7058927,7058928,7055900,9201829,10513956,10513957,10513958,4975035,3286084,10119164,10119165,8552350,8552351,10516903,10418228,10418230,10418232,10418235,10418240,10418243,10418249,10418253,10418260,10427725,10418265,10418267,8918009,8918010,8918011,10124951,9200884,6681198,6681199,6681200,6681201,6681202,6681203,6681204,6681205,6681206,6681207,6681208,6681209,6681210,6681211,6681212,6681213,6681214,10125294,10125295,10420044,10428576,10428577,10428578,10428579,10428580,10428581,10428582,10428583,10428584,10428585,10428586,10428587,10428588,10428589,10428590,10428591,7055461,9182482,8569026,8569027,8569028,8569029,8569030,8569031,8569032,8569033,8569034,8569035,8569036,8569037,8569038,8569039,8569040,8569041,8569042,8569043,8569044,9174561,9174562,8569206,9917192,9917193,9207126,9207127,9207128,9207129,9207130,8855169,8855170,9175600,10468355,10468356,10468357,6667850,10116195,10116196,8551220,8551221,8551222,10470646,10470647,10470652,7013865,7013866,7013885,7013886,7013891,7013892,7013897,7013898,7013903,7013904,7013909,7013910,7013915,7013916,7013921,7013922,7013927,7013928,7013933,7013934,7013939,7013940,7013945,7013946,7013951,7013952,7013957,7013958,10628644,10628645,8594538,10890021,10186274,10186275,10186276,10166459,10892881,10892882,10892883,10892884,10892885,10892886,10892887,10882918,10882919,10882920,10183962,10913278,10913279,10913280,10913281,10913390,10915965,10630594,10630595,10630596,10630597,10630598,10630599,10630600,10630601,10630602,10630603,10630604,10630605,10630606,10630607,10630608,10630609,10630610,10630611,10630612,10630613,10630614,10630615,10630616,10630617,10187441,10187442,10187443,10187444,10187445,10187446,10891691,10891692,10631183,10631184,10631185,10631306,10188242,10178266,10178267,10877334,10877335,10877336,10877337,10877338,10877339,10877340,10877341,10877342,10877343,10877344,10611022,10571310,10571311,10652954,10581041,10581042,10581043,10581044,10581045,10581046,10581047,10581048,10581049,10581050,10581051,10581052,10581053,10581054,10581055,10581056,10581057,10581058,10581059,10581060,10581061,10581062,10581063,10581064,10581065,10581066,10581067,10581068,10581069,10581070,10581071,10581072,10581073,10581074,10581075,10650225,10650226,10653286,10653287,10653301,10584446,10584447,10584448,10653549,10653550,10653551,10653946,10569917,10569918,10587933,10569933,10587934,10569934,10587935,10587936,10587937,10587938,10587939,10587940,10587941,10587942,10587943,10587944,10587945,10587946,10587947,10587948,10587949,10570116,10570117,10570118,10582389,10582390,10582391,10582392,10582393,10582394,10582395,10582396,10582397,10582398,10582399,10582400,10582401,10582402,10582403,10582404,10582405,10582406,10582407,10570665,10570666,10573891,10573892,10573893,10601909,10571103,10571104,10527128,10539205,10521658,10521749,10521750,10519895,10519896,10519897,10519898,10519899,10519900,10519901,10519902,10519903,10519904,10519905,10519906,10534229,10534230,10550299,10550300,10548423,10524884,10524885,10508322,10508323,10508324,10508325,10508326,10508327,10508328,10506443,10506444,10506445,10506446,10506447,10506448,10506449,10506450,10506451,10506452,10506453,10506454,10422608,10507698,10507699,10423156,10407312,10477267,10477314,10477315,10492385,10412181,10412182,10479923,10479924,10479925,10479926,10479927,10479928,10414343,10495125,10495126,8563449,10476160,10476161,10412749,10408863,10408865,10408869,10408872,10408874,10408877,10408880,10408884,10408886,10408890,10493605) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'