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(10939735,10939910,7068711,7068712,7068715,7068717,7068718,10940347,10940348,10940349,10940350,10940351,7068734,7068735,7068736,7068737,7068760,7068773,7068774,10940405,10940419,8569777,4971022,4971023,7068813,8569796,8569805,8569806,7068832,7068844,10963550,7068867,10963551,10963552,10963553,10963554,10963555,10963556,10963557,10963558,10963560,10963561,10963562,10963563,10963564,10963565,7068907,8569899,8569900,10933301,8066938,10963647,10963648,8066947,8067183,8067184,7074270,7066281,7074303,10977019,10977020,10977021,10977022,10977023,10977024,10977025,10977026,10977027,10977028,10977029,10977030,8067324,10977031,10977032,10977033,10977034,10977035,10977036,10977037,10977038,10977039,10977040,10977041,10977042,10977043,10977044,10977045,10977046,10977047,10977048,10977049,10977050,10977051,10977052,10977053,10977054,10977055,10977056,10977057,10977058,10977059,10977060,10977061,10977062,10977063,10977064,10977065,10977066,10977067,10977068,10977069,10977070,10977071,10977072,10977073,10977074,10977075,10977076,10977077,10977078,10977079,10977080,10977081,10977082,10977083,10977084,10977085,10977086,10977087,10977088,10977089,10977090,10977091,10977092,10977093,10977094,10977095,10977096,10977097,10977098,10977099,10977100,10977101,10977102,10977103,10977104,10977105,10977106,10977107,10977108,10977109,10977110,10977111,10977112,10977113,10977114,10977115,10977116,10977117,10977118,10977119,10977120,10977121,10977122,10977123,10977124,10977125,10977126,10977127,10977128,10977129,10977130,10977131,10977132,10977133,10977134,10977135,10977136,10977137,10977138,10977139,10977140,10977141,10977142,10977143,10977144,10977145,10977146,10977147,10977148,10977149,10977150,10977151,10977152,10977153,10977154,10977155,10977156,10977157,10977158,10977159,10977160,10977161,10977162,10977163,10977164,10977165,10977166,8067551,10977289,10977290,10977291,10977292,10977293,10977294,10977295,10977296,10977297,10977298,10977299,10977330,10977331,10977332,10977333,10977334,10977335,10977336,10977337,10977338,10977339,10977340,7066674,7066712,7066714,10977492,10977493,10977494,10977495,10977496,10977497,10977498,10977499,10977500,10977501,10977502,10977503,10977504,10977505,10977506,10977507,10977508,10977509,10977510,10977511,10977512,10977513,10977514,10977515,10977516,10977517,10977518,10977519,10977520,10977521,10977522,10977523,10977524,10977525,10977526,10977527,10977528,10977529,10977530,10964581,10964582,7075045,7075093,7075094,7075095,10961947,7075281,7075282,7075283,7075284,7075285,7075286,7075287,7075288,7075291,7075415,7075434,7067445,10962157,7075666,7067767,10962586,10962587,10972946,7072525,8075289,4967028,10960513,10932192,7072895,7072957,7072963,8065995,7065155,7073557,7070936,7070941,7070945,7070947,7070954,7070966,7070967,7070968,7070969,7070970,7071024,7071030,7071035,7071037,7071040,7071041,7071044,7071045,11048945,7071046,7071053,7071054,7071055,7071056,7071057,7071058,7071059,7071060,7071071,7071171,7071363,7071364,7071365,7071366,7071367,10943142,10943143,10943144,10943145,10943146,10943150,10943151,10943176,10943177,10943178,11049480,11049481,10943218,7071625,7071626,7071649,7071650,7071651,7071652,7071685,7068936,10940688,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,10969991,10969992,10970178,10970247,10957385,3656662,3656663,3656664,3656665,3656666,3656676,3656720,3656721,7070584,10971404,10971405,8073505,8073506,8073507,8073508,8073509,10958460,8073510,8073511,10958461,10958462,10958463,11048689,11048719,7070879,7070880,7070885,7070889,7070893,7070898,7070902,7070903,7070905,7070909,7070915,7070925,7070929,7070934,10618129,10967836,10967838,10967839,10967840,10967841,10967842,10967843,10967844,10967845,10918838,10918840,10968109,10968110,10968111,10955114,10955115,10623491,10623492,10919248,10619018,10619019,10619029,10619030,10619149,10619150,10619356,10919913,10969071,10969072,10969073,10969074,10969075,10969076,10969077,10969078,10969079,10969080,10969081,10969082,10969083,10969084,10969085,10969086,10969087,10619894,10917483,10917484,10917485,10621993,10621994,10621995,10621996,10622014,10622060,10622071,10622106,10622107,10622108,10622109,10622110,10917730,10917856,10917857,10927923,10927924,10927925,10927926,10927927,10927928,10918023,10918151,10617804,10918336,10615015,10920558,10920563,8570019,10620080,10920600,10915663,10915664,10915665,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,10921240,10926240,10926241,10921258,10921396,10930829,10921410,10930850,10965656,10965657,10965658,10965659,10616004,10930980,10921617,10621109,10621121,10621124,10621128,10621129,10621136,10621144,10926709,10926710,10926711,10926712,10926713,10921732,10921733,10965882,10921734,10921735,10921753,10921754,10921938,10921939,10917001,10616548,10922120,10922121,10927196,10927197,10927198,10616699,10616700,10953441,10616864,10616892,7059474,7059499,10559336,8864292,10614441,8864307,10611452,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,10609981,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,10517179,10517180,7055534,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10513288,10513289,10513290,10555354,10555355,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,7055962,4974649,10517681,7056077,10517787,7056368,7056369,7056370,7056371,7056372,7056373,7056374,7056375,7056376,10514034,10514044,10514045,7056399,10514046,7056400,10514061,7056423,7056424,7056425,7056426,7056427,7056428,7056429,4975123,4975124,7056456,7056457,7056458,4975227,10516188,10556291,7056921,7056997,7056998,7056999,10514646,7057000,7057001,7057002,7057003,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,10463043,8865038,8865039,8865112,8865113,8865114,8865184,8865185,8865186,8865189,8865190,10463429,10467435,10467436,10469528,10469529,10469530,10469531,10469533,10469535,10469536,10469537,10469538,10463653,4971931,10465686,10465687,4971994,4971995,4971996,4972008,4972009,4972010,4972011,4972012,4972013,10463747,10465776,10463780,10463781,10465803,10465804,10465865,10465866,10463881,10463882,8563412,8917175,8917176,8917177,8917178,8917179,8917180,8563442,8917219,4972431,4972432,4972433,4972450,10466211,10466353,10466354,10466355,10466356,10466412,10462432,10462433,10462434,10462435,10462484,10462585,10462586,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,10520777,10520836,10520837,10520838,10520841,10520842,10520843,10520844,10520845,10520846,10520847,10520848,10520889,10521025,10521029,10420416,10421077,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'