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(8630478,8630481,8630511,11001779,8630751,8630752,8630753,8630754,8630757,8630812,8630858,8630859,8630906,8630907,8630908,8630936,8630938,8630939,8630940,8630941,8630942,8630943,8630944,8630945,8630946,8630947,8630948,10448179,8630949,8630950,8630951,8630952,8630953,8630954,8630955,8630956,8630957,8630987,8630988,8630989,8630990,8630991,8630992,8631015,8631016,8631017,8631018,8631019,8838943,8575024,11041615,11041616,10950709,7074199,7074558,10951394,7066940,10844714,10844715,10844870,8573572,8620375,8620376,7067548,7067584,10939404,10929962,11037524,10103019,10103020,10103024,10103025,10103026,10103027,10103028,10103029,10103031,10103032,10103033,10103034,10103035,10103036,10103037,10103038,10103039,7201197,7201202,7201203,7201204,7201205,7201206,7201207,7201208,7201209,7201210,7201211,7201212,7201213,7201214,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,7201223,7201224,7201225,10103109,7201226,7201227,7201228,7201229,7201230,7201231,7201232,7201233,7201234,7201235,7201236,7201237,7201238,7201239,7201240,7201241,7201242,7201243,7201244,7201245,7201246,7201247,7201248,7201249,7201251,7201253,7201254,7201255,7201257,7201258,7201259,7201260,7201261,7201262,7201263,7201264,7201265,7201272,7201273,7201274,7201275,7201276,10103160,7201277,7201278,7201279,7201280,7201291,7201292,7201293,7201294,7201295,7201296,7201300,7201301,7201302,10842809,10842810,7201303,7201306,7201317,7201318,7201320,7201321,7201325,7201326,7201327,7201328,7201329,7201330,7201331,7201339,7201340,7201341,7201342,7201343,7201344,7201348,7201349,7201350,7201351,7201352,7201353,7201354,10103242,10103243,10103244,3238539,7201368,7201371,7201372,7201375,7201376,7201377,7201378,7201379,10842887,10842896,10842897,10842900,10842901,10842902,10842912,10842913,7072228,7072230,7072231,7201518,7201519,7201520,7201521,7201522,7201523,7201524,7201525,7201526,7201527,7201528,7201529,7201530,7201531,10103435,7201595,7201605,7201607,10960047,7201622,7201627,7201628,7201629,7201630,7201644,7201655,7201677,7201680,7201681,7201682,7201701,7201702,7201703,7201705,7201740,7201744,7201752,7201753,7201761,7201762,8836067,10986262,7201858,7201859,7201864,7201866,7201873,7201874,7201875,7201876,7201877,7201878,7201879,7201880,7201881,7201882,7201883,7201884,10103771,7201889,7201890,7201891,7201892,7201905,7201906,8911755,10843469,7201976,7201977,10986447,10986448,10986449,10986450,10986451,7202053,10986496,10986497,10986498,10986499,10986500,10986501,10986502,10986503,10986504,10986505,8911935,10843637,7202163,7202201,7202202,7202203,10843756,10999728,10999730,10999733,7202330,7202331,7202332,7202333,7202334,7202335,7202338,7202343,7202345,7202346,7202347,7202348,7202356,7202357,7202358,7202359,7202364,7202365,7202366,7202440,10104418,7202577,7202578,7202579,7202580,7202588,7202589,7202590,7202591,7202592,7202593,7202596,10844120,7202699,7202700,10844264,7202764,7202765,7202766,10101990,10102055,10102079,3237389,8910162,7200501,7200503,7200581,7200582,7200583,7200584,7200585,7200588,7200598,7200599,7200600,7200601,7200602,7200607,7200608,7200614,7200616,7200624,7200644,10102652,10102653,10102654,7071577,7071578,8910667,8910668,8910669,8910670,8910671,8910672,8910673,8910674,8910675,8910676,8910677,8910679,8910680,8910681,8910682,7200893,7200901,7200911,7200912,7200913,7200914,7200915,7200916,7200937,10102847,10102869,8970239,10100073,10839701,10839961,10839962,10839963,8908503,8908504,8908505,8908506,8908507,8908522,8908525,7199152,10996592,10996593,10101046,7199182,7199183,7069982,7069985,8564730,8909101,8564860,10840908,8615991,3236574,10840909,8615992,10840926,10840927,10101335,10996916,7199545,10101480,10101481,8565097,8565098,10101591,10101601,10101630,10101631,10101718,10958377,10958378,10942491,8579013,8579014,8579015,8579016,8612684,10623058,10623059,3233332,10623064,8579122,7196217,8612892,10618258,10618300,10618301,11045867,10623490,10623495,10623496,10623506,11046089,7196981,7197128,7197129,7197130,8906954,10838710,10838941,7197730,7197732,7197733,7197734,7197735,7197738,7197740,7197743,7197744,10619836,10927504,10927505,10927506,10927507,10927508,8541491,8541549,10622187,10622196,10617211,8541677,10617327,8541735,10617456,10617489,3232796,3232797,3232798,3232799,10837134,10837174,10837222,11045219,8905737,8542314,10951458,10964553,10620112,10620113,10620114,10620115,10620116,10620117,10620118,10620121,10615170,10615171,10615172,10620175,10620183,8576395,10615451,10615452,10615453,10615454,10615455,10615456,10615457,10615458,10615460,10615461,11043084,11043085,10615552,10848173,10615574,10615575,10848408,10848409,10848450,10848451,3231156,3231157,3231158,3231159,11043455,10965469,10616005,10616019,8540530,8540543,8904183,8540757,8540797,8540798,8540799,8540800,8540801,8540802,8540897,8540986,8540987,8540988,8540989,8540990,8540991,8540992,8540993,8540994,8540995,8540996,8540997,8540998,8540999,8541000,8541001,8541002,8541003,10616655,8611387,10992401,10616907,10565150,10611036,10559334,10611226,10611550,10559713,10614595,10611779,9198156,9198157,9198158,9198159,10614861,10614864,10566052,10566053,10119573,10119574,10612270,10612291,10609392,7057913,9171752,10609717,10609724,10609834,9220321,9220322,9220324,10610023,9220340,10613265,7058796,10613319,10610351,10121052,9204961,10610694,10613784,10117609,9169509,9169512,10515328,10117877,10517536,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,7056052,7056099,7056100,10118317,10118593,10119200,10119201,10119202,10119203,10119222,10557017,10416302,10416303,10416304,10416331,10416332,9176428,9192455,10417409,10117011,10416060,9193195,9193197,6666640,10122842,9166815,9166817,9166818,9166819,9166820,9166821,9166822,9166823,9166824,8549992,10123132,10123139,10123142,9183060,9191109,8550558,9207484,8563565,8917383,8917384,6667876,9176086,9176087,9176088,9176089,9176090,9176091,9176092,9176093,9176104,10628149,10628157,10628324,10174928,10174929,10628769,10628831,10171212,10631995,10631996,10631997,10631998,10631999,10632000,10632106,10632107,10632108,10632109,10632110,10627113,10627114,10627115,10632167,10632168,10632186,7000886,10632202,10632203,10163772,10163773,10632310,10632311,10632312,10632313,10173889,7001186,10627666,10627667,10627710,10627779,10627793,10630022,10630023,10630024,10630025,10630026,10630027,10630028,10630029,10630030,10630031,10630032,10630033,10630034,10630035,10630036,10630037,10630038,10630039,10630040,10630041,10630042,10630043,10630044,10630045,10630046,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630068,10630069,10630070,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630078,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630089,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10630099,10630100,10630101,10630102,10630103,10630104,10630105,10162470,10162471,10626143,10626144,10626299,10626300,10626301,10626429,10626430,10626431,10626438,10631541,10631542,10631543,10631544,10631545,10631546,10631547,10631548,10631549,10631884,10631885,10626951,10626952,10601172,10601173,10583441,10598523,10598534,10566131,10578435,10567318,10567319,10579463,10579464,10579465,10579466,10579467,10579468,10579469,10579470,10579471,10582558,10582559,10582560,10582561,10582578,10582579,10580000,10580001,10580002,10541445,10541447,10541448,10529719,10529720,10529721,10529722,10529723,10537758,10537759,10521879,10521880,10528075,10528076,10528077,10528078,10528079,10528080,10528081,10528082,10528083,10528084,10528085,10528086,10528198,10528199,10528200,10528201,10528202,10528203,10528204,10528205,10528206,10528207,10528208,10528209,10528211,10528217,10544340,10544442,10544443,10544446,10544447,10544448,10544449,10544450,10544451,10544452,10544453,10544454,10544455,10544456,10528526,10528527,10528528,10528529,10528530,10528531,10528576,10528577,10522593,10522594,10522595,10522597,10522618,10522619,10522620,10524911,10525007,10525008,10525009,10525010,10425238,10425336,10422360,10422361,10421486,10421487,10421488,10421489,10421490,10421491,10421492,10420716,10420750,10420751,10420752,10422796,10422813,10422814,10422815,10422816,10423919,10423920,10423921,10424936,10425188,10485904,10485905,10485906,10407327,10483127,10483130,10483131,10483132,10483133,10483134,10483135,10483136,10483137,10477143,10477144,10486239,10484490,10484495,10484496,10484497,10484498,10408713,10408717,10406969,10406970) 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'