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(7201646,8595077,7201960,7202077,7202078,4970673,10859702,10859703,10859704,10859705,10859706,10859707,10859708,10859709,10859710,10859711,10859712,10859713,10859714,10859715,10859716,10859717,10859718,10859719,10859720,10859721,10859722,10859723,10859724,10859725,10859726,10859727,10859728,10859729,10859730,10859731,10859732,10859733,10859734,10859735,10859736,10859737,10859738,10859739,10859740,10859741,10859742,10859743,10859744,10859745,10859746,10859747,10859748,10859749,10859750,10859751,10859752,10859753,7065950,7065951,7066172,7066249,7066267,10929240,10929241,8573244,7200624,8067906,8067907,8067908,8067909,7198750,10856043,10856044,10856045,10856046,10856047,10856048,10856049,10856050,10856051,10856052,10856053,10856054,10856055,10856056,10856057,10856058,10856059,10856060,10856061,10856062,10856063,10856064,10856065,10856066,10856067,10856068,10856069,10856070,10856071,10856072,7199053,10856331,10195979,10195980,10195981,10101474,10101523,8907459,8907460,7197748,7197749,7197750,7197751,7197752,7197753,7197754,7197755,7197756,7197757,7197758,7197759,7197760,7197761,7197762,7197763,7197764,7197765,7197766,7197767,7197768,7197769,7197770,7197771,7197772,7197773,7197774,7197775,7197776,7197777,7197778,7197840,7197841,7197842,7197843,7197844,7197845,7197846,7197847,7197848,7197849,7197850,7197851,7197852,7197853,7197854,7197855,7197856,7198103,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,8624777,8624778,8624779,8624780,10273058,10273059,8905736,3923427,3923428,3923429,3923430,8554375,10853746,10853809,10853842,10853893,10853905,8860337,8611360,8611361,8611362,8611363,8611364,8611365,8611366,8611367,8611368,8611369,8611370,8611371,8611372,8905222,8905223,8905224,8905225,8905226,8905227,8905228,8905229,8905230,8905231,8905232,8905233,8905234,8905235,8905236,8905237,10862984,10862985,10862986,8609570,8609571,8609572,8609573,10425566,10860680,10860682,10615447,10615448,10861594,3228944,3229044,8583479,10616955,9165544,10614202,10714117,10714118,10714146,8851161,8851182,8851204,8851208,8851213,8851222,8851283,8851299,8851306,8851316,8851328,8851341,8851348,8851366,8851378,8851386,8851389,8851392,8851402,8851432,8851467,8851492,8851510,8851538,8851550,8851552,8851563,8862497,8566487,8566547,8851906,7017820,7017821,7017822,7017823,7017824,7017825,7017826,10120369,7017827,7017828,7017829,7017830,7017831,7017832,7017833,7017834,7017835,7017836,7017837,7017838,7017839,7017840,7017841,7017842,7017843,7017844,7017845,7017846,7017847,7017848,7017849,7017850,7017851,7017852,7017853,7017854,7017855,7017856,7017857,7017858,7017859,7017860,7017861,7017862,7017863,7017864,7017865,7017866,7017867,7017868,7017869,7017870,7017871,7017872,7017873,7017874,7017875,7017876,7017877,7017878,7017879,7017880,7017881,7017882,7017883,7017884,7017885,7017886,7017887,7017888,7017889,7017890,7017891,7017892,7017893,7017894,7017895,7017896,7017897,7017898,7017899,7017900,7017901,7017902,7017903,7017904,7017905,7017906,7017907,7017908,7017909,7017910,7017911,7017912,7017913,10613017,10613320,10939394,10939395,10117617,10117618,10117619,10117620,10117621,10117622,10117623,10117624,10117625,10117626,10117627,10117628,10117629,10117630,10117631,10117632,10117633,10117634,10117635,10117636,10117637,10117638,10117639,10117640,10117641,10117642,10117643,8849314,8849338,8849351,8849353,8849377,8849431,10117876,8849530,9912026,9912027,9912028,9912029,9912030,9912031,9169825,9912032,9912033,9912034,9912035,9912036,9912037,9912038,9912039,10118036,8849780,8849887,8849905,8849906,8849913,8849927,8849928,8849929,8849931,8849956,8849972,8849998,8850024,9912702,8850412,8850413,8850414,8850415,8850416,8850417,8850418,8850419,9913008,9913009,8850651,8850674,8850678,8850683,8850697,8850710,8850731,8850737,8850743,8850748,8850755,8850758,8850760,8850773,8850782,8850794,8850801,8850802,8850804,8850814,8850823,8850841,8850858,8850859,8850884,8850896,9913302,8850928,8850931,8850938,8850959,8850965,8850972,8850985,8851009,8851017,8851026,8851033,8851040,8565718,8565719,8565720,8565721,8565722,8851061,8851077,8851118,10416550,10416551,10416552,6672895,6672896,6672897,6672898,6672899,6672900,6672901,6672902,6672903,6672904,6672905,6672906,6672907,6672908,6672909,8848702,8848703,8848714,9169161,8549975,8549976,8549977,8549978,8549979,8916779,8916780,8916781,8916782,8916783,8916784,8916785,8916786,8916787,8916788,8916789,8916790,8916791,10468121,10468122,10468123,10468124,10468125,10468126,10468127,10468128,10468129,10468130,10468131,10468132,10468133,10468134,10468135,10468136,10468137,10468138,10468139,10468140,10468141,10468142,10468143,10468144,10468145,10468146,10468147,10468148,10468149,10468150,10468151,10468152,10468153,10468154,10468155,10468156,10468157,10468158,10468159,10468160,10468161,10468162,10468163,10468164,10468165,10468166,10468167,10468168,10468169,10468170,10468171,10468172,10468173,10468174,976457,976458,9168029,9168030,9168031,9168032,9168033,9168034,9168035,9168036,9168037,9168038,9168039,9168040,9168041,9168042,9168043,9168044,9168045,9168046,9168047,9168048,9168049,9168050,9168051,9168052,9168053,9168054,9168055,9168056,9168057,9168058,9168059,9168060,9168061,9168062,9168063,9168064,10468838,10468839,10468840,10468841,10468842,10468843,10468844,10468845,10468846,10468847,10468848,10468849,10468850,10468851,10883714,10883715,10883716,10883717,10883718,10883719,10883720,10883721,10883722,10883723,10883724,10883725,10883726,10883727,10883728,10883729,10883730,10883731,10883732,10883733,10883734,10883735,10883736,10883737,10883738,10883739,10883740,10883741,10883742,10883743,10883744,10883745,10883746,10883747,10883748,10883749,10883750,10883751,10883752,10883753,10883754,10883755,10883756,10883757,10883758,10883759,10883760,10883761,10883762,10883763,10883764,10883765,10883766,10883767,10883768,10883769,10883770,10883771,10883772,10883773,10883774,10883775,10883776,10883777,10883778,10883779,10883780,10883781,10883782,10883783,10883784,10883785,10883786,10883787,10883788,10883789,10883790,10883791,10883792,10883793,10883794,10883795,10883796,10883797,10883798,10883799,10883800,10883801,10883802,10883803,10883804,10883805,10883806,10883807,10883808,10883809,10883810,10883811,10883812,10883813,10883814,10883815,10883816,10883817,10883818,10883819,10883820,10883821,10883822,10883823,10883824,10883825,10883826,10883827,10883828,10883829,10883830,10883831,10883832,10883833,10883834,10883835,10883836,10883837,10883946,10170086,10170107,10889836,10879916,10887728,10883273,10888457,10888478,10161819,10161861,10161862,10161863,10161864,10162221,10162222,10162223,10162237,10167577,10887051,10887052,10647426,10647427,10647443,10647444,10610706,10610707,10610708,10610709,10610710,10610711,10610712,10610713,10610714,10610715,10610716,10610717,10610718,10610719,10610720,10610721,10610722,10610723,10610724,10610725,10610726,10610727,10610728,10610729,10610730,10610731,10610732,10610733,10610734,10610735,10610736,10610737,10610738,10610739,10610740,10610741,10610742,10610743,10610744,10610745,10610746,10610747,10610748,10610749,10610750,10610751,10610752,10610753,10610754,10610755,10610756,10610757,10610758,10610759,10610760,10610761,10610762,10610763,10610764,10610765,10610766,10610767,10610768,10610769,10610770,10610771,10610772,10610773,10610774,10610775,10610776,10610777,10610778,10610779,10610780,10610781,10610782,10610783,10610784,10610785,10610786,10610787,10610788,10610789,10610790,10610791,10507667,10507758,10507971,10507972,10507973,10507974,10414130,10414131,10414132,10414133,10414134,10414135,10414136,10414137,10414138,10414139,10414140,10414141,10414142,10414143,10414144,10414145,10414146,10414147,10414148,10414149,10414150,10414151,10414152,10414153,10414154,10414155,10414156,10414157,10414158,10414159,10414160,10414161,10414162,10414163,10414164,10414165,10414166,10414167,10414168,10414169,10414170,10414171,10414172,10414173,10414174,10414175,10414176,10414177,10414178,10414179,10414180,10414181,10414182,10414183,10414184,10414185,10414186,10414187,10414188,10414189,10411192,10411193,10411194,10411195,10411196,10411197,10411198,10411199,10411200,10411201,10411202,10411203,10411204,10411205,10411206,10411207,10411208) 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'