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(7201632,7201633,7201634,7201959,10198534,4970721,4970722,4970723,7202277,7066105,7066106,7066107,7066108,7066109,7066110,7066111,10844713,8573267,8573268,8573269,8573270,8067927,7201240,7201335,7201336,7201526,7201527,7198722,7198723,7198726,7199005,7199006,7199007,7199008,7199009,7199010,7199011,7199012,7199013,7199014,7199015,7199016,7199017,7199018,7199019,7199570,10101534,10101535,10101536,10248804,10248806,10248807,10248808,10248809,10248810,10944447,8542165,8905765,8905766,8905767,8905768,8905769,8905770,8905771,8905772,8905773,8905774,8905775,8905776,8905777,8905778,8905779,8905780,8612652,10838834,10426358,10426359,10426360,8611382,8611383,10230677,10230678,8905149,10230949,10619895,10619896,10617126,10617138,10617139,10617140,10615334,10615711,10616476,10616479,10431607,8583518,10613962,10613963,10613964,10613965,10613966,10613967,10613968,10613969,10613970,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10613985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10613995,10613996,10613997,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,7059524,10614014,10614015,10614016,10614017,10614018,10614019,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,10614064,10714156,9211941,9211942,9211943,9211944,10613127,10613350,9204938,10613732,10613733,10613797,10613811,10613812,10613813,10613814,10613815,10613816,10613817,10613818,10613819,10613820,10613821,10613822,10613823,10613824,10613825,10613826,10613827,10613828,10613829,10613830,10613831,10613832,10613833,10613834,10613835,10613836,10613837,10613838,10613839,10613840,10613841,10613842,10613843,10613844,10613845,10613846,10613847,10613848,10613849,10613850,10613851,10613852,10613853,10613854,10613855,10613856,10613857,10613858,10613859,10613860,10613861,10613862,10613863,10613864,10613865,10613866,10613867,10613868,10613869,10613870,10613871,10613872,10613873,10613874,10613875,10613876,10613877,10613878,10613879,10613880,10613881,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10613895,10613896,10613897,10613898,10613899,10613900,10613901,10613902,10613903,10613904,10613905,10613906,10613907,10613908,10613909,10613910,10613911,10613912,10613913,10613914,10613915,10613916,10613917,10613918,10613919,10613920,10613921,10613922,10613923,10613924,10613925,10613926,10613927,10613928,10613929,10613930,10613931,10613932,10613933,10613934,10613935,10613936,10613937,10613938,10613939,10613940,10613941,10613942,10613943,10613944,10613945,10613946,10613947,10613948,10613949,10613950,10613951,10613952,10613953,10613954,10613955,10613956,10613957,10613958,10613959,10613960,10613961,9169822,10118147,10118148,10118149,10118150,10118151,10118152,10118153,10118154,8552198,8552199,8552200,8552201,8552202,8552203,8552204,8552205,8552206,8552207,8552208,8552209,8552210,8552211,8552212,10417398,10417399,10417400,10417401,10417406,10417407,10417408,10416481,10116818,10417633,9169034,9169035,9169036,9169037,9169038,9169039,9169040,9169041,9169042,9169043,9169044,9169045,9169046,9169047,9169048,9169049,9169050,9169051,9169052,9169053,9169054,9169055,9169056,9169057,9169058,9169059,9169060,9169061,9169062,9169063,9169064,9169065,9169066,9169067,9169068,9169069,9169070,9169071,9169072,9169073,9169074,9169075,9169076,9169077,9169078,9169079,9169080,9169081,9169082,9169083,9169084,9169085,9169086,10469337,10469338,10469339,10469340,10469341,10469342,10469343,10469344,10469345,10469346,10469347,10469348,10469349,10469350,10469351,10469352,10469353,10469354,10469355,10469356,10469357,10469358,10469359,10469360,10469361,10469362,10469363,10469364,10469365,10469366,10469367,10469368,10469369,10469370,10469371,10469372,10469373,10469374,10469375,10469376,10469377,10469378,10469379,10469380,10469381,10469382,10469383,10469384,8550037,8550038,8550077,10115665,10884653,10886057,10886058,10886059,10886060,10886061,10886062,10886063,10886064,10886065,10886069,10886070,10886071,10886072,10886073,10886074,10886075,10886076,10886077,10162083,10886078,10162084,10886079,10162085,10886080,10162086,10886081,10162087,10886082,10162088,10886083,10162089,10886084,10162090,10886085,10162091,10886086,10162092,10886087,10162093,10886088,10162094,10886089,10162095,10886090,10162096,10886091,10162097,10886092,10886093,10886094,10886095,10886096,10886097,10886098,10886099,10886100,10886101,10886102,10886103,10886104,10886105,10886106,10886107,10886108,10886109,10886110,10886111,10886112,10886113,10886114,10886115,10886116,10886117,10886118,10886119,10886120,10886121,10886122,10886123,10886124,10886125,10886126,10886127,10886128,10886129,10886130,10886131,10886132,10886133,10886134,10886135,10886136,10886137,10886138,10886139,10886140,10886141,10886142,10886143,10886144,10886145,10886146,10886147,10886148,10886149,10886150,10886151,10886152,10886153,10886154,10886155,10886156,10886157,10886158,10886159,10886160,10886161,10886162,10886163,10886164,10886165,10886166,10886167,10886168,10886169,10886170,10886171,10886172,10886173,10886174,10886175,10886176,10886177,10886178,10886179,10886180,10886181,10886182,10886183,10886184,10886185,10886186,10886187,10886188,10886189,10886190,10886191,10886192,10886193,10886194,10886195,10886196,10886197,10886198,10886199,10886200,10886201,10886202,10886203,10886204,10886205,10886206,10886207,10886208,10886209,10886210,10886211,10886212,10886213,10886214,10886215,10886216,10886217,10886218,10886219,10886220,10886221,10886222,10886223,10886224,10886225,10886226,10886227,10886228,10886229,10886230,10886231,10886232,10886233,10886234,10886235,10886236,10886237,10886238,10886239,10886240,10886241,10886242,10886243,10886244,10886245,10886246,10886247,10886248,10886249,10886250,10886251,10886252,10886253,10886254,10886255,10886256,10886257,10886258,10886259,10886260,10886261,10886262,10886263,10886264,10886265,10886266,10886267,10886268,10886269,10886270,10886271,10886272,10886273,10886274,10886275,10886276,10886277,10886278,10886279,10886280,10886281,10886282,10886283,10886284,10886285,10886286,10886287,10886288,10886289,10886290,10886291,10886292,10886293,10886294,10886295,10886296,10886297,10886298,10886299,10886300,10886301,10886302,10886303,10886304,10886305,10886306,10886307,10886308,10886309,10886310,10886311,10886312,10886313,10886314,10886315,10886316,10886317,10886318,10886319,10886320,10886321,10886322,10886323,10886324,10886325,10886326,10886327,10886328,10886329,10886330,10886331,10886332,10886333,10886334,10886335,10886336,10886337,10886338,10886339,10886340,10886341,10886342,10886343,10886344,10886345,10886346,10886347,10886348,10886349,10886350,10886351,10886352,10886353,10886354,10886355,10886356,10886357,10886358,10886359,10886360,10886361,10886362,10886363,10886364,10886365,10886366,10886367,10886368,10886369,10886370,10886371,10886372,10886373,10886374,10886375,10886376,10886377,10886378,10886379,10886380,10886381,10886382,10886383,10886384,10886385,10886386,10886387,10886388,10886389,10886390,10886391,10886392,10886393,10886394,10886395,10886396,10886397,10886398,10886399,10886400,10886401,10886402,10886403,10886404,10886405,10886406,10886407,10886408,10886409,10886410,10886411,10886412,10886413,10886414,10886415,10886416,10886417,10886418,10886419,10886420,10886421,10886422,10886423,10886424,10886425,10886426,10886427,10886428,10886429,10886430,10886431,10886432,10886433,10886434,10886435,10886436,10886437,10886438,10886439,10886440,10886441,10886442,10886443,10886444,10886445,10886446,10886447,10886448,10886449,10886450,10886451,10886452,10886453,10886454,10886455,10886456,10886457,10886458,10886459,10886460,10886461,10886462,10886463,10886464,10886465,10886466,10886467,10886468,10886469,10886470,10886471,10886472,10886473,10886474,10886475,10886476,10886477,10886478,10886479,10886480,10886481,10886482,10886483,10886484,10886485,10886486,10886487,10886488,10886489,10886490,10886491,10886492,10886493,10886494,10886495,10886496,10886497,10886498,10886499,10886500,10886501,10886502,10886503,10886504,10886505,10886506,10886507,10886508,10886509,10886510,10886511,10886512,10886513,10886514,10886515,10886516,10886517,10886518,10886519,10886520,10886521,10886522,10886523,10886524,10886525,10886526,10886527,10886528,10886529,10886530,10886531,10886532,10886533,10886534,10886535,10886536,10886537,10886538,10886539,10886540,10886541,10886542,10626724,10626725,10631794,10631795,10882353,10421543) 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'