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(7075912,7076124,7076125,7076126,10198396,10198397,4970670,4970671,4970675,4970685,4970738,10198673,10198680,8569474,8569607,8569608,8569625,4971081,7065836,7065837,10199769,10199807,10437751,10437753,10437774,10223134,8067942,8067943,10197279,7067196,10197931,7071829,10195094,7064168,8075333,8075334,8075335,8075336,7064733,7064735,7064760,7064761,7064771,7064822,7064856,7064863,7064878,7064892,7064911,7064912,7064926,7064947,7064977,7064983,7064984,7064985,7064986,7065004,10196326,7073161,10196416,10196424,10196425,10196426,10196489,10196490,10196591,10196592,7065457,10222886,10222887,10194461,10194462,8861260,7071537,8970239,10194999,10195003,8071673,8071676,8071682,8071687,8071691,8071695,8071701,8071703,8071705,8071706,8071707,8071717,8071726,8071733,8071738,8071741,8071747,8071752,8071756,8071760,8071766,8071768,8071770,8071771,8071772,8071782,8071791,8071798,8071803,8071806,8071812,8071817,8071821,8071822,8071831,8071833,8071835,8071836,8071837,8071847,8071856,8071863,8071868,8071871,8071877,8071882,8071886,8071890,8071896,8071898,8071900,8071901,8071902,8071912,8071921,8071928,8071933,8071936,8071942,8071947,8071951,8071955,8071961,8071963,8071965,8071966,8071967,8071977,8071986,8071993,8071998,8072001,8072007,8072012,8072016,8072020,8072026,8072028,8072030,8072031,8072032,8072042,8072051,8072058,8072063,8072066,8072072,8072077,8072081,8072085,8072091,8072093,8072095,8072096,8072097,8072107,8072116,8072123,8072128,8072131,8072137,8072142,8072146,8072150,8072156,8072158,8072160,8072161,8072162,8072172,8072181,8072188,8072193,8072196,8072202,8072207,8072211,8072215,8072221,8072223,8072224,8072226,8072227,8072237,8072246,8072253,8072258,8072261,8072267,8072272,8072276,8072280,8072286,8072288,8072290,8072291,8072292,10941262,10945086,10945101,10941948,8860412,10190221,10618183,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,10623495,10623496,8070212,8070214,8070219,8070224,8070225,8070230,8070234,8070237,8070314,8070319,10204170,8071516,8071525,8071535,8071540,10619835,8071543,10619836,8071549,8071554,8071558,8071562,8071569,8071571,8071573,8071574,8071575,10619871,8071587,10619887,8071596,8071603,10619895,10619896,8071608,8071611,8071617,8071622,8071626,8071630,8071636,10619928,8071638,8071640,8071641,8071642,8071652,8071661,8071668,10617138,10617171,10189311,10189312,10189313,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10617322,10617323,10617324,10617325,10617326,10617332,10617333,10617334,10617335,10617336,10617337,10617338,10617339,10617340,10617341,10617342,10617343,10617344,10617345,10617346,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617355,10617356,10617357,10617358,10617359,10617360,10622360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617370,10617371,10617372,10617373,10617374,10617375,10617376,10617377,10617378,10617379,10617380,10617381,10617382,10617383,10617384,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10622405,10617406,10617407,10622408,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617425,10617426,10617427,10617428,10617429,10617430,10617431,10622431,10617432,10617433,10617434,10617435,10617436,10617437,10617438,10617439,10617440,10617441,10622441,10617442,10617443,10617444,10617445,10622445,10617446,10617447,10622447,10617455,10617456,10617461,10622514,10622516,10622523,10622533,10620183,10620208,10615222,10615229,8570104,10620303,10615339,10615340,10615341,10615342,10615343,10615352,10200643,10200646,10200647,10200648,10200649,10200650,10200653,10200654,10200655,10200656,10200657,10200658,10200659,10200660,10200661,8570413,10615598,10615709,10615721,10615722,10615780,10615896,10616005,10616044,10616045,10616058,10616542,10616543,10616544,10616644,10201739,10201843,10201844,10616898,10616905,7059524,7059608,10565319,10614203,10614220,7059792,10614376,6665789,10614499,10614501,10614502,10614503,10614504,10614505,10614552,10614553,10614554,10559705,10559706,10559709,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,6665932,10562767,6666207,6666208,6666210,6666211,6666212,6666213,6666214,6666215,6666259,10611969,7057605,10612194,10612201,7057713,10612268,10612294,10612320,10612321,10612381,8862481,10612916,10612936,10612937,10612938,10612939,10612941,10612942,10612943,8862865,10613089,10613093,10613096,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613133,10613136,10613144,10558317,10558318,10558319,10558320,10613192,10613220,10613221,10613235,10613362,10613369,10561523,10561524,10613506,10613513,10613514,10613545,10613729,10564883,10613736,10613740,10613750,10564973,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515309,10515310,10515327,7055724,10515377,10515422,10515423,7055800,7055836,7055956,10517614,10517615,10517616,10517617,10517618,10515683,10515684,10515685,7056039,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,7056270,7056309,10513974,10513975,7056339,7056340,10514015,10516119,10516120,10516121,10516122,10516123,10516124,10516125,10516126,10516127,10516136,10516137,10516138,10516139,10516193,4975237,10512530,10512562,10512563,10512564,10512565,7057197,10516866,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10419306,4973244,10419349,10419350,10416358,10416359,10416361,10419375,10419468,10419469,10419473,10419474,10419475,10419477,10419478,10419479,10419480,10419481,10416481,10419482,10419484,10419485,10419487,10419489,10419491,10419493,8918228,10419509,10419510,8918274,8918275,7054861,7054936,10418708,10418709,10418710,4973643,4973736,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,7055155,7055241,7055242,7055299,7055346,10420150,10420151,10420152,10420153,10420155,10420156,10420158,10420159,10420161,10420163,10420165,10420166,10419166,10420168,10420170,10420171,10420172,10419172,10419173,10420174,10420176,10420177,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420194,10420196,10420197,10420198,10420199,10420200,7055445,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,7055456,10420212,7055457,10420213,7055458,10420214,7055459,10420215,10471171,10471172,10471173,10471174,10467217,10467218,10467221,10469277,10469278,10467327,8916476,8916477,8916760,8916798,10467796,10467797,8916958,8917093,10468234,10468235,10468236,10468237,10468239,10628177,10155731,10631994,10632106,10632107,10632108,10632109,10632110,10627145,10632166,10632167,10632168,10627319,10627405,10627775,10630042,10630170,10626241,10626299,10626300,10626301,10631412,10631413,10631414,10631415,10631416,10631417,10631418,10631419,10631420,10631421,10631422,10631423,10631424,10631425,10631426,10631427,10631428,10631429,10626429,10631430,10626430,10631431,10626431,10631432,10631433,10631434,10631435,10631436,10631437,10631438,10631439,10631440,10631441,10631442,10631443,10631444,10631445,10631446,10631447,10631448,10631449,10631450,10631451,10631452,10631453,10631454,10626711,10626798,10631882,10631885,10566666,10566667,10566668,10567624,10521691,10521692,10521696,10522409,10522412,10522413,10522414,10522415,10522427,10522428,10522429,10522430,10522433,10522448,10522452,10522453,10522462,10522571,10520755,10520756,10420717,10421934,10421935,10422167) 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'