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(8630690,8630743,8630744,8630745,8630746,8630747,8630748,8838614,8838621,8630816,8630874,8630875,8630876,8630877,8630878,8630879,8630880,8630881,8630884,10939868,8630892,8630894,8630906,8630907,8630908,8630909,8630910,8630912,8630917,8630918,8630919,8630987,8630997,8630998,10448242,8631016,8631017,8631018,8631019,8631020,8631021,8631022,8631023,8631024,8631025,8631026,8631080,8631081,8631084,8631087,10459017,10459023,8631120,8631188,8631189,8631190,8631191,8631253,8631255,8631256,8631257,8631258,8631259,8631260,8631261,8631262,8631263,8631264,8631265,8631266,8631267,8631268,8631269,8631270,8631271,8631272,8631273,8631274,8569625,8631298,8631299,8631300,8631301,8631303,8631304,8631305,8631306,8631307,8631309,8631310,8631311,8631312,8631313,8631315,8631316,8631317,8631318,8631319,8631321,8631322,8631323,8631324,8631325,8631327,8631328,8631329,8631330,8631331,8631333,8631334,8631335,8631336,8631337,8631339,8631340,8631341,8631342,8631343,8631345,8631480,8631481,8631482,8631483,8631484,4971081,8631590,8631622,8631623,8631624,8631625,8631626,8631629,10963668,8631631,8631632,8631633,8631634,8631635,10963674,8631644,8631645,8631646,8631647,8631648,8631649,8631650,8631653,8631654,8631655,8631656,8631673,8631711,8631743,8631749,8631751,8631752,8631754,8631755,8631757,8631765,8631995,8631996,8631997,8631998,8631999,8632000,8632001,8632002,8632003,8632004,8632005,8632006,10847216,8575658,8575659,8632196,8632197,8632198,8632199,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8622469,7075460,7067539,10962565,10962566,7201200,7201201,7201203,7201213,7201214,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,7201223,7201224,7201321,7201366,7201367,7201377,10103266,10103271,10842900,10842901,10842902,8617990,10842915,7064168,10842926,10842927,10103440,7201624,10843156,10843157,10843158,10843159,10843160,7201668,7201669,7201670,7201671,7201672,7201673,7201674,7201675,7201676,7201677,7201678,7201680,7201681,7201682,7201683,7201690,7201691,7201692,7201693,7201694,7201695,7201696,7201697,7201761,7201762,10843270,7201775,7201776,7201777,7201778,7201779,7201780,7201781,3899035,7201782,7201789,7201790,7201791,7201792,7201793,7201794,7201795,7201796,7201797,7201798,7201799,7201800,7201801,7201802,7201803,7201804,7201805,7201806,7201807,7201808,7201809,7201810,7201811,7201812,7201813,7201814,7201815,7201816,7201817,7201818,7201819,7201820,7201821,7201822,7201823,7201824,7201825,7201826,7201827,7201828,7201829,7201830,7201831,7201832,7201833,7201834,7201835,7201836,7201837,7201838,7201839,7201892,7201904,3899204,7202077,7202104,8572096,10843709,7202209,7202210,3899509,3899510,7202258,7202259,7202265,7202266,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,10104393,10104394,10104395,10104396,10104397,10104398,7202585,11000110,10844185,10844186,7202680,10844187,10844188,10844189,7202683,10844190,7202684,7202695,10104613,10844239,10844261,9794592,8572755,10102108,8616857,8616858,10997861,3237634,7071325,8834860,10102550,7071537,10842319,10842320,10842356,7200882,7200883,7200888,7200889,10842548,10839695,10995822,3655849,3655890,10840245,7069592,10840808,10840874,10840875,8615995,8615996,8615997,8615998,10101297,8073172,10101591,8073210,8073294,10101691,10101692,10101693,10101699,10102026,7196220,8612813,8612892,7196307,7196316,7196317,8612924,7196337,10618183,3233590,7196508,7196512,7196516,7196523,7196526,7196527,7196528,10838077,3233760,10623490,7196890,7196891,7196892,7197128,7197129,7197130,8906954,10838803,10838816,10838919,10838920,10838921,10838922,10838923,10838924,3234716,3234717,3234718,3234719,11008054,10839202,10624632,10624633,7197854,7197855,7197856,10839637,10839638,7198138,10966658,8611810,8541549,10617171,10622217,10622224,10622225,8612185,8612272,3232911,3232912,10837263,10837264,10837362,8542215,11045522,11045523,11045524,10951634,3230564,3230565,3230566,10620183,10847913,10615229,10847971,10951941,10952141,10952142,10620559,10615598,10991312,10615710,10965428,10615896,10616033,10621034,3231623,8540757,8540797,8540798,8540799,8540800,8540801,8540802,8540986,8540987,8540988,8540989,8540990,8540991,8540992,8540993,8540994,8540995,8540996,8540997,8540998,8540999,8541000,8541001,8541002,8541003,8541017,10616542,10616543,10616544,10616553,8611706,10616955,8541443,7059524,10614064,7059786,7059787,6665751,9173757,10559630,10614552,10614553,10614554,10611590,10611665,9166018,10614857,10611891,10611892,7057605,9171609,10612291,7057913,10609749,10561087,10561088,10561089,10561090,10561091,10561092,10561093,10561094,10561095,10561096,10561097,10561098,10561099,10561100,10561101,10561102,10561103,10561104,10561105,10561106,10561107,10613149,10558317,10558318,10558319,10558320,10613172,10613220,10613221,9188597,10610351,10613362,10613369,10613475,6677026,10517143,10517144,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,7055800,10513619,10513620,10517670,10517809,7056270,7056309,10118342,10516128,10516129,10516130,10516131,10516132,10516142,10514386,10514387,10514388,10514389,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,9186900,10512780,10124570,8918228,6666650,6667350,8917030,8917093,10893754,10893755,10893756,10893758,10893759,10893760,10632106,10632107,10632108,10632109,10632110,10627793,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,10630189,10630191,10631058,10626299,10626300,10626301,10626375,10626378,10626379,10173022,10882010,10626710,10626711,10626720,10626724,10626725,10631794,10631795,10626798,10631882,10631885,10601174,10584083,10584113,10584114,10590673,10590996,10585351,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10539121,10539122,10529335,10529342,10529344,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529400,10529401,10529402,10529403,10529404,10529405,10529406,10529407,10529408,10529409,10529412,10529413,10529414,10529415,10529416,10529417,10529418,10529419,10529420,10529421,10529424,10529425,10541445,10541446,10541447,10541448,10527957,10528213,10534308,10522404,10522406,10522407,10522408,10522409,10522410,10522411,10522412,10522413,10522414,10522415,10522416,10522417,10522418,10522419,10522420,10522421,10522422,10522423,10522424,10522425,10522426,10522427,10522428,10522429,10522430,10522431,10522432,10522433,10522434,10522435,10522436,10522437,10522438,10522439,10522440,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522451,10522452,10522453,10522454,10522455,10522456,10522457,10522458,10522459,10522460,10522461,10522462,10522463,10522464,10522465,10522466,10522467,10522468,10522469,10522470,10522471,10522472,10522473,10522474,10522475,10528578,10528579,10528580,10528581,10528582,10528583,10544815,10544816,10540883,10539096,10539097,10422361,10422372,10422373,10422374,10422375,10422376,10422377,10422378,10422379,10423583,10423584,10422819,10422823,10504737,10424883,10424884,10424885,10424886,10424887,10424888,10424889,10424890,10422167,10407229,10407327,10494384,10476375) 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'