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(8630627,8630628,8630629,8630630,8630631,8630633,8630635,8630636,8630642,8630786,8630789,10861437,10861438,8630810,8630811,8630849,8630854,8630855,8630856,8630866,8630867,8630868,8630872,8630873,8630890,8630993,8631003,10861714,8631119,8631120,8631121,3228956,3228957,8631188,3229008,3229077,3229106,3229107,3229108,3229110,8631611,8631622,8631623,8631624,8631625,8631635,8583488,10849341,8631856,8631857,8631859,10862799,3230230,8632498,8632518,10860242,8067931,10860385,10860386,10860390,8573309,8573310,8573311,8573312,10860442,10860453,10860490,10860491,10860536,8629930,10860582,10860583,10860584,10860585,10860586,10860587,10860588,10860589,10860590,10860591,10860592,10860594,10860595,10860596,10860597,10860599,8630172,8630173,10447544,8630420,7067801,10866240,10866241,8594636,7201253,7201309,10866362,7201354,7201368,8627822,10866536,10866537,10866538,10866539,10866540,10866542,10866543,10866549,10866610,10866611,10866612,10866613,10866620,10866621,10866622,10866623,10866624,10866625,10866626,10866627,10866628,10866629,10866630,10866631,10866632,10866633,10866634,10866635,10866636,10866642,7201624,8595055,8595056,8595092,8595093,8595101,10858752,8595109,10858756,8595112,8595113,10858759,8595114,8595115,8628118,8628119,8595116,8595117,8628229,8628230,7201844,8628265,10960336,10858945,10858946,7201976,10960474,10859192,10859193,10859194,10859195,10859258,8628626,8628627,8628641,8628654,8628662,8628665,8628666,8628667,8628668,8628669,8628678,8628680,8628699,7202312,7202313,8628713,7202314,7202315,7202316,7202317,7202318,8628718,7202319,8628719,7202320,8628720,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,5654537,5654555,10859522,10859523,10859524,10859526,10859527,10859528,10859531,5654577,5654578,5654579,5654580,5654581,5654588,5654627,5654651,7202672,7202689,7202690,8629340,8629341,3227207,10857503,10857504,7200506,10857555,10857556,10857557,10857559,10857560,10857561,10857562,10857563,10857564,8626926,10958987,10958988,10958989,10857648,10857649,7200607,10857650,7200608,10857651,10857652,10857653,10857654,10857655,10857656,8910445,8910446,8910447,8910448,8627085,7200753,8910599,8627242,8627251,8627288,8627293,7200901,7200904,10865954,10865955,10865956,10865957,7201013,7201080,8627530,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,10866197,10866198,8627567,8627568,8627569,8627570,8627571,8627572,8627573,10100083,8624611,7198382,7198391,7198394,7198679,7198684,7198688,7198694,7198703,7198712,7198713,7198723,7198725,7198730,7198731,7198736,7198742,7198743,7198744,7198745,7198751,8625157,8625158,7198759,7198764,7198765,7198766,8625267,8625268,8625364,8625368,8625371,10864025,7199061,7199063,10856184,10856187,10856188,10856189,7199449,10864501,10864502,10864505,10864507,10864509,10864511,10864513,10864515,10864517,10864519,10864522,7199480,10864525,10864527,10864529,10864531,10864533,10864535,10864537,10864538,10864540,10864542,10864544,10864546,10864548,10864550,10864551,10864553,10864556,10864558,10864560,10864562,10864564,10864566,10864568,10864570,10864572,10864574,10864576,10864578,10864580,10864582,10864584,10864586,10864589,10864591,10864593,10864595,10864597,10864599,10864601,10864603,10864605,10864607,10864610,7199569,10864613,7199571,10864619,10864622,10864624,10864626,10864629,10864631,10101492,10101493,7200030,10857164,7200123,7200124,7200125,7200126,8554296,10838801,3234729,7197582,7197940,7197941,7198108,10852371,8905156,10617171,8541668,10622258,10622264,10622265,10622266,10622267,10622268,10617343,10617347,10617348,10617354,10617355,10622360,10617372,10617378,10617383,10622405,10622408,10617425,10622431,10617445,10622447,10617448,10954113,10954114,10617457,10617458,10622514,10622516,10622523,8542165,8905822,10620195,10620196,10620197,10620198,10620199,10620201,10620202,8632830,8632831,8632832,8632833,10425552,8632834,8632835,8632836,8632837,10615229,10620303,10615339,10615340,10615341,10615342,10615389,8633171,8633265,8633282,10615889,10615890,10426339,8633975,8633976,8633978,8633979,8633984,8634177,8634182,8634183,10616644,8904798,10427106,10427112,10610994,10714020,10714023,10614260,10614261,10614262,10614263,10614264,6669823,6669828,10614376,10611428,10611476,10611477,10614496,10614499,10614565,10611778,10611856,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,8549450,10611969,10611970,10611983,10611995,10611996,10611997,9913611,9913612,10612086,10612104,10612105,10612191,10612192,10612194,10612201,10609287,8851657,8851658,8851659,8851660,7058247,7058248,7058249,7058250,8566588,8862672,8851990,10612909,10612916,10612935,10612936,10612937,10612938,10612939,10612941,10612942,10612943,8567072,8567073,10613235,10613337,10613434,10613435,8852770,8852772,8852773,10613760,10610917,10610918,10610919,10610954,10117516,10117517,10117529,10117664,6673692,8849316,8849317,8849318,9169520,6673738,9169946,10118171,9912208,9912209,6674248,6674249,6674332,10118342,9912378,9912386,10118451,10118452,8551565,9912521,9912522,9912612,10118676,10118677,9912966,9913333,9913355,9913357,9913359,9913360,9913361,9913369,9160361,9168366,9168367,10419306,10419307,10419349,10419350,10416362,10416363,10419370,10415373,10415374,10417424,10419493,10419494,10419495,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,6672829,10415585,6672871,6672872,6672885,6672887,6672903,6673017,6673019,6673020,6673021,6673022,9168817,6673023,6673024,6673025,6673035,6673036,6673051,10417811,10417812,10417814,10417816,10417818,10417820,10417822,8848725,10417824,8848728,10417826,8848729,10417828,10417830,10417832,10417834,10417837,10417839,10417841,10417843,8848746,10417845,10417847,10417849,10417850,9168930,10417852,9168931,8848756,9168932,10417854,10417856,8848761,10417858,8848763,10417860,10417862,8848766,10417864,10417866,10417868,8848773,10417870,10417872,10417874,10417876,8848781,10417878,8848782,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,9168995,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10469289,8549957,8550018,8550075,10469502,10469949,10469950,976355,976356,976357,976358,976360,976361,976362,976367,10468239,976476,976493,976495,976583,976584,976585,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10470721,10470722,8848005,8848020,8848032,8848038,8848041,8848042,8848051,8848093,8848100,8848101,8848102,8848103,10883593,10883625,10908626,10883626,10883629,10883631,10893804,10884079,10889451,10884697,10884698,10889707,10884738,10889997,10890103,10890119,10890133,10890135,10890136,10890148,10890149,10880306,10880307,10885465,10885468,10885469,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10887545,10887724,10627321,10882916,10883042,10888067,10883140,10883142,10883143,10883325,10883326,10888381,10888382,10883392,10883398,10883406,10885956,10881491,10887096,10887097,10887132,10887250,10882353,10882354,10887463,10887465,10601964,10601969,10601985,10601997,10602005,10602036,10602058,10602160,10602162,10602163,10602164,10602165,10602166,10602167,10602169,10602170,10602172,10602179,10602180,10602181,10602182,10602183,10602184,10602185,10602186,10602187,10602188,10602189,10602191,10602192,10602193,10602194,10602195,10602196,10602197,10602198,10602236,10602243,10602689,10602696,10602705,10602706,10602707,10602708,10602709,10602710,10602711,10602732,10602739,10603683,10603686,10603687,10603688,10603690,10603691,10603692,10603694,10603695,10603696,10603698,10603699,10603700,10606800,10604146,10582561,10601437,10601574,10601687,10601696,10601698,10601700,10601701,10601703,10601704,10601705,10601707,10601708,10601709,10601756,10601759,10601760,10601787,10601799,10601805,10601910,10601930,10601947,10521871,10521872,10521873,10527957,10544310,10508584,10508590,10508591,10508592,10507632,10411281,10413289,10413301,10413305,10413309,10413313,10413460,10413461,10413978,10413979,10413980,10411980,10413982,10413983,10413984,10413987,10414686,10414687,10414688,10414693,10414714,10414733,10414738,10414770,10414771,10414816,10414817,10414828,10414829,10414830,10414831,10414832,10414833,10414834,10414835,10414836,10414837,10414838,10414839,10414841,10414842,10414843,10414844) 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'