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(4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,4970520,4970521,4970670,4970671,4970675,4970685,4970721,4970722,4970723,4970731,4970732,4970733,4970734,4970738,4970775,4971037,4971081,4971082,4971143,4968319,4968320,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968410,4968411,4968412,4968413,4968613,4968614,4968622,4968623,4968624,4968625,4968631,8075288,8075333,8075334,8075335,8075336,8075357,8075419,8075457,4967460,4967870,4967871,4967872,4967985,4968076,4968077,4968078,8071672,8071673,8071676,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071713,8071714,8071715,8071716,8071717,8071723,8071724,8071725,8071726,8071731,8071732,8071733,8071737,8071738,8071741,8071743,8071744,8071745,8071746,8071747,8071748,8071749,8071750,8071751,8071752,8071753,8071754,8071755,8071756,8071757,8071758,8071759,8071760,8071761,8071762,8071763,8071764,8071765,8071766,8071767,8071768,8071769,8071770,8071771,8071772,8071778,8071779,8071780,8071781,8071782,8071788,8071789,8071790,8071791,8071796,8071797,8071798,8071802,8071803,8071806,8071808,8071809,8071810,8071811,8071812,8071813,8071814,8071815,8071816,8071817,8071818,8071819,8071820,8071821,8071822,8071823,8071824,8071825,8071826,8071827,8071828,8071829,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071843,8071844,8071845,8071846,8071847,8071853,8071854,8071855,8071856,8071861,8071862,8071863,8071867,8071868,8071871,8071873,8071874,8071875,8071876,8071877,8071878,8071879,8071880,8071881,8071882,8071883,8071884,8071885,8071886,8071887,8071888,8071889,8071890,8071891,8071892,8071893,8071894,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8071908,8071909,8071910,8071911,8071912,8071918,8071919,8071920,8071921,8071926,8071927,8071928,8071932,8071933,8071936,8071938,8071939,8071940,8071941,8071942,8071943,8071944,8071945,8071946,8071947,8071948,8071949,8071950,8071951,8071952,8071953,8071954,8071955,8071956,8071957,8071958,8071959,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071973,8071974,8071975,8071976,8071977,8071983,8071984,8071985,8071986,8071991,8071992,8071993,8071997,8071998,8072001,8072003,8072004,8072005,8072006,8072007,8072008,8072009,8072010,8072011,8072012,8072013,8072014,8072015,8072016,8072017,8072018,8072019,8072020,8072021,8072022,8072023,8072024,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072038,8072039,8072040,8072041,8072042,8072048,8072049,8072050,8072051,8072056,8072057,8072058,8072062,8072063,8072066,8072068,8072069,8072070,8072071,8072072,8072073,8072074,8072075,8072076,8072077,8072078,8072079,8072080,8072081,8072082,8072083,8072084,8072085,8072086,8072087,8072088,8072089,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,8072103,8072104,8072105,8072106,8072107,8072113,8072114,8072115,8072116,8072121,8072122,8072123,8072127,8072128,8072131,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072168,8072169,8072170,8072171,8072172,8072178,8072179,8072180,8072181,8072186,8072187,8072188,8072192,8072193,8072196,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072233,8072234,8072235,8072236,8072237,8072243,8072244,8072245,8072246,8072251,8072252,8072253,8072257,8072258,8072261,8072263,8072264,8072265,8072266,8072267,8072268,8072269,8072270,8072271,8072272,8072273,8072274,8072275,8072276,8072277,8072278,8072279,8072280,8072281,8072282,8072283,8072284,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,8073065,8073068,8073070,8073128,8073136,8073171,8073172,8073179,8073180,8073181,8073209,8073210,8073251,8073292,8073293,8073294,8073335,8073456,8073529,10623056,10623063,10623064,10623065,10623092,10623093,10623113,10623114,10623115,10623116,10623165,10623166,10623167,10623169,10623177,10623258,10623259,10623260,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623481,10623482,10623490,10623491,10623492,10623493,10623494,10623495,10623496,10623507,10623508,10623660,10623661,10623662,10623665,10623707,10623708,10623709,10623710,10623711,10623712,10623713,10623714,10623715,10623719,10623720,10623721,10623722,10623723,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623731,10623732,10623733,10623734,10623735,10623736,10623737,10623738,10623739,10623768,10623769,10623770,10623805,10623810,10624121,10624122,10624123,10624131,10624132,10624133,10624134,10624414,10624548,10624552,10624553,10624554,10624555,10624582,10624627,10624628,10624632,10624633,10621982,10622095,10622146,10622154,10622217,10622224,10622225,10622235,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10622269,10622360,10622365,10622402,10622405,10622408,10622428,10622429,10622430,10622431,10622441,10622445,10622447,10622460,10622508,10622514,10622516,10622523,10622533,10622548,10622549,10622672,10622673,10622674,10622675,10622677,10622678,10622679,10622680,10622681,10622714,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10622818,10622819,10622820,10622828,10622864,10622865,10620076,10620079,10620080,10620081,10620082,10620084,10620085,10620086,10620087,10620088,10620089,10620090,10620091,10620092,10620093,10620094,10620096,10620108,10620117,10620118,10620172,10620183,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620207,10620208,10620254,10620255,10620256,10620257,10620258,10620259,10620289,10620290,10620291,10620292,10620297,10620298,10620301,10620302,10620303,10620309,10620310,10620311,10620312,10620313,10620330,10620331,10620335,10620336,10620337,10620427,10620438,10620439,10620440,10620528,10620559,10620711,10620712,10620717,10620718,10620764,10620765,10620766,10620767,10620768,10620769,10620770,10620771,10620772,10620773,10620774,10620775,10620776,10620777,10620778,10620779,10620780,10620781,10620782,10620783,10620784,10620785,10620786,10620787,10620788,10620789,10620790,10620791,10620792,10620793,10620794,10620795,10620796,10620797,10620893,10620894,10620895,10620920,10620921,10620922,10620923,10621034,10621036,10621037,10621038,10621041,10621566,10565127,10565144,10565150,10565155,10565158,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565200,10565205,10565206,10565207,10565211,10565220,10565225,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565247,10565248,10565252,10565253) 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'