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(4970679,4970684,4970686,4970700,4970715,4970716,4970717,4970723,4970742,4970743,8067935,8067938,8067939,10939423,8065838,8065839,8065840,10931197,10623490,10623491,10623492,10623505,10623508,10620200,10620201,10620202,10613965,10613966,10613982,10610984,10610985,10613990,10613992,10613994,10614000,10614002,10614003,10614004,10614005,10614011,10614015,10614017,10614026,10614037,10614045,10614046,10614048,10614050,10614052,10611064,10611126,10611128,10614144,10614166,10614172,10614181,10611185,10611226,10611236,10611239,10611240,10611241,10614259,10614282,10611291,10611293,10614314,10614316,10614327,10614328,10614329,10614330,10611334,10611374,10611375,10614376,10611376,10611377,10611378,10611379,10611380,10611381,10611382,10611383,10611384,10611385,10611386,10611387,10611388,10611389,10611390,10611391,10611392,10611393,10611394,10611395,10611396,10611397,10611398,10611399,10611400,10611401,10611402,10611403,10611404,10611405,10611406,10611407,10611408,10614408,10611409,10614409,10611410,10611411,10611412,10614413,10611413,10611414,10614414,10614415,10611415,10611416,10614416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611432,10611433,10611434,10611435,10611436,10611437,10614438,10611438,10614439,10611439,10611440,10611441,10611442,10611443,10611444,10614445,10611445,10611446,10611447,10611448,10611449,10611450,10611451,10611452,10611453,10611454,10611455,10611456,10611457,10611458,10611459,10611460,10611461,10614462,10611462,10611463,10611464,10611465,10611466,10611467,10611468,10611469,10611470,10611471,10611472,10611473,10611474,10611475,10611476,10611477,10611478,10611479,10611480,10611481,10611482,10611483,10611484,10611485,10611486,10611487,10611488,10611489,10611490,10611491,10611492,10611493,10611494,10611495,10611496,10611497,10611498,10611499,10611500,10611501,10611502,10614503,10611503,10614504,10611504,10614505,10611505,10611506,10611507,10611508,10611509,10611510,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10614518,10611518,10611519,10611520,10611521,10611522,10611523,10614524,10611524,10614525,10611525,10611526,10611527,10611528,10611529,10611530,10611531,10611532,10611533,10611534,10611535,10611536,10611537,10611538,10611539,10611540,10611541,10611542,10611543,10611544,10611545,10611546,10611547,10611548,10611549,10611550,10611551,10611552,10611553,10611554,10614555,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10614572,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10614588,10611588,10611589,10611590,10611591,10614592,10611592,10611593,10614593,10611594,10611595,10611596,10611597,10611598,10614599,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611615,10611616,10614617,10611617,10611618,10614618,10614619,10611619,10614620,10611620,10614621,10611621,10614622,10611622,10611623,10614623,10614624,10611624,10611625,10614625,10614626,10611626,10611627,10614627,10611628,10614628,10611629,10614629,10614630,10611630,10611631,10614631,10611632,10614632,10611633,10611634,10611635,10611636,10611637,10611638,10611639,10611640,10611641,10614641,10611642,10611643,10611644,10611645,10611646,10611647,10614647,10611648,10614648,10611649,10611650,10611651,10611652,10611653,10614654,10611654,10611655,10614655,10611656,10614656,10611657,10611658,10614658,10614659,10611659,10611660,10614660,10614661,10611661,10611662,10614662,10614663,10611663,10611664,10614664,10611665,10611666,10611667,10611668,10614668,10611669,10614669,10614670,10611670,10611671,10614671,10614672,10611672,10611673,10614673,10611674,10614674,10614675,10611675,10614676,10611676,10614677,10611677,10614678,10611678,10611679,10614679,10614680,10614681,10614682,10614683,10614684,10614685,10614686,10614687,10614688,10614689,10614690,10614691,10614692,10614693,10614694,10614695,10614697,10614698,10614699,10614700,10614701,10614702,10614703,10614704,10614705,10614706,10614708,10614709,10614710,10614711,10614712,10614713,10614714,10614715,10614716,10614717,10614724,10614725,10614726,10614727,10614728,10614729,10614730,10614731,10614735,10614736,10611742,10611743,10611744,10614746,10614749,10611751,10611752,10614753,10611753,10611754,10614755,10611755,10614756,10614757,10611757,10614758,10614759,10614760,10614761,10614762,10614763,10614764,10614768,10611778,10611802,10614819,10614820,10614821,10614822,10611823,10614830,10614833,10614838,10614852,10611856,10611857,10614858,10611859,10614859,10611860,10611861,10611862,10614864,10611864,10614870,10611878,10614889,10614890,10609072,10609079,10609085,10609087,10609091,10609101,10609189,10609213,10609245,10609246,10609285,10609286,10609350,10609367,10609392,10609394,10609395,10609396,10609537,10609538,10609539,10609559,10609562,10609568,10609569,10609587,10609588,10609615,10609664,10609666,10609667,10609668,10609669,10609670,10609671,10609672,10609673,10609674,10609675,10609676,10609677,10609678,10609679,10609680,10609689,10609690,10609691,10609692,10609693,10609694,10609695,10609696,10609768,10609770,10609772,10609816,10609817,10609818,10609819,10609820,10609821,10609822,10609823,10609824,10609825,10609826,10609827,10609828,10609829,10609830,10609831,10609841,10609845,10609946,10609959,10609962,10609965,10609974,10609979,10609980,10609981,10609994,10610006,10610014,10610025,10610030,10610044,10610054,10610098,10610111,10610167,10610168,10610170,10610174,10610178,10610180,10610181,10610182,10610189,10610191,10610193,10610233,10610235,10610258,10610259,10610263,10610264,10610265,10610268,10610271,10610272,10610274,10610279,10610284,10610285,10610295,10610298,10610299,10610372,10610429,10610437,10610492,10610493,10610568,10610694,10610696,10610698,10610709,10610719,10610720,10610721,10610722,10610723,10610724,10610725,10610726,10610727,10610728,10610729,10610730,10610731,10610732,10610733,10610734,10610735,10610736,10610737,10610738,10610739,10610740,10610741,10610742,10610743,10610744,10610745,10610746,10610747,10610748,10610749,10610750,10610751,10610752,10610862,10610902,10610903,10610904,10610905,10610906,10610941,10610942,10610958,10419285,10419292,10419295,10419296,10415313,10415314,10415326,10415333,10415339,10419342,10419354,10415386,10419407,10419408,10419446,10419447,10419448,10419449,10419472,10419474,10419475,10419476,10419477,10419478,10419479,10419481,10415481,10419482,10419483,10419484,10419486,10419488,10419490,10419492,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10415616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10415635,10419635,10419636,10419641,10419642,10419643,10419644,10419645,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,10415672,10415673,10415696,10415697,10415702,10415703,10415704,10415715,10415716,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,10415743,10415745,10415746,10415747,10415748,10415749,10415750,10415751,10415752,10415753,10415754,10415755,10415756,10415757,10415758,10415759,10415760,10415761,10415762,10415763,10415764,10415765,10415766,10415767,10415768,10415769,10415770,10415771,10415772,10415773,10415774,10415775,10415776,10415777,10415778,10415779,10415780,10415781,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10415790,10415798,10415799,10415800,10415801,10415802,10415803,10415804,10415805,10415806,10415826,10415842,10415845,10415846,10415851,10415855,10415856,10415861,10415866,10415869,10415870,10415890,10415891,10415930,10415932,10415934,10415935,10415936,10415937,10415938,10415939,10415941,10416028,10416030,10416032,10416034,10416042,10416046,10416047,10416048,10416051,10416052,10416055,10416056,10416060,10416076,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10416113,10416114,10416117,10416118,10416120,10416121,10416122,10416123,10416124,10416125,10416126,10416127,10416128,10416129,10416130,10416131,10416132,10416133,10416134,10416135,10416136,10416137,10416138,10416139,10416140,10416141,10416142,10416143,10416144,10416145,10416146,10416147,10416148,10416149,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10416209,10416210,10416216,10416217,10416218,10471029,10471041,10471060,10471064,10471110,10471116,10471156,10471158,10471159,10471160,10471173,10469893,10469900,10469903,10469962,10470207,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470683,10470686,10470736,10470740,10470743,10470747,10470752,10470755,10470759,10470760,10470761,10470768,10470772,10470813) 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'