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(10861228,10861232,10861242,10861256,10848645,10848691,10848696,10862122,10862124,10862125,10862126,10862127,10862128,10862129,10862130,8583439,10862355,10862357,10862359,10862361,10862476,10862479,10849496,10849498,10849500,10849501,10849511,10849512,10849515,10849520,10849522,10849524,10849525,10849528,10849531,10849533,10849535,10849536,10849540,10849542,10849543,10849545,10849588,10849846,10849868,10862927,10862928,10862953,10849985,8632395,10850059,10863075,8632498,8632499,10863170,10863172,10863174,10863176,10863213,8632578,10860628,10860635,10860642,10860699,10861079,10861080,10861081,10861082,10861105,10861106,10861165,10861166,10861190,10861191,10861196,10861197,10861204,10861205,10861213,10861214,7201213,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,10858311,10858316,10858321,10858326,10858331,10858336,7201319,7201320,7201399,7201400,8595068,8595069,8595070,10858826,10858827,10858850,10858851,7202049,8065802,8065803,10859134,10859135,10859136,10859137,10859140,10859141,7202118,10859161,10859168,10859169,7202234,10859279,8628812,8628813,5654575,10859657,10859658,10859659,7202768,8629515,7200454,7200455,10857580,10857584,10857586,10857587,10857589,10857590,10857591,10857592,8627127,8627128,8627129,8627135,8627136,8627137,8627138,8627144,8627145,8627146,8627147,8627148,8627157,8627158,8627159,8627160,8627161,8627170,8627171,8627172,8627173,8627174,8627182,8627183,8627184,8627185,8627186,8627190,8627191,8627192,8627193,8627194,8627200,8627201,8627202,8627203,8627204,8627208,8627209,8627210,10857864,10857865,10857868,10857869,10857872,10857873,10857876,10857877,10857880,7200917,10858213,10855306,10855309,10855310,10855311,10855312,10855313,10855314,10855315,10855316,10855317,10855318,10855319,10855320,10855321,10855322,10855323,10855324,10855325,10855326,10855327,10855328,10855329,10855330,10855331,8625163,11047588,7199391,7199410,7199543,7199546,11048363,11048370,7197417,7197418,8907458,7197838,7197839,8624257,7197900,7197908,8624439,8905112,8905113,8905279,10615437,10615438,10426214,10426215,8611335,8904915,8904916,10611099,10611354,10614740,10614741,8862534,8566648,9220284,10610306,10610307,10610308,10610309,10610310,10610311,10610312,10610313,10610314,10610315,10610316,10610317,10610318,10610319,10610320,10610321,10610322,10610323,10610324,10610325,10610326,10610327,10610328,10610329,10610330,10610331,10610332,10610333,10610334,10610335,10610336,10610337,10610338,10117558,10117559,10117560,10117561,10117562,10117563,9911598,9911599,9911600,8849358,8849359,8849360,9911937,9911938,9911939,9911940,9911941,9911942,9911943,9911944,9911945,9911946,9911947,9911948,9911949,9911950,9911951,9911952,9911953,9911954,9911955,9911956,9911957,9911958,9911959,9911960,9911961,9911962,9911963,9911964,9911965,9169851,8850054,8850061,8850062,8850063,8850064,8850065,8850170,8850171,8850172,7016020,7016021,7016022,7016023,7016024,7016025,7016026,7016027,7016028,7016029,7016030,7016031,7016032,7016033,7016034,7016035,7016036,7016037,7016038,7016039,7016040,7016041,7016042,7016043,7016044,7016045,7016046,7016047,7016048,7016049,7016050,7016051,7016052,7016053,7016054,7016055,7016056,7016057,7016058,7016059,7016060,7016061,7016062,7016063,7016064,7016065,7016066,7016067,7016068,7016069,7016070,7016071,7016072,7016073,7016074,7016075,7016076,7016077,7016078,7016079,7016080,7016081,7016082,7016083,7016084,7016085,7016086,7016087,7016088,7016089,7016090,7016091,7016092,7016093,7016094,7016095,7016096,7016097,7016098,7016099,7016100,7016101,7016102,7016103,7016104,7016105,7016106,7016107,7016108,7016109,7016110,7016111,7016112,7016113,7016114,7016115,7016116,7016117,7016118,7016119,7016120,7016121,7016122,7016123,7016124,7016125,7016126,7016127,7016128,7016129,7016130,7016131,7016132,7016133,7016134,7016135,7016136,7016137,7016138,7016139,7016140,7016141,7016142,7016143,7016144,7016145,7016146,7016147,7016148,7016149,7016150,7016151,7016152,7016153,7016154,7016155,7016156,7016157,7016158,7016159,7016160,7016161,7016162,7016163,9912944,10415223,10417285,10417286,10417287,10419293,10419294,10417310,10419364,6672702,6672703,6672704,6672705,6672706,6672707,6672708,6672709,10419437,10419438,10418489,10418493,10418495,10418496,10418497,10416497,10418503,10418504,10416536,10419569,10418582,10419592,10419602,10419603,10419607,10419610,10419614,10419622,10419623,10419627,10416628,10419632,10419633,10419637,10419641,10419642,10419646,10419647,10419651,10419653,10419659,10419661,10419662,9168742,9168743,10419666,9168744,10416720,10416722,10416724,10416726,10416760,10418785,10415839,9169094,10417025,10417026,10417027,10416027,10417028,10417029,10416029,10417030,10417031,10416031,10417032,10417033,10416033,10417034,10417035,10417043,10417044,10417048,10417049,10416114,10416117,7055444,7055454,10469128,10469129,10469388,8550053,10470061,976443,10468256,9167958,9167959,9167960,9168140,9168273,10628149,10884162,10884163,10884164,10890049,10890050,10890052,10890084,10890219,10890221,10890245,10885422,10883243,10883244,10883358,10883359,10883360,10883361,10883362,10883363,10883364,10883365,10883366,10883367,10883368,10883369,10883370,10883371,10883372,10883373,10883374,10883375,10883376,10883377,10883378,10883379,10883380,10883381,10883382,10883383,10883384,10883385,10883386,10883387,10883388,10883389,10883390,10883391,10883392,10883393,10883394,10883395,10883396,10883397,10883398,10161844,10161845,10161846,10876828,10647384,10647385,10647386,10647387,10424390,10424392,10424395,10424396,10424399,10424401,10424402,10424403,10424404,10424407,10424408,10424413,10424414,10424415,10424417,10424418,10424423,10424424,10424425,10424426,10424433,10424434,10421541,10508599,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10409350,10407369,10411382,10413383,10413384,10407448,10409451,10409462,10407493,10409501,10409529,10409570,10409572,10409574,10409576,10409578,10409580,10409583,10409585,10409587,10409589,10409591,10409592,10409594,10409596,10409598,10409619,10409621,10413633,10413634,10413635,10413636,10413639,10413640,10409642,10409650,10413651,10409652,10409653,10409660,10409681,10409688,10411760,10411765,10411768,10411771,10411772,10411778,10411784,10411785,10411791,10411792,10411798,10411800,10411803,10411804,10411809,10411810,10411812,10411814,10407819,10407820,10407821,10486535,10407915,10407916,10407926,10407927,10407929,10407931,10411955,10411959,10413989,10408058,10408062,10414087,10414088,10414089,10408157,10412203,10412206,10412210,10412212,10412213,10412215,10412216,10412217,10412218,10412428,10412447,10412448,10412451,10412452,10412455,10412456,10412459,10412460,10412463,10412464,10410489,10410490,10410491,10410492,10410493,10410494,10410495,10410496,10410497,10410498,10410499,10410500,10410501,10410502,10410503,10410504,10410505,10410506,10410507,10410508,10410509,10410510,10410511,10410512,10410513,10410514,10410515,10410516,10410517,10410518,10410519,10410520,10410521,10410522,10410523,10410524,10410525,10410526,10410527,10410528,10410529,10410530,10410531,10410532,10410533,10410534,10410535,10410536,10410537,10410538,10410539,10410540,10410541,10410542,10410543,10410544,10410545,10410546,10410547,10410548,10410549,10410550,10410551,10410552,10410553,10410554,10410555,10410556,10410557,10410558,10410559,10410560,10410561,10410562,10410563,10410564,10410565,10410566,10410567,10410568,10410569,10410570,10410571,10410572,10410573,10410574,10410575,10410576,10410577,10410578,10410579,10410580,10410581,10410582,10410583,10410584,10410585,10410586,10410587,10410588,10410589,10410590,10410591,10410592,10410593,10410594,10410595,10410596,10410597,10410598,10410599,10410600,10410601,10410602,10410603,10410604,10410605,10410606,10410607,10410608,10410609,10410610,10410611,10410612,10410613,10410614,10410615,10410616,10410617,10410618,10410619,10410620,10410621,10410622,10410623,10410624,10410625,10410626,10410627,10410628,10410629,10410630,10410631,10410632,10410633,10410634,10410635,10410636,10408645,10408646,10408652,10408653,10408658,10408659,10408660,10410682,10410683,10410684,10410685,10410772,10410773,10410774,10410775,10410776,10410777,10410779,10412783,10412845,10412850,10412855,10412860,10412865,10414870,10412870,10414877,10414885,10406906,10410914,10414936,10414942,10406958,10406963,10408964,10408965,10408973,10408978,10408980,10408988,10409025,10407080,10407082,10409084,10407084,10407085,10409088,10415091,10415092,10407093,10415093,10415094,10415095,10407095,10407096,10407103,10407107,10407109,10407111,10415111,10415112,10407113,10407116,10407119,10407121,10407122,10407123,10407127,10407129,10407132,10415170,10415172,10415180,10415182,10415197,10415200,10415210) 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'