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(10873304,8630685,8630686,8630737,10943628,8630907,8630908,8574497,8574504,8574508,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631065,10963319,10862109,10871173,8631560,8631561,8631581,8631784,10950773,8631803,8631804,8631805,10847101,3229954,3229980,10849857,10849858,8632223,10871879,10871881,8632248,10872085,10863099,10863122,10863123,10869168,8837426,8837437,8837446,8837448,8837460,8837464,8629623,8837485,8837489,8837505,8837509,8837540,8837543,8629702,8629705,8837553,8837560,8837571,8837578,8837579,8837580,10844852,10844853,8837591,10869390,8837603,8561142,3227922,7201203,8911035,8911036,7201328,8911230,8911234,8627879,8627880,8627895,8627896,8627899,8627900,8627928,8627929,8627953,8627954,8627955,8627956,8627957,8627958,8627959,8627960,8627961,8627962,8627963,8627964,8627965,8627966,8627967,8627968,8627969,8627970,8627971,8627972,8627973,8627974,8627975,8627976,8627977,8627978,8627979,8627980,8627981,8627982,10103481,10960066,10960067,10960068,10960069,7201666,8628078,8628139,10866813,10866814,8628222,10960474,7202345,8628753,8628754,8628755,8628756,8628757,8628758,8628759,8628760,8628761,8628762,8628763,8628764,8628765,8628766,8628767,8628768,8628769,8628770,7202383,7202388,8628805,8628877,10999916,8628878,8628879,11000014,11000015,11000016,11000017,11000018,11000019,10961020,11000020,11000024,11000025,11000026,11000027,11000028,11000029,11000030,11000031,11000032,11000033,10867705,10844198,8596159,8629164,8629165,8629166,8629167,8629168,8629169,8629170,8629171,8629172,8629173,8629174,8629175,8629176,8629177,8629185,8629188,8560517,8837081,8837098,10859904,8837114,8837128,8837155,8837157,8837161,8837165,11000398,8837240,8837249,8837250,8837283,8837325,8837331,8837357,8837358,8837361,8837363,8837374,8837384,8837386,8837394,8837399,8837418,8837420,10857259,10857260,10857261,10857263,10857265,10857267,10857269,10857272,10857273,10857275,10857276,10857277,10857278,10857281,8616849,8616850,8626835,8834742,10958955,10958956,8626920,8626921,8626922,7200579,7071660,7071661,7071662,8627333,10857984,10857985,10857986,10858042,10858043,10858046,10858048,10858049,10858050,10858051,10858096,10858097,10858101,10858102,10858103,11037510,11037511,10855271,7198398,7198399,7198400,8563882,10855592,10855593,10855594,10855599,7198766,8908755,8625409,8625410,8625411,8625412,10983761,10983762,10983763,8625774,8625775,10101504,3656993,8626176,11048438,11048439,8626281,8626282,8626283,8626284,8626285,8626286,8626287,8626288,8626289,8626290,8626291,8626292,8626293,8626294,8626295,8626296,8626297,8626298,8626299,8626300,8626301,8626302,8626303,8626304,8626305,8626306,8626307,8626308,8626309,8626310,8626311,8626312,8626313,8626314,8626315,8626316,8626317,8626318,8626319,8626320,8626321,8626322,10853230,10853232,10853233,7196413,7196414,7196427,7196434,7196435,7196445,7196446,7196447,7196450,7196451,7196452,7196455,7196456,7196457,7196458,7196459,7196460,7196461,7196462,7196463,7196464,7196465,7196466,7196467,7196468,7196469,7196473,7196474,7196475,7196476,7196477,10618278,10618279,10618280,10623325,11045991,8070094,8070101,8070107,8070111,8070212,8070214,11007198,7197054,3234552,3234553,10995114,10995115,7197705,11008159,11008160,11008161,3234898,3234901,3234902,3234904,3234905,3234906,3234908,3925019,10855049,8624441,8624442,8624449,10619844,8907880,8624504,10852253,10852254,3232388,3232389,8634645,8634674,8634675,10852365,8905290,8905291,8612075,10617323,10617324,10852642,10852643,8635007,8635008,8635009,10954113,10954114,10927986,10927987,11045196,3922987,3922988,8542246,8612652,8632616,8632617,10990667,10990668,10990669,10990670,10990671,10990672,10990673,10990674,10990675,10990676,3230436,10425390,10951653,10951654,8632726,8609968,8609971,10425553,10425554,10425555,10425567,10425568,10425575,10425576,10425577,10425578,10425579,10425580,10425581,10425582,10425583,10425584,10425585,10425587,8632894,8632895,8632896,8632897,8632898,8632899,10850648,10850649,10850650,10850655,10850656,10850740,10850748,10850751,8633203,8633209,10425936,10991258,10991259,10991260,10991261,10991262,10991263,10991264,10991265,8633236,10848391,8610561,10851039,8540781,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616333,8633964,8611319,8611353,8634199,8634200,8634201,8634202,8634203,8634204,8634205,8634206,8634207,8634208,8634209,8634210,8634211,8634212,8634213,8634214,8634215,8634216,8634217,8634218,8634219,8634220,8634221,8634222,8634223,8634224,8634225,8634226,8634227,8611454,3232052,3232062,10851969,10852025,3232187,8634444,8611696,8634573,8634574,8634575,8853339,8853342,8853343,8853344,8853345,8853346,8853352,8853353,8853354,8853357,8853358,8853360,8853361,6669827,6669909,10611461,10611462,10611469,10611472,10611473,10611477,10611479,10611480,10611482,10611486,10611495,10565646,10565647,10611498,10611499,10611500,10611505,10611514,10611517,10611605,10611646,10611676,10611830,10611832,10611833,10611834,9174283,9174284,7057620,7057621,9187551,9914259,8851878,10120369,10120370,10120371,10610015,9172520,9172547,10610311,9204760,8852607,9915063,6677237,10610729,10610730,9197140,9161354,9161355,9161357,8849329,8849330,7055724,10513407,9209628,8849898,10512171,10512172,8850224,10514388,10514389,9912902,9912914,9186757,9170904,9210938,9210939,9210940,9178996,10516810,8565537,10514964,10514965,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515043,10515044,10515072,8851100,8851109,8851110,10417282,4973429,6672808,10418543,10418546,10416648,9208749,10416671,10416672,10419677,10419678,9208834,10419824,8848829,8848843,8848845,8848848,10463045,10467155,10467456,10467460,10463655,10463656,8916798,10463729,10463731,10463732,10463741,10463754,10463755,10463756,10463757,10463781,10463789,10463790,10463791,10463792,10463793,10463794,10463795,10463796,10463797,10463798,10463799,10463800,10463801,10463802,10463807,10463808,10463809,10463810,10463811,10463812,10463813,10463819,10463820,9175283,10463895,10463896,10463897,10463898,10463899,10463900,10463901,10463902,10463903,10463904,9175466,10464046,10466327,9207775,10466442,9192218,8848103,10883629,10175153,10899678,10899940,10171154,10890162,10885165,10163547,10892598,10892599,10892600,10632169,10153851,10883045,10908297,10908327,10908356,10630102,10167041,10167049,10167090,10167091,10886213,10886214,10167348,10891365,10187570,10891634,10631331,10631333,10162864,10911852,10911860,10882041,10877181,10601238,10601391,10602746,10644404,10587558,10606917,10604085,10519475,10529710,10551971,10551972,10548028,10548032,10548033,10548108,10548109,10548110,10548288,10548290,10548291,10548295,10548296,10534567,10534587,10522594,10522595,10540883,10522889,10527020,10547076,10423293,10421389,10508322,10420431,10508323,10508324,10508325,10508326,10421578,10421966,10425075,10508030,10508035,10423166,10483142,10484521,10407993,10408001,10408157,10410262,10414300,10497060,10497064,10497068,10410455,10412517,10412519,10412570,10412571,10412572,10412622,10412623,10412624,10412626,10412627,10412628,10412629,10412676,10412677,10412681,10412682,10497396,10497397,10410756,10410757,10410758,10476652,10409008,10415133,10415184) 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'