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(10198156,10224426,10224427,10198688,10198689,4971022,4971023,7068711,7068712,7068715,10224955,7068717,7068718,7068734,7068735,7068736,7068737,7068760,7068773,7068774,8569777,7068813,8569796,10933301,7074270,7066281,7074303,10199641,10199642,10199643,10199644,10199645,10199646,10199647,10199648,10199649,10199651,10199652,10199653,10199654,10199655,10199656,10199779,10199780,7066674,7066712,7066714,7075045,7075093,7075094,7075095,7075281,7075282,7075283,7075284,7075285,7075286,7075287,7075288,7075291,7075415,7075434,7067445,7075666,10197945,7067767,10221177,10221178,10221179,10221180,10221181,8075289,7072525,4967028,10932192,7072895,7072957,7072963,7065155,10209407,10196535,10222559,10222560,10222561,7073557,10223028,10220087,7070879,7070880,7070885,7070889,7070893,7070898,7070902,7070903,7070905,7070909,7070915,7070925,7070929,7070934,7070936,7070941,7070945,7070947,7070954,7070966,7070967,7070968,7070969,7070970,8860916,7071024,7071030,7071035,7071037,7071040,7071041,7071044,7071045,7071046,7071053,7071054,7071055,7071056,7071057,7071058,7071059,7071060,7071071,10220347,10220348,10220349,10220350,10194350,10220351,10194351,10194352,10220352,10220353,10194353,10220354,10220355,10220356,10220357,10220358,10220359,10220360,10220361,10220362,10220363,10220364,10220365,10220366,10220367,10220368,10220369,10220370,10220371,10220372,10220373,10220374,10220375,10220376,10220377,10220378,10220379,10220380,10220381,10220382,10220383,10220384,10220385,10220386,10220387,10220388,10220389,10220390,10220391,10220392,10220393,10220394,10220395,10220396,10220397,10220398,10220399,10220400,10220401,10220402,10220403,10220404,10220405,10220406,10220407,10220408,7071171,10220409,10220410,10220411,10220412,10220413,10220414,10220415,10220416,10220417,10220418,10220419,10220420,10220421,10220422,10220423,10220424,10220425,10220426,10220427,10220428,10220429,10220430,10220431,10220432,10220433,10220434,10220435,10220436,10220437,10220438,10220439,10220440,10220441,10220442,10220443,10220444,10220445,10220446,10220447,10220448,10220449,10220450,10220451,10220452,10220453,10220454,10220455,10220456,10220457,10220458,10220459,10220460,10220461,10220462,10220463,10220464,10220465,10220466,10220467,10220468,10220469,10220470,10220471,10220472,10220473,10220474,10220475,10220476,10220477,10220478,10220479,10220480,10220481,10220482,10220483,10220484,10220485,10220486,10220487,10220488,10220489,10220490,10220491,10220492,10220493,10220494,10220495,10220496,10220497,10220498,10220499,10220500,10220501,10220502,10220503,10220504,10220505,10220506,10220507,10220508,10220509,10220510,10220511,10220512,7071363,7071364,7071365,7071366,7071367,10943142,10943143,10943144,10943145,10943146,10943150,10943151,10943176,10943177,10943178,10943218,8861481,8861482,7071625,7071626,10207878,10207879,7071649,7071650,7071651,7071652,7071685,10220937,10218062,10218063,10218064,10218065,10218066,10218067,10218068,10218069,7068832,7068844,7068867,7068907,7068936,10218198,10218199,10218200,10218201,10218202,10218203,10218204,10218205,10218206,10218207,10218208,10218209,10218210,10218211,10940688,10218212,10218213,10218214,10218215,10218216,10218217,10218218,10940695,10940709,10940711,10940712,10940713,10940714,10940715,10940716,10940723,7069228,7069229,7069230,7069231,7069235,7069241,7069242,7069243,7069244,7069245,7069246,7069247,7069248,7069249,7069250,7069252,7069253,7069302,7069304,7069305,10205572,10205573,10205574,10205575,10205576,10205577,10205578,10205579,10205580,10205581,10205582,10205583,10205584,10205585,10205586,10205587,10205588,10218624,10218625,10218626,10218627,10218628,10218629,10218630,10218631,10218632,10218633,10218634,10218635,10218636,10218637,10218638,10218639,10218640,10218641,10218642,10218643,10218644,10218645,10218646,10218647,10218648,10218718,10218719,10218720,10218721,10218722,10193302,10206481,10206482,10206643,10206713,7070584,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8860651,8860682,10618129,10623491,10623492,10191042,10191043,10619018,10619019,10619029,10619030,10204247,10619149,10619150,10204249,10204250,10204251,10204252,10204253,10204254,10204255,10204256,10619356,10204537,10204538,10204539,10619894,10621993,10621994,10621995,10621996,10622014,10622060,10622071,10189204,10622106,10622107,10622108,10622109,10202208,10622110,10927923,10927924,10927925,10927926,10927927,10927928,10617804,8569805,8569806,10615015,10920558,10920563,8569899,8569900,10620080,10920600,8570019,10925747,10925748,10925749,10925750,10920755,10920978,10926120,10926180,10926181,10926182,10926183,10926186,10926187,10926188,10926189,10926190,10926191,10926192,10926193,10926194,10926195,10926196,10926197,10926198,10926199,10926200,10926201,10926202,10926203,10926204,10200801,10200802,10926240,10921240,10926241,10921258,10921396,10921410,10616004,10930829,10930850,10921617,10621109,10621121,10621124,10621128,10621129,10621136,10621144,10930980,10926709,10926710,10926711,10926712,10926713,10921732,10921733,10921734,10921735,10921753,10921754,10921938,10921939,10616548,10922120,10922121,10927196,10927197,10927198,10616699,10616700,10616864,10201983,10201984,10201985,10201986,10616892,7059474,7059499,10559336,8864292,8864307,10614441,8864317,10566045,10566047,10566048,10566049,10566050,10566054,7057538,8861970,7057672,7057699,10557455,10557476,10557477,10557478,10557479,10557480,10557481,10557482,10557483,10557484,7057902,10612491,10612492,10612498,8862848,8862849,7058717,7058718,8863159,8863703,10517112,10517113,10517114,10517115,10517116,10517142,10517143,10517144,10517149,10517150,10517151,10517152,10517153,10517154,10517155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,7055534,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10513288,10513289,10513290,4974443,10513408,10513409,10513410,10513411,10513412,10513413,10513414,10513415,10513416,10513417,10513418,10513419,10513420,10513421,10513422,10513423,10513424,10513425,10513426,10513427,10513428,10513429,10513430,10513431,10513432,10513433,10513434,10517564,10517565,10517566,10517567,10517568,10517569,10517570,10517571,10517572,10517573,10517574,10517575,10517576,10517577,10517578,10517579,10517580,10517581,10517582,10517583,10517584,10517585,10517586,10517587,10517588,10517589,10517590,10517591,10517592,4974648,4974649,7055962,10517681,7056077,10517787,7056368,7056369,7056370,7056371,7056372,7056373,7056374,7056375,7056376,10514034,7056399,7056400,10514044,10514045,10514046,10514061,7056423,7056424,7056425,7056426,7056427,7056428,7056429,4975123,4975124,7056456,7056457,7056458,4975227,10516188,7056921,7056997,7056998,7056999,7057000,7057001,7057002,7057003,10514646,7057024,7057025,7057026,10514784,10514845,10514846,10514847,10514848,10514849,10514850,10514851,10514893,10514894,7057432,10515085,10519089,10517105,10517106,10517107,10517108,10517109,10517110,10517111,8918051,8918064,4973601,4973602,10417110,7055445,8864913,8864929,8864930,8864931,8864932,8864933,8864934,8864935,8864936,8864937,8864938,8864939,8864940,8864941,8864984,8865038,8865039,8865112,8865113,8865114,8865184,8865185,8865186,8865189,8865190,10467435,10467436,10469528,10469529,10469530,10469531,10469533,10469535,10469536,10469537,10469538,4971931,10465686,10465687,4971994,4971995,4971996,4972008,4972009,4972010,4972011,4972012,4972013,10465776,10465803,10465804,10465865,10465866,10463881,10463882,8917175,8917176,8917177,8917178,8917179,8917180,8917219,4972431,4972432,4972433,4972450,10466211,10466353,10466354,10466355,10466356,10466412,10466747,10464800,10466852,10629608,10629610,10629692,10629912,10629913,10627019,10632042,10632043,10627896,10631277,10626308,10626309,10626310,10626315,10626316,10626317,10626318,10631328,10626832,10626833,10626834,10626835,10626836,10626837,10626838,10626839,10626840,10626841,10571294,10568626,10568627,10568628,10568629,10571806,10571811,10571812,10569526,10569853,10569854,10569855,10569856,10569857,10569858,10569875,10570099,10570100,10570101,10570102,10567341,10567406,10567407,10567443,10567460,10567461,10567462,10521324,10521325,10521569,10521780,10521781,10521852,10522324,10522325,10522326,10522327,10522328,10522329,10522330,10522331,10522332,10522333,10522334,10522335,10522336,10522337,10522348,10522349,10522350,10522351,10522352,10522353,10522354,10522355,10522356,10522357,10522386,10522388,10520777,10520836,10520837,10520838,10520841,10520842,10520843,10520844,10520845,10520846,10520847,10520848,10520889,10522991,10521025,10521029,10420416,10421077,10422172,10421205,10421206,10421219,10473095,10473096,10473097,10473627) 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'