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(4970668,4970669,4970675,4970686,4970687,4970688,4970700,4970701,4970717,4970721,4970722,4970723,4970724,4970767,10938683,10939141,10939185,10939281,10939382,10939393,10939394,10939395,10939419,10939423,10939504,10939505,10939519,10939520,4967032,8065795,8065838,8065839,8065840,8065847,10623061,10623064,10623065,10623491,10623492,10623508,10623965,10622197,10622424,10620186,10620188,10620193,10620196,10620197,10620199,10620201,10620203,10620204,10620205,10620206,10620207,10620208,10620253,10620444,10620796,10610984,10610985,10610987,10610988,10610989,10611000,10611001,10611002,10611003,10611004,10611005,10611006,10611009,10611010,10611011,10611017,10611018,10611019,10611020,10611022,10611026,10611027,10611028,10611029,10611030,10611031,10611037,10611048,10611052,10611053,10611054,10611055,10611056,10611057,10611058,10611059,10611060,10611061,10611126,10611185,10611267,10611293,10611367,10611368,10611369,10611370,10611374,10611375,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,10611409,10611410,10611411,10611412,10611413,10611414,10611415,10611416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10611446,10611447,10611448,10611449,10611450,10611451,10611452,10611453,10611454,10611455,10611456,10611457,10611458,10611459,10611460,10611461,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,10611503,10611504,10611505,10611506,10611507,10611508,10611509,10611510,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10611518,10611519,10611520,10611521,10611522,10611523,10611524,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,10565700,10565701,10611551,10611552,10565702,10611553,10565703,10565704,10611554,10611555,10565705,10565706,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611615,10611616,10611617,10611618,10611619,10611620,10611621,10611622,10611623,10611624,10611625,10611626,10611627,10611628,10611629,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611637,10611638,10611639,10611640,10611641,10611642,10611643,10611644,10611645,10611646,10611647,10611648,10611649,10611650,10611651,10611652,10611653,10611654,10611655,10611656,10611657,10611658,10611659,10611660,10611661,10611662,10611663,10611664,10611665,10611666,10611667,10611668,10611669,10611670,10611671,10611672,10611673,10611674,10611675,10611676,10611677,10611678,10611679,10611680,10611681,10611682,10611742,10611743,10611751,10611763,10611780,10611788,10611800,10611801,10611815,10611816,10611818,10611823,10611830,10611831,10611856,10609011,10609022,10609075,10609080,10609153,10609154,10609155,10609164,10609165,10609168,10609169,10609188,10609189,10609190,10609191,10609195,10609196,10609197,10609200,10609202,10609243,10609244,10609245,10609246,10609247,10609256,10609257,10609258,10609260,10609261,10609262,10609285,10609286,10609303,10609311,10609313,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609368,10609369,10609370,10609371,10609372,10609373,10609374,10609375,10609376,10609377,10609378,10609379,10609385,10609386,10609387,10609388,10609389,10609390,10609391,10609392,10609393,10609394,10609395,10609396,10609397,10609398,10609399,10609400,10609401,10563557,10609440,10609537,10609538,10609539,10609557,10609559,10609562,10609563,10609564,10609565,10609566,10609567,10609568,10609569,10609587,10609588,10609589,10609592,10609615,10609664,10609665,10609680,10609698,10609699,10609703,10609713,10609714,10609715,10609716,10609717,10609719,10609720,10609721,10609722,10609723,10609724,10609725,10609726,10609727,10609728,10609729,10609730,10609731,10609747,10609749,10609753,10609754,10609755,10609756,10609758,10609759,10609760,10609761,10609762,10609764,10609765,10609766,10609770,10609772,10609782,10609815,10609816,10609818,10609819,10609821,10609822,10609824,10609826,10609828,10609832,10609833,10609835,10609836,10609837,10609838,10609839,10609841,10609845,10609846,10609847,10609848,10609850,10609854,10609855,10609856,10609857,10609858,10609859,10609860,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10609870,10609871,10609872,10609873,10609874,10609875,10609877,10609878,10609881,10609882,10609883,10609884,10609885,10609886,10609888,10609889,10609897,10609900,10609901,10609902,10609903,10609904,10609905,10609906,10609907,10609911,10609914,10609915,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609944,10609945,10609946,10609947,10609948,10609949,10609950,10609952,10609953,10609966,10609972,10609975,10609976,10609978,10609979,10609981,10609986,10609988,10610006,10610014,10610025,10610030,10610054,10610098,10610129,10610130,10610150,10610151,10610152,10610162,10610163,10610167,10610168,10610236,10610268,10610271,10610282,10610289,10610304,10610315,10610316,10610318,10610319,10610338,10610408,10610414,10610466,10610479,10610492,10610493,10610668,10610678,10610684,10610685,10610686,10610687,10610688,10610689,10564839,10610690,10610691,10610692,10610693,10610694,10610695,10610696,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,10610794,10610836,10610844,10610848,10610849,10610854,10610862,10610915,10610916,10610935,10610936,10610939,10610954,10610958,10415223,10419252,10419253,10419255,10419258,10419266,10419267,10419268,10419271,10419272,10419285,10419292,10419293,10419295,10419296,10415322,10415323,10415333,10415339,10415340,10419351,10419354,10419370,10415373,10415374,10419407,10419408,10415416,10415417,10415418,10415419,10415424,10415425,10415426,10415427,10415430,10415431,10415432,10415433,10415434,10415435,10415438,10415439,10415440,10419440,10415441,10419441,10415442,10415443,10415444,10415445,10415446,10419473,10419474,10419475,10419477,10419478,10419479,10419480,10419481,10419482,10419484,10419485,10419487,10419489,10419491,10415537,10415538,10419569,10419570,10419571,10415579,10415580,10415581,10415582,10415583,10415584,10415585,10415586,10419592,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10415610,10419610,10419611,10419612,10419613,10419614,10419615,10415616,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10415635,10419636,10419637,10419641,10419642,10419643,10419644,10419645,10415646,10419646,10419653,10419654,10419655,10415656,10419659,10415661,10419661,10415662,10419662,10415663,10419663,10419664,10415665,10419665,10415666,10419666,10419667,10415668,10415671,10415672,10415673,10415683,10415684,10419698,10419699,10419700,10419702,10415745,10415748,10419768,10419769,10419770,10419771,10419772,10419773,10419774,10419775,10419776,10419777,10419778,10419779,10419780,10419781,10420106,10420107,10420112,10420114,10420115,10420116,10420119,10420120,10420121,10420122,10420123,10420124,10420128,10420129,10420130,10420131,10471041,10471044,10471056,10471057,10471058,10471064,10471066,10471105,10471106,10471108,10471114,10471116,10471117,10471118,10471120,10471134,10471135,10471246,10470152,10470153,10470154,10470155,10470161,10470207,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470806,10470807,10470811,10470812) 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'