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(4970703,4970704,4970705,4970706,4970707,4970708,4970709,4970710,4970711,4970712,4970713,4970714,4970736,4970741,4970744,4970761,7065969,7065970,7065971,7065972,7065973,7065986,7065987,7065988,7065989,7065990,7066009,7066014,7066015,7066077,7066078,7066079,7066080,7066081,7066082,7066083,7066084,7066085,7066086,7066087,7066088,7066089,7066090,7066091,7066092,7066093,7066094,7066095,7066189,7066255,7066260,8067919,8067920,8067921,8067922,8067923,8067924,8067925,8067938,8067939,8067940,8067942,7067569,7067576,8860328,8860379,8860380,8860381,8860405,10623959,10622266,10622267,10622406,10927994,10927995,10927996,10927997,10927998,10927999,10928000,10622525,10620072,10620200,10620487,10620488,10620491,10620560,10614048,10614050,10614210,10614282,10614289,10614296,10614297,10614355,10614356,10614357,10614532,10614555,10614562,10614563,10614888,10611968,10612062,10612063,10612064,10612166,10612168,10612169,10612229,10612230,10612231,10612232,10612233,10612234,10612235,10612236,10612237,10612238,10612286,10612350,10612351,10612352,10612353,10612354,10612355,10612356,10612357,10612358,10612359,10612360,10612361,10612362,10612363,10612364,10612365,10612366,10612367,10612368,10612369,10612370,10612371,10612372,10612373,10612374,10612375,10612376,10612377,10612378,10612379,10612895,10612896,10612907,10612909,10612911,10612912,10612914,10612916,10613034,10613035,10613036,10613079,10613080,10613086,10613092,10613094,10613138,10613139,10613140,10613141,10613142,10613143,10613144,10613145,10613146,10613147,10613148,10613149,10613150,10613151,10613152,10613153,10613154,10613155,10613156,10613157,10613158,10613159,10613160,10613161,10613162,10613163,10613164,10613165,10613166,10613167,10613168,10613169,10613170,10613171,10613172,10613173,10613174,10613175,10613176,10613177,10613178,10613179,10613180,10613181,10613182,10613183,10613184,10613185,10613186,10613187,10613188,10613189,10613190,10613191,10613192,10613193,10613194,10613195,10613196,10613197,10613198,10613199,10613200,10613201,10613202,10613203,10613204,10613205,10613206,10613207,10613208,10613209,10613210,10613211,10613212,10613213,10613214,10613215,10613216,10613217,10613218,10613219,10613220,10613221,10613222,10613223,10613224,10613225,10613226,10613227,10613228,10613229,10613230,10613231,10613232,10613233,10613234,10613235,10613236,10613237,10613238,10613239,10613240,10613241,10613242,10613243,10613244,10613245,10613246,10613247,10613248,10613249,10613250,10613251,10613252,10613253,10613254,10613255,10613256,10613257,10613258,10613259,10613260,10613261,10613262,10613263,10613264,10613265,10613266,10613267,10613268,10613269,10613270,10613271,10613272,10613273,10613274,10613275,10613276,10613277,10613278,10613279,10613280,10613281,10613282,10613283,10613284,10613285,10613286,10613287,10613288,10613289,10613290,10613291,10613292,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613305,10613306,10613307,10613308,10613309,10613310,10613311,10613312,10613313,10613314,10613315,10613316,10613317,10613318,10613319,10613320,10613321,10613322,10613323,10613324,10613325,10613326,10613327,10613328,10613329,10613330,10613331,10613332,10613333,10613334,10613335,10613336,10613337,10613338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10613346,10613347,10613348,10613349,10613350,10613351,10613352,10613353,10613354,10613355,10613356,10613357,10613358,10613359,10613360,10613361,10613362,10613363,10613364,10613365,10613366,10613367,10613368,10613369,10613370,10613371,10613372,10613373,10613374,10613375,10613376,10613377,10613378,10613379,10613380,10613381,10613382,10613383,10613384,10613385,10613386,10613387,10613388,10613389,10613390,10613391,10613392,10613393,10613394,10613395,10613396,10613397,10613398,10613399,10613400,10613401,10613402,10613403,10613404,10613405,10613406,10613407,10613408,10613409,10613410,10613411,10613412,10613413,10613414,10613415,10613416,10613417,10613418,10613419,10613420,10613421,10613422,10613423,10613424,10613425,10613426,10613427,10613428,10613429,10613430,10613431,10613432,10613433,10613434,10613435,10613436,10613437,10613438,10613439,10613440,10613441,10613442,10613443,10613444,10613445,10613446,10613447,10613448,10613449,10613450,10613451,10613452,10613453,10613454,10613455,10613456,10613457,10613458,10613459,10613460,10613461,10613462,10613463,10613464,10613465,10613466,10613467,10613468,10613469,10613470,10613471,10613472,10613473,10613474,10613475,10613476,10613477,10613478,10613479,10613480,10613481,10613482,10613483,10613484,10613485,10613486,10613487,10613488,10613489,10613490,10613491,10613492,10613493,10613494,10613495,10613496,10613497,10613498,10613499,10613500,10613501,10613502,10613503,10613504,10613505,10613506,10613507,10613508,10613509,10613510,10613511,10613512,10613513,10613514,10613515,10613516,10613517,10613518,10613519,10613520,10613521,10613522,10613523,10613524,10613525,10613526,10613527,10613528,10613529,10613530,10613531,10613532,10613533,10613534,10613535,10613536,10613537,10613538,10613539,10613540,10613541,10613542,10613543,10613544,10613545,10613546,10613547,10613548,10613549,10613550,10613551,10613552,10613553,10613554,10613555,10613556,10613557,10613558,10613559,10613560,10613561,10613562,10613563,10613564,10613565,10613566,10613567,10613568,10613569,10613570,10613571,10613572,10613573,10613574,10613575,10613576,10613577,10613578,10613579,10613580,10613581,10613582,10613583,10613584,10613585,10613586,10613587,10613588,10613589,10613590,10613591,10613592,10613593,10613594,10613595,10613596,10613597,10613598,10613599,10613600,10613601,10613602,10613603,10613604,10613605,10613606,10613607,10613608,10613609,10613610,10613611,10613612,10613613,10613614,10613615,10613616,10613617,10613618,10613619,10613620,10613621,10613622,10613623,10613624,10613625,10613626,10613627,10613628,10613629,10613630,10613631,10613632,10613633,10613634,10613635,10613636,10613637,10613638,10613639,10613640,10613641,10613642,10613643,10613644,10613645,10613646,10613647,10613648,10613649,10613650,10613651,10613652,10613653,10613654,10613655,10613656,10613657,10613658,10613659,10613660,10613661,10613662,10613663,10613664,10613665,10613666,10613667,10613668,10613669,10613670,10613671,10613672,10613673,10613674,10613675,10613676,10613677,10613678,10613679,10613680,10613681,10613682,10613683,10613684,10613685,10613686,10613687,10613688,10613689,10613690,10613691,10613692,10613693,10613694,10613695,10613696,10613697,10613698,10613699,10613700,10613701,10613702,10613703,10613704,10613705,10613706,10613707,10613708,10613709,10613710,10613711,10613712,10613713,10613714,10613715,10613716,10613717,10613718,10613719,10613720,10613721,10613722,10613723,10613724,10613725,10613726,10613727,10613728,10613729,10613730,10613731,10613732,10613733,10613734,10613735,10613736,10613737,10613738,10613739,10613740,10613741,10613742,10613751,10613752,10613804,10613805,10613806,10513728,10513729,10514109,10514110,10514111,10514899,10514900,10514901,10514902,10514903,10514904,10514905,10514906,10514907,10514908,10514909,10514910,10514911,10514912,10514913,10514914,10514915,10514916,10514917,10514918,10514919,10514920,10514921,10514922,10514923,10514924,10419227,10419228,10419229,10419230,10419231,10419232,10419233,10419234,10416253,10416254,10416255,10416256,10416257,10416258,10416259,10419259,10416260,10419260,10416261,10416262,10416263,10416264,10416265,10416266,10416267,10416268,10416269,10416270,10416271,10416272,10416273,10416274,10416275,10416276,10416277,10416278,10416279,10416345,10416346,10419375,10416375,10416376,10419376,10416377,10416378,10416379,10416380,10416381,10416382,10419440,10419441,10419442,10419443,10419444,10419445,10419470,10416482,10416483,10416484,10416485,10416486,10416487,10416488,10416638,10416639,10416757,10416758,10416759,10416760,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10419866,10471040,10471041,10471042,10471043,10471044,10471045,10471046,10471047,10471048,10471049,10471050,10471051,10471052,10471053,10471054,10471055,10471056,10471057,10471058,10471059,10471060,10471061,10471062,10471063,10471064,10471065,10471066,10471067,10471068,10471069,10471070,10471071,10471072,10471073,10471074,10471075,10471076,10471077,10471154,10471155,10471156,10471157,10471158,10471159,10471160,10469881,10469882,10469883,10469884,10469885,10469886,10469887,10469888,10469889,10469890,10469891,10469892,10469896,10469898,10469932,10469933,10469934,10469935,10470116,10470117,10470118,10470119,10470120,10470121,10470122,10470123,10470124,10470125,10470126,10470127,10470128,10470129,10470130,10470131,10470132,10470133,10470134,10470135,10470136,10470137) 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'