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(8838436,8838445,7068190,4970914,4970953,11015521,7074046,10976760,10976761,7074090,11028811,7074128,11028812,11028813,11028814,11028815,11028816,7074132,11028817,11028818,11028819,11028820,7074136,11028821,11028822,11028823,8067499,7074585,11003422,8067718,7074754,10437623,7074888,11039795,10961815,8068054,8068055,8068056,11000858,11039869,8068116,11000915,11039923,11039924,11039925,11039943,11039944,11039945,11039956,11000980,11000981,11039986,11040025,8068232,8068233,11040026,11040027,11040028,11040029,11040030,11040031,11040032,11040033,11040034,10962165,11040216,11001279,8068622,11037669,11037670,11037671,11037672,11037779,11037785,11037836,11037840,11037926,7072257,10972965,10972975,10972976,7072304,11038041,11038094,11038095,11038096,11038097,7072432,7072433,7072848,10932212,7072872,11038749,11038775,8836606,8836608,8066285,8066323,8066324,8066349,8066350,8066351,11039072,11039073,11039113,11039182,11039255,11000286,11000287,11026310,11026311,11026312,11026313,11026314,11026315,11026316,11026317,11026318,11026319,11026320,11026321,11026322,11026323,11026324,11026325,11026326,11026327,11026328,11026329,8066623,11026330,11026331,11039348,10974383,10974384,10974448,10974449,10974450,8066744,8066745,8066746,8066747,8066748,8066749,11039524,10961577,11049107,10942832,7071211,10942876,10942885,10942886,10942908,11024100,10943057,10943058,10943059,11049337,10943070,11049349,10943075,10943099,10943102,10943104,10972183,10972184,10972185,7071737,10972445,7071794,11037527,11037580,11037585,11034630,11034663,10969721,10969738,11034741,11034742,11034743,11034804,10940850,10940851,11034916,10969947,7069266,7069469,7069471,7069472,7069478,11022296,11022297,11022298,11022299,11022300,11022301,11022302,11022303,10970350,3656249,3656250,3656251,3656252,11035383,10996532,10970538,10970539,10970540,3656456,10970590,10970591,10970592,11022711,11022712,11022713,11022714,11022832,11022833,11022834,11022835,11023004,11023005,11023006,11036009,11036010,11036011,11036012,10942072,10971171,11023211,11023212,10942152,10942153,11023374,11023375,11023376,11023395,10942385,10942386,8073504,10958470,10997495,10923513,10918580,11032828,11032829,10923703,10918716,10923929,10923935,10924022,10919128,10919129,10919146,10924263,10919423,10919424,10919425,10919426,10919427,10919428,10919429,10919430,10919431,11033858,11033859,11033860,11033861,11033862,11033863,11033864,11033865,11033866,11033867,11033868,10968882,10968885,10968886,10924750,10924758,10924759,10924762,10924768,10924769,10919773,10919774,10919775,10919776,10919777,10919778,10919779,10919780,10919781,10919782,10919789,10919790,10924848,10919895,10919896,10919897,11034063,11034064,11034065,11034066,11034067,11034068,10919937,11034127,11034128,11034129,11021254,11021255,11021256,11021257,11021258,11021259,11021260,11021261,11021262,11021263,11021264,11021265,11021266,11021267,11021268,11021269,11021270,11021271,11021272,11021273,11021274,11021275,11021276,11021277,11021278,11021279,10925147,10925168,10925169,11034322,11034323,10925201,10925202,10925203,10925351,10925352,10925353,10925354,10925355,10925356,10925357,10925358,10925359,10925360,10925361,10925362,10925363,10925364,10925365,10925366,11034528,11034529,11034530,11034531,11034532,11034533,10969588,10969590,10920451,10922696,11031867,10979956,10979957,10979958,10979959,10979960,10922850,10922937,10922981,10922982,10922983,10923076,10923077,11032239,11032240,11032241,11032242,11032243,10918097,10923139,10923141,10923142,10918244,10918245,10918246,10918247,10918248,10918445,10918446,8570140,10615200,10920833,10920834,10920837,10920838,10920839,10920840,10920841,10920842,11003993,10925871,10925872,10620368,10920902,8570350,8570358,10920935,10920938,10920939,10920940,10920941,10920942,10920943,10920944,10921026,10921027,10921028,10921165,10921166,10921167,10921168,10921169,10921170,10921171,10921223,10921224,10921225,10921226,10921227,10921228,10921229,10921230,10921231,10921232,10978511,10978512,10978513,10978514,10978515,10978516,10921369,10921370,10921372,10921373,10921374,10921375,10921376,10921377,11030538,11030539,11030540,11030541,11030542,11030543,11030544,11030545,11030546,11030547,11030548,11030549,11030550,11030551,11030552,11030553,10921451,10921518,10921555,10978797,10978798,10978799,10978800,10978802,11030806,11030807,11030808,11030809,10978994,10978995,11031090,11031091,11031092,11031093,11031094,11031095,11031096,11031097,11031098,11031099,11005107,10616460,10616461,10992305,11031392,10621735,11031393,11031394,9165725,9205996,10611661,9206095,9206099,9206156,9206178,9206179,9206180,9206181,9206264,9203343,9195410,10557242,9203434,9203435,9203436,10557261,7057767,9203624,9203629,9203630,9203631,9203632,9203633,9203634,9203635,9203636,9203637,10563456,10563457,9171687,9171693,10557506,9203735,9203736,9195851,9203916,9203917,10563788,7058209,7058210,9188091,10563910,10563911,10563912,10563913,10563914,9188101,10563915,10563916,10563917,10563918,10563919,10563920,10563921,10563922,10564123,10610018,10610019,7058686,10564386,10564387,10564388,10564389,10564390,10564391,10564392,10564393,10564394,10564395,10564396,10564397,10564398,10564399,10564400,10564401,10564402,10564403,10564404,10564405,10564406,10564407,10564408,10564409,10564410,10564411,10564412,10564413,7058852,8863368,7059013,8863369,7059014,7059015,7059016,8863398,7059058,9196923,7059184,7059322,7059331,7059332,7059361,10610880,7059413,9177326,10555203,9193635,9193636,10513526,10513527,4974583,10513545,10513546,10513547,7056260,10555917,9178256,9194264,9194270,4975252,9178431,7056688,9178539,9194687,7057123,10512800,10512801,10512804,10512805,10512806,10512807,10556978,7057410,7057411,9171281,9171294,10416241,9192671,9192686,9192703,9192734,9192735,9176793,9192798,9192841,9192870,9192871,10417795,9192890,9192891,9192923,9192924,9192925,9192926,9192927,9192928,9192977,9192978,9192979,9192980,9192981,9193033,9193052,9193053,9193075,9193076,9193077,9193078,9193097,9193098,9177204,9177205,9177206,10417157,8864831,10467106,10467122,10467123,10467124,10467127,10467134,10467135,10467136,10467143,10467144,10467145,9174863,9174864,9174865,9174866,9174867,6666930,6666931,4972084,4972085,4972086,4972087,4972088,9183303,9183304,9183305,8917227,8917793,10174511,10628078,10164733,10179917,10180006,10175060,10180341,10180342,10180343,10180363,10180364,10180365,10180366,10180367,10180368,10180369,10180370,10180772,10180773,10180790,10180791,10180792,10180793,10180794,10180795,10180796,10180797,10180798,10180799,10180800,10180801,10180802,10171015,10629554,10629555,10181077,10181078,10629556,10181095,10181096,10181097,10181098,10181099,10181100,10166137,10181355,10181365,10181366,10181367,10181368,10626977,10173992,10173993,10173994,10174015,10174058,10627695,10627696,10627697,10627698,10627699,10627700,10627701,10627702,10169327,10169328,10164331,10166643,10630662,10162255,10167321,10167322,10630802,10630803,10630804,10630805,10172379,10172380,10630875,10167473,10167474,10631015,10631016,10631017,10631035,10631036,10631037,10162841,10167918,10168005,10626532,10168076,10168364,10168477,10577159,10577161,10577162,10577163,10577164,10586282,10571600,10577717,10577718,10580722,10577730,10577731,10577732,10577733,10577734,10577798,10574834,10574835,10580963,10580969,10578022,10578023,10575066,10575067,10575068,10575069,10575070,10578126,10581127,10578127,10572136,10581162,10578167,10581206,10581207,10581208,10581209,10581210,10581211,10581259,10581260,10581261,10581262,10581263,10581264,10581265,10578276,10578277,10575334,10575335,10575336,10575337,10575338,10575339,10575340,10575341,10575342,10575343,10575344,10575345,10575346,10578362,10578363,10578364,10578365,10578366,10578367,10578482,10578483,10578484,10578485,10578486,10578487,10575510,10578512,10578513,10578514,10578515,10578537,10578580,10581621,10581622,10581645,10581654,10581675,10581676,10581677,10581678,10581679,10581680,10581681,10581682,10581683,10578683,10581684,10578684,10581685,10581686,10581718,10581719,10581720,10581721,10581722,10581723,10575730,10575731,10581737,10581738,10581739,10581740,10581747,10581758,10581759,10581769,10575942,10576096,10576097,10576098,10576099,10579546,10582549,10582550,10582551,10579577,10579708,10579709,10576898,10576899,10576900,10576901,10576904,10576905,10576906,10576907,10576908,10576909,10576910,10576911,10576912,10576913,10576914,10576915,10576916,10577053,10577054,10577055,10577056,10577066,10577067,10577068,10577069,10577070,10577071,10577072,10577073,10577074,10577075,10577076,10577077,10577078,10577079,10577080,10577081,10577082,10577083,10523124,10523125,10523126,10523265,10523266,10525315,10529663,10528737,10528739,10528762,10528847,10422984,10480999,10479232,10479553,10479554,10479767,10481788,10479869,10479870,10479871,10479872,10478170,10480259,10480260,10478272,10478553,10478569,10478724,10478725) 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'