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(10939617,10939618,10939628,10939677,10939694,10939700,10939703,7068112,7068113,10939772,10939792,10939796,10939822,10943628,10939848,10939868,10939882,10939907,10939908,10939914,10939915,10939916,10943842,10940061,4970670,4970671,4970738,10940293,4971037,10944265,4971081,10940507,10940524,7065936,7065941,7065946,7065947,7066265,7066348,8067368,8067369,8067757,7066825,10437751,10437753,10437774,8067931,8067943,10938787,10938791,10938792,10938794,10938795,10938797,10938854,10938881,10939126,10939467,10939492,10939495,10939503,10939511,10939537,8075333,8075334,8075335,8075336,7064733,7064735,7064760,7064761,7064771,7064822,7064856,7064863,7064878,7064892,7064911,7064912,7064926,7064947,7064977,7064983,7064984,7064985,7064986,7065004,7065834,7065838,7065839,10942600,10942666,10942671,10942672,10942692,10942693,10942696,10942710,10942712,10942714,10942715,10942734,10942735,10942737,10942743,10942745,10942793,10942799,10942804,10942812,10942817,10942861,10942992,10942994,10943018,10943019,10943026,10943044,10943045,10943048,10943113,10943122,10943248,10943257,10943270,10943280,10943290,10943304,10943306,10943308,10943309,10943419,8071672,8071673,8071676,8071678,8071679,8071681,8071682,8071683,8071684,8071686,8071687,8071688,10940578,8071690,10940580,8071691,8071692,8071694,8071695,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071713,8071714,8071716,8071717,8071723,8071725,8071726,8071732,8071733,8071737,8071738,8071741,8071743,8071744,10940633,8071746,8071747,8071748,8071749,8071751,8071752,8071753,8071755,8071756,8071757,8071759,8071760,8071765,8071766,8071767,8071768,8071769,8071770,8071771,8071772,8071778,8071779,8071781,8071782,8071788,8071790,8071791,8071797,8071798,8071802,8071803,8071806,8071808,8071809,8071811,8071812,8071813,8071814,8071816,8071817,8071818,8071820,8071821,8071822,8071823,8071825,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071843,8071844,8071846,8071847,10940741,8071853,10940742,8071855,8071856,8071862,8071863,8071867,8071868,8071871,8071873,8071874,8071876,8071877,8071878,8071879,8071881,8071882,8071883,8071885,8071886,8071887,8071889,8071890,10940783,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8071908,8071909,8071911,8071912,8071918,8071920,8071921,8071927,8071928,8071932,8071933,8071936,8071938,8071939,8071941,8071942,8071943,8071944,8071946,8071947,8071948,8071950,8071951,8071952,8071954,8071955,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071973,8071974,8071976,8071977,8071983,8071985,8071986,8071992,8071993,10940883,8071997,8071998,8072001,8072003,8072004,8072006,8072007,8072008,8072009,8072011,8072012,8072013,8072015,8072016,8072017,8072019,8072020,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072038,8072039,8072041,8072042,8072048,8072050,8072051,8072057,8072058,8072062,8072063,8072066,8072068,8072069,8072071,8072072,8072073,8072074,8072076,8072077,8072078,10940969,8072080,8072081,8072082,8072084,8072085,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,10940993,8072104,8072106,8072107,10940998,10941002,8072113,8072115,8072116,8072122,8072123,8072127,8072128,8072131,8072133,8072134,8072136,8072137,8072138,8072139,8072141,8072142,8072143,8072145,8072146,8072147,8072149,8072150,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072168,8072169,8072172,8072178,8072180,8072181,8072187,8072188,8072192,8072193,8072196,8072198,8072199,8072201,8072202,8072203,8072204,8072206,8072207,8072208,8072210,8072211,8072212,10941103,8072214,8072215,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072233,8072234,8072236,8072237,10941128,8072243,8072245,8072246,8072252,8072253,8072257,8072258,8072261,8072263,8072264,8072266,8072267,8072268,8072269,8072271,10941161,8072272,8072273,10941163,8072275,8072276,8072277,8072279,8072280,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,10941195,10941226,10941262,10941278,10941285,10945086,10941296,10945101,10941383,10941389,10941391,10941400,10941477,10941512,10941589,10941636,10941651,10941682,10941745,10941749,10941791,10941913,10941920,10941926,10941929,10941948,10941961,10941969,10941979,10941984,10942106,11048454,10942201,10942205,10942210,10942213,10942218,10942219,10942222,10942228,10942229,10942286,10942304,10942325,10942332,10942335,10942343,10942344,10942346,10942347,10942348,10942350,10942356,10942357,10942358,10942361,10942366,10942367,10942385,10942386,10942390,10942395,10942410,10942435,10942448,10942477,10942483,10942484,10942489,10942534,10942535,8070049,8070054,8070057,8070061,8070094,8070101,8070107,8070111,8070125,8070131,8070134,8070136,8070139,8070149,8070152,8070157,8070168,8070171,8070172,8070178,8070180,8070186,8070189,8070196,8070198,8070212,8070214,8070219,8070224,8070225,8070230,8070234,8070237,8070314,8070319,8071512,8071513,8071515,8071516,8071522,8071524,8071525,8071534,8071535,8071539,8071540,8071543,8071545,8071546,8071548,8071549,8071550,8071551,8071553,8071554,8071555,8071557,8071558,8071559,8071561,8071562,8071568,8071569,8071570,8071571,8071572,8071573,8071574,8071575,8071583,8071584,8071586,8071587,8071593,8071595,8071596,8071602,8071603,8071607,8071608,8071611,8071613,8071614,8071616,8071617,8071618,8071619,8071621,8071622,8071623,8071625,8071626,8071627,8071629,8071630,8071635,8071636,8071637,8071638,8071639,8071640,8071641,8071642,8071648,8071649,8071651,8071652,8071658,8071660,8071661,8071667,8071668,10622217,10622224,10622225,10622235,10927985,10927986,10927987,10927988,10622533,10622548,10622549,10620117,10620118,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620208,10620297,10620298,10620301,10620302,10620303,10620335,10620427,10620528,10620559,10621034,10621036,10621037,10621038,10621041,10610965,10613971,10610995,10610996,10610997,10611037,10614064,10611105,10559396,10614376,10611459,10614502,10614530,10611550,10614552,10614553,10614554,10559705,10559706,10559709,10611560,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10611590,10559744,10559745,10611615,10611649,10611659,10611665,10611804,10611856,10614857,10611891,10611892,10612104,10612105,10612106,10612107,10612191,10612294,10609369,10612381,10609749,10609845,10612916,10612940,10612961,10609988,10610015,10610097,10613136,10558317,10558318,10558319,10558320,10613172,10610241,10610242,10610243,10610244,10610245,10610246,10610247,10610248,10610249,10610250,10610251,10613306,10610337,10610343,10610344,10610347,10610351,10613353,10613354,10613362,10613369,10610376,10613393,10613421,10613431,10613432,10613434,10558596,10610473,10610474,10613475,10610479,10610480,10610481,10610482,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10610697,10613736,10613750,10610901,10610947,10513373,10513619,10513620,10517670,10517681,10517809,10513974,10513975,10517994,10517995,10514015,10512530,10512782,10515060,10515061,10515062,10515063,10515064,10515065,10515066,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10416350,10416352,10416353,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10419473,10419474,10419477,10419479,10419480,10419481,10419484,10419485,10419487,10419489,10419491,10419515,10419521,10415575,10415576,10418048,10420173,10420175,10420178,10420202,10467219,10467220,10467221,10467796,10467797,10467803,8563250,8563251,8563252,10469949,10469950,8563299,8563358,8563359,8563360,8563361,8563362,8563363,10470089) 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'