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(10939654,8630858,8630859,4970678,4970679,10861797,10861798,10861799,10861800,10861801,10861802,10861803,10861804,10861805,10861806,10861807,10861808,10861809,10861810,10861811,10861812,10861813,10861814,10861815,10861816,10861817,10861818,10861819,10861820,10861821,10861822,10861824,10861825,10861826,10861828,10861840,10861841,3228988,3228989,3229016,3229017,3229018,3229024,3229045,3229058,3229061,3229062,3229063,3229065,3229066,3229067,3229068,7065967,8631640,8631641,8631642,8631643,8583476,8583477,7066011,7066012,7066013,8631717,8631718,8631719,8631720,8631721,8631722,8631723,10862365,8631724,10862366,8631725,10862367,10862368,8631726,8631727,8631728,8631729,8631875,9215980,10849724,10849725,3229967,10850058,10860254,10860255,10929240,10860256,10929241,10939174,10939175,10939176,11001153,10939368,10939405,10939408,10939416,10939442,10858120,7201206,7201207,7201208,7201209,7201210,7201212,7201224,7201243,7201244,7201245,7201246,8627697,7201498,7201499,7201500,7201501,7201502,3238776,8595016,8595017,8595018,8595019,8595020,7201623,8595021,8595022,8595023,8595024,8595025,8595026,8595027,8595028,8595029,8595030,7201636,7201637,8595197,8595250,10858938,10859027,10859028,10859029,10859030,10859031,10859032,10859033,10859034,10859035,10859036,10859037,10859038,10859039,10859040,10859041,10859042,10859043,8065826,10859044,10859045,8065827,10859046,10859047,10859048,7202048,7202051,10859213,10859214,10859215,10859216,10859217,10859218,10859219,10859220,10859221,10859222,10859223,10859224,10859225,10859226,10859227,10859228,10859229,10859230,10859231,10859232,10859233,10859234,10859235,10859236,10859237,10859238,10859239,10859240,10859241,10859242,10859243,10859244,10859245,10859246,10859247,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,10859557,10859569,10859598,10859600,10859603,10859604,7202677,10859759,10859760,10859761,10859762,10859763,9794573,3227089,3227090,10860047,3227194,3237340,8910056,8910057,8910058,8910059,8910060,8910061,8910062,8910063,8910064,8910065,8910066,8910067,8910068,8910069,8910070,8910071,8910072,8910073,8910074,7200507,7200509,10857571,10857572,10857573,10857574,10857575,10857576,10857577,8626970,8626971,8626972,8626973,8626974,8626975,8626985,8626995,7200627,7200628,7200629,7200630,7200631,7200632,7200634,8627069,8627070,8627122,8910581,7200789,7200790,7200791,7200917,7200930,7200933,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,8624777,8624778,8624779,8624780,8624781,8624782,8624783,8624784,8624785,8625114,8625115,8625116,8625117,8625118,8625119,8625120,8625121,8625122,8625123,8625124,8625125,8625126,8625128,8625130,8625131,8625132,8625133,10856306,10856307,10856308,10856309,10856310,10856311,10856312,10856313,10856314,10856315,10856316,10856317,10856318,10856319,10856320,10856321,10856322,10856323,10856324,10856325,10856326,10856327,10856328,10856329,10856330,10856331,10856332,10856333,10856334,10856335,10856336,10856337,10856338,10856339,10856340,10856341,10856342,10856343,10856344,10856345,10856346,7199391,7199410,10856619,10856696,8860364,8860365,8860366,10856951,10856952,10856955,10856967,10856969,10856972,10856974,10856975,10856976,7196129,7196130,3923458,3923468,3923510,10618267,10618271,10618272,10618293,10618305,10618306,10618307,10618325,11006875,10853644,10854100,10854101,10854102,10838796,10838797,10619237,10619238,3234982,7197840,7197841,7197842,7197843,7197844,7197845,7197846,7197847,7197848,7197849,7197850,7197851,7197852,7197853,7197854,7197855,7197856,7197857,7197858,8624440,8624442,10617209,8905289,8905339,8905431,8905432,8905433,8905434,8905435,10615088,10615092,8609791,10615267,10615314,10615315,10615346,10615347,10615474,10615475,10615481,10615818,10616013,10616092,8540598,10616462,10616471,10616472,10616473,10616474,10616485,10616522,10616548,10616697,10616731,10616732,10616804,10616840,10616841,7155267,7155279,7155280,7155281,7155282,10616955,10611106,10611107,10611108,10611109,10611110,10611111,10611112,10611113,10611114,10611115,10611116,10611117,10611118,10611119,10611120,10611121,10611122,10611123,10611146,10611147,10611148,10611149,10611150,10611176,10611220,10614570,10614648,10614663,10614695,10611803,10611804,10611805,10611806,10611807,10611808,10611809,10611810,10614849,10614857,10612029,10612228,10612248,10612259,10612322,10612323,10612324,10612325,10612326,10609343,8851577,8851578,8851579,8851580,8851581,10609564,10609565,10609566,10609567,10609568,10609569,8851803,8851804,8851805,8851806,8851807,8851808,8851809,8851810,10609719,10609723,10609749,8862639,10609838,8862708,10612952,10612958,10609990,8852372,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,10613844,10610878,10117557,9169461,9911673,9911674,10117713,10117791,10117827,10117828,10117931,10117932,10117948,10117949,10117950,10117951,10117952,10117953,10117954,10117955,10117956,10117957,10117958,10117959,10117960,10117961,10117962,10117963,10117964,10117965,10117966,9912037,9169843,9912086,9912087,9912107,9912110,9912111,10118129,10118256,9912309,9912310,9912311,9912312,9912313,9912314,9912315,9912316,9912317,9912318,9912319,10118309,9912320,10118310,9912321,10118311,9912322,9912323,9912324,9912325,9912326,9912327,9912328,9912329,10118332,10118353,10118355,10118359,10118419,10118577,9913320,9913321,10419271,9168395,9168461,6672689,10419407,10419408,10116694,9168502,9168503,9168504,9168505,10116719,9168532,10417506,10417507,10417508,10417509,10417510,10417511,10417512,10417513,10417514,10417515,10417516,10417517,10417518,10417519,10417520,10417521,10417523,10417524,10417525,10116800,10417526,10116801,10417527,10417528,10116805,10116806,10116813,10116814,10116890,10116891,10116892,10116893,10116894,10116896,10415646,10415647,10415648,10415649,10415650,10415651,10415652,10415653,10415654,10415655,10415656,10415657,10415658,10415659,10415660,10415661,10415662,10415663,10415664,10415665,10415666,10415667,10415669,10415670,10415671,10415673,10415683,10415684,9169021,10416037,10416038,10416039,10416040,10416041,6673342,6673343,6673344,6673345,6673346,10117421,10117422,10117488,10117489,10117490,10463001,10463002,8550016,8550034,10467524,10469637,10469638,10115634,10115643,10115644,976457,10468257,10468258,976488,10468510,10468511,10468512,10468513,10468514,10468515,10468516,10468517,9167962,9168058,9168070,9168142,9168143,9168144,9168145,9168146,10470725,9168234,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,10884165,10884166,10884167,10884168,10884169,10884170,10884171,10884172,10884173,10884174,10884175,10884176,10884177,10884178,10884181,10889234,10889253,10884409,10884410,10884411,10884414,10884422,10884614,10884615,10884616,10884617,10884618,10884716,10884720,10884721,10884723,10884725,10884726,10884926,10884927,10905113,10885117,10885118,10885119,10885120,10885121,10885122,10885123,10885124,10885125,10885126,10885127,10885128,10885129,10885130,10885131,10885361,10885454,10885455,10885456,10885457,10885458,10885459,10882541,10882542,10882543,10887548,10887560,10888010,10883300,10885725,10630287,10161983,10161984,10162176,10887066,10887067,10887188,10626720,10163317,10647443,10647444,10647510,10647648,10604035,10604036,10508478,10507589,10507810,10508030,10411385,10411386,10411387,10411388,10411389,10411390,10411391,10411392,10411393,10411394,10411395,10413453,10407492,10413530,10413531,10413532,10413533,10413534,10413535,10413536,10413537,10413538,10413539,10413540,10413541,10413542,10413543,10413544,10413545,10413546,10413547,10413548,10413549,10409667,10413684,10413685,10413686,10413687,10413688,10413689,10413690,10413691,10413692,10413693,10413694,10413695,10413696,10413697,10413698,10413699,10413700,10413701,10413702,10413703,10413704,10413705,10413706,10413707,10411835,10411836,10411838,10409899,10413996,10413998,10414007,10477679,10414034,10414036,10414039,10414040,10414195,10412199,10412200,10412201,10412202,10414439,10414677,10408990) 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'