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(4970695,4970697,7065981,7066010,7066172,7074585,7074741,7074918,7074958,8067904,8067916,8067917,8067928,8067929,8067930,8067934,8067938,10939101,10939102,10939402,10939404,10939405,10939425,10939433,7072225,8065838,7065915,7071807,11048305,11048307,10958376,10958387,10958388,10958389,10958390,10623064,10623065,10618180,10618277,10618288,10967948,10618290,10618305,10618306,10618309,10618310,10618313,10618314,10618315,8070775,10619898,10619899,10616974,10621987,10617044,10617078,10617144,10617147,10617214,10617245,10617279,10617286,10617312,10617313,10617324,10617326,10954022,10954024,10617428,10617429,10622429,10617430,10617431,10622431,10617432,10617433,10617434,10617435,10617489,10954199,10614971,10614997,10615001,10615024,10615027,10615028,10615029,10615030,10615031,10615032,10615033,10615034,10615035,10620073,10620074,10615140,10615152,10615222,10615223,10615224,10615232,10615234,10620235,10620236,10620238,10615239,10615255,10615256,10615257,10615263,10615287,10615290,10615291,10615325,10615326,10615334,10615349,10615350,10615389,10615395,10615396,10615424,10615473,10615530,10615571,10615573,10615609,10615646,10615647,10615705,10615717,10615719,10615725,10615726,10615728,10615730,10615731,10615736,10615741,10615742,10615743,10615744,10615745,10615768,10615774,10615788,10615813,10615827,10615828,10615829,10615830,10615831,10615832,10615834,10615837,10615840,10615841,10615845,10615846,10615847,10615848,10615849,10615850,10615853,10615857,10615939,10616016,10616044,10616045,10616060,10616194,10616333,10616335,10616336,10616337,10616338,10616339,10616340,10616346,10616349,10616352,10616354,10616355,10616358,10616359,10616360,10616366,10616367,10616368,10616370,10616371,10616459,10616461,10616504,10616569,10616571,10616573,10992335,10992336,10616685,10616785,10616796,10616798,10616800,10616801,10616804,10616826,10616847,10616888,10616913,10614048,9165413,10614095,9165459,9165460,10611126,7059644,10614148,10614160,10611161,9165541,9165548,9165549,10611236,10614236,10614238,10611239,10611247,10611293,10614296,10614316,10611332,10611333,10611343,10611367,10614378,10614382,10614400,10614432,10614465,10614467,10614469,10614470,10614476,10614486,10611489,10614489,10614490,10614491,10614492,10611497,10614518,10611521,10611523,10611524,10611526,10611529,10614530,10611531,10611533,10611534,10611535,10611539,10611540,10611541,10611544,10611545,10611548,10611551,10611555,10614555,10611557,10611558,10611559,10559710,10611562,10611563,10611565,10611566,10611568,10611578,10614588,10611614,10614634,10614637,10614638,10614647,10614663,10614664,10611677,10611698,9166051,10611759,10611760,10611764,10611785,10611802,10611812,10611819,10614857,10611898,10611899,10611900,10611901,10611902,10611903,10611904,10611905,9166251,10611953,7057465,10608963,10611967,10611972,10611976,10611978,10612000,10612010,10609018,10609033,10612051,10612086,10609087,10609092,10612126,10612133,10609153,10609167,10612185,10612186,10612187,10609188,10612188,10612189,10612227,10609247,10609260,10612263,10612264,10612265,10612280,10609287,10609303,10612320,10612321,10609348,10609350,10609351,10609358,10609362,10609363,10609367,10609376,10609379,10612383,10609385,10609388,10609392,10612414,10612434,10609449,10612466,10612467,10612468,10612469,10612470,10612471,10612472,10612473,10612474,10612483,10609491,10612494,10612495,10612496,10612497,10612498,10612516,10612518,10609519,10609520,10609521,10609522,10609523,10612523,10609524,10612524,10612528,10612532,10609537,10612547,10612551,10612553,10612558,10612565,10612567,10609568,10609569,10612571,10612580,10612581,10612582,10612583,10612584,10612595,10612596,10612597,10609600,10612600,10609603,10612618,10612619,10612624,10612625,10612639,10612640,10612641,10612642,10612643,10612644,10612655,10612661,10612662,10609663,10612663,10612664,10612665,10609667,10609675,10609677,10609678,10612679,10612680,10612681,10612682,7058185,10612699,10612700,10612704,10612705,10612706,10609707,10612707,10612708,10612709,10612716,10612717,10612755,10612761,10612762,10612770,10612798,10612799,10612804,10612809,10609816,10612820,10612826,10612827,10612828,10612829,10612830,10612831,10609835,10612839,10612844,10612849,10612853,10612860,10612861,10612862,10612863,10612866,10612868,10612869,10612870,10612871,10612872,10612873,10612881,10612886,10612893,10612894,10612897,10612898,10612901,10612902,10612903,10612909,10612915,10609934,10609978,10609980,10609981,10609982,10612990,10612993,10612994,10610022,10610025,10610026,10610042,10610068,10613071,10613079,10613080,10613156,10613159,10613166,10613168,10613189,10613193,10613194,10613195,10613202,10613203,10613242,10613243,10613244,10613245,10613265,10613266,10613292,10610296,10613342,10610348,10610349,10613372,10613405,10610408,10613438,10610477,7058980,10610480,10610481,7059020,10613540,10613541,10613543,10613544,10613546,10613547,10613553,10613554,10610564,7059074,10613603,10613645,10613664,10610674,10610678,10610708,10613710,10610710,10613733,10613735,10610764,10610779,10610793,10610794,10613801,10610862,10610871,10610920,7055523,9169399,9169447,9169450,9169464,9169467,7055654,9169540,9169568,9169572,9169573,9161893,10514037,10514038,2809283,2809284,10418226,10419228,10418229,10419229,10419230,10419232,10419233,10418234,10419234,10416235,10418239,10418245,10418248,10418259,10418260,10418261,10418262,9160341,10418263,10418264,9160343,10418265,10418266,10418267,10418268,9160348,10417288,10416301,10418316,10418317,10418318,10418319,10418320,10418321,10416322,10418322,10418323,10416324,10418324,10418325,10418326,10418327,10416328,10418328,10418329,10418330,10418331,10415344,10416347,10417359,10416360,10419365,10415371,10417371,10418372,10418373,10418374,10418375,10416376,10418376,10418377,10416379,10419384,10416388,10416389,10416390,10416391,10416392,10416393,10416394,10416395,10415395,10416396,10416397,10416398,10416399,10416400,10418400,10416401,10418401,10416402,10416403,10416404,10418404,10416405,10416406,10416407,10415407,10419407,10419412,10419429,10417466,10416468,10416470,10416479,10418488,10416495,10416505,10416513,10419515,10416519,10416525,10416526,10417529,10419532,10419533,10416534,10419534,10416539,10415543,10416544,10415547,10415548,10417550,10415552,10415553,10418553,10416553,10416554,10418555,10416555,10418556,10416556,10418557,10416557,10416558,10416559,10416560,10416561,10416562,10416563,10416564,10419568,10418569,10419570,10418570,10418571,10416572,10416577,10418578,10416578,10418579,10416579,10416580,10418581,10415583,10415584,10415585,10415586,10415612,10415615,10415634,10417634,10417638,10417639,10417640,10415657,10416663,10416664,10416665,10416666,10416667,10416668,10416669,10416670,10416671,10416672,10418676,10418681,10417759,10417760,10417761,10417762,10417763,10417764,10417770,10416776,10416777,10416778,10417786,10415790,10419805,10416831,10416832,10416833,10419859,10419860,10419861,10416871,10416872,10416879,10416880,10416901,10416902,10416903,10416920,10416921,10416931,10416959,10417960,10416960,10416961,10416962,10418963,10416963,10418964,10416971,10416973,10418976,10416983,10416984,10416985,10417987,10418989,10417014,10417015,10417019,10417020,10417021,10416030,10417035,10419037,10419038,10419040,10418040,10419041,10419042,10419043,10419044,10417046,10418055,10417055,10419060,10417060,10417065,10417066,10417070,10419072,10419074,10419076,10419077,10419078,10417078,10419083,10419087,10419088,10418099,10419105,10419106,10419107,10418120,10418141,10418144,10419145,10418145,10418163,10418164,10418165,10418166,10418167,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10419194,10419195,10419198,10468915,8864959,10471102,10471128,10469247,10467513,10467518,10467522,10467526,10467541,10469548,10467615,10469663,10469911,10469912,10469913,10469914,10469915,10469916,10469917,10469943,10469944,10469945,10469950,10470093,10470112,10470165,10470172,10470219,10470220,10470221,10470222,10468268,10468269,10470273,10470290,10468297,10470328,10470362,10468389,10468390,10470401,10470405,10468405,10470406,10470407,10468449,10468451,10470458,10470459,10470460,10470461,10470462,10470480,10468491,10468492,10468493,10468494,10468495,10468496,10468497,10470519,10470526,10470527,10470528,10470529,10470534,10470579,10470603,10470621,10470623,10470626,10470630,10470644,10470645,10470648,10470649,10470650,10470651,10470671,10468692,10468693,10468733,10468746,10468756,10468757,10468762,10468840,10468847,10468850,10154576,10628157,10632012,10627115,10627303,10627312,10153861,10153862,10627776,10626299,10626876,10626954,10521186,10521187,10521188,10521871,10521872,10521873,10522597,10421495,10477405,10477411,10477413,10477415,10477418,10477420,10477421,10477423,10477425,10477427,10477428,10477432,10477436,10477437,10477438,10477493,10477497,10477499,10477502,10477504,10477505,10477541,10477542,10477543,10477546,10477548,10477549,10476457,10476458,10476459,10476460,10476461,10476462,10476463,10476464,10472508,10472510) 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'