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(10939725,10939733,10939734,4970403,4970404,10939876,10939882,10940017,4970721,4970722,4970738,10940147,10940224,10940225,10940284,10940298,8067275,8067369,10939383,10939439,8075288,8075333,8075334,8075335,8075336,8065853,8065932,8065933,8065934,8065935,8065953,8065954,8065955,8065956,8065957,8065958,8066177,4967870,4967871,8064474,8064475,8064476,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,8071723,8071724,8071725,8071726,8071731,8071732,8071733,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,8071788,8071789,8071790,8071791,8071796,8071797,8071798,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,8071853,8071854,8071855,8071856,8071861,8071862,8071863,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,8071918,8071919,8071920,8071921,8071926,8071927,8071928,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,8071983,8071984,8071985,8071986,8071991,8071992,8071993,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,8072048,8072049,8072050,8072051,8072056,8072057,8072058,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,8072113,8072114,8072115,8072116,8072121,8072122,8072123,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,8072178,8072179,8072180,8072181,8072186,8072187,8072188,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,8072243,8072244,8072245,8072246,8072251,8072252,8072253,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,3656698,3656988,10623056,10623169,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,10623491,10623492,10623660,10623661,10623662,10623707,10623708,10623709,10623710,10623721,10623722,10623726,10623733,10623734,10623739,10623768,10623805,10624122,10624123,10624131,10624132,10624133,10624414,10624582,10624628,10624632,10624633,10621982,10622095,10622154,10622257,10622429,10622430,10622445,10622548,10622549,10622672,10622673,10622674,10622675,10622677,10622678,10622679,10622680,10622681,10622714,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10622818,10622819,10622820,10622828,10620080,10620108,10620118,10620187,10620189,10620190,10620191,10620192,10620193,10620194,10620198,10620199,10620200,10620202,10620208,10620301,10620302,10620303,10620337,10620438,10620439,10620440,10620711,10620712,10620778,10620779,10620780,10620781,10620782,10610963,10610964,10610965,10610999,10565200,10565225,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565282,10565283,10565284,10565299,10565300,10565303,10565328,10611184,10611186,10611187,10611188,10611191,10611197,10565349,10611250,10611338,10611339,10611340,10611341,10611362,10611380,10611412,10611413,10611414,10611427,10611440,10611450,10611451,10611455,10611462,10611464,10611466,10611469,10611472,10611476,10611477,10611479,10611491,10611495,10565646,10565647,10611498,10611499,10611514,10611517,10611521,10565673,10611563,10611573,10611579,10611582,10611585,10611587,10611594,10611596,10611597,10611620,10611624,10611676,10611731,10611812,10611830,10611832,10611833,10611834,10611856,10611925,10611952,10609309,10609355,10609369,10563565,10563566,10609706,10609707,10609749,10609913,10609925,10609926,10609927,10609944,10609948,10609949,10609950,10609988,10610015,10517222,10517223,10517224,10517670,10517799,10517801,10517802,10517805,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10419256,10419271,10419307,10419370,10419437,10419450,10419454,10419455,10419457,10419468,10419469,10419470,10419471,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419494,10419495,10419496,10419497,10419498,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419535,10419537,10419539,10419540,10419541,10419542,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419556,10419557,10419558,10419559,10419560,10419561,10419562,10419563,10419564,10419565,10419566,10419567,10419677,10419678,10419705,10419706,10419712,10419725,10419727,10419732,10419734,10419735,10419739,10419793,10419802,10419803,10419804,10419805,10419806,10419808,10419809,10419810,10419819,10419820,10419823,10419824,10419826,10419827,10419829,10419831,10419832,10419833,10419888,10419889,10419890,10419897,10419904,10419994,10419997,10419999,10420000,10420004,10420006,10420008,10420011,10420037,10420038,10420039,10420040,10420041,10420042,10420054,10420055,10420056,10420057,10420058,10420059,10420060,10420086,10420089,10420092,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10420216,10420217,10420219,10420220,10471122,10471171,10471173,10471174,10469949) 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'