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,8067919,8067920,8067921,8067922,8067923,8067924,8067925,8067938,8067939,8067940,8067942,10938937,10938938,10938939,10938940,10938941,10939156,10939408,10939415,10939416,8065802,8065803,8065812,8065813,8065828,8065832,8065833,8065834,8065835,8065836,8970178,8970179,10623959,10622266,10622267,10622406,10622525,10620072,10620200,10620487,10620488,10620491,10620560,10614048,10614050,10611203,10611204,10611205,10611206,10611207,10611208,10611209,10614210,10611210,10611211,10611212,10611213,10611214,10611215,10611216,10611217,10611218,10611219,10611220,10611221,10611222,10611223,10614282,10614289,10614296,10614297,10614355,10614356,10614357,10611364,10614532,10614555,10614562,10614563,10611699,10611700,10611701,10611702,10611703,10611708,10611709,10611710,10611711,10611712,10611713,10611714,10611715,10611802,10611838,10611839,10611840,10611841,10611842,10614888,10611968,10612062,10612063,10612064,10612166,10612168,10612169,10612229,10612230,10612231,10612232,10612233,10612234,10612235,10612236,10612237,10612238,10609239,10612286,10609313,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,10609715,10609716,10609717,10609770,10609816,10609824,10609838,10609843,10612895,10612896,10612907,10612909,10612911,10612912,10612914,10612916,10610030,10613034,10613035,10613036,10613079,10613080,10613086,10613092,10613094,10610098,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,10610236,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,10610271,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,10610306,10613306,10613307,10610307,10610308,10613308,10610309,10613309,10610310,10613310,10610311,10613311,10610312,10613312,10610313,10613313,10610314,10613314,10613315,10610315,10613316,10610316,10613317,10610317,10613318,10610318,10613319,10610319,10613320,10610320,10613321,10610321,10613322,10610322,10613323,10610323,10613324,10610324,10613325,10610325,10613326,10610326,10613327,10610327,10613328,10610328,10613329,10610329,10613330,10610330,10613331,10610331,10613332,10610332,10613333,10610333,10613334,10610334,10613335,10610335,10613336,10610336,10613337,10610337,10613338,10610338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10613346,10613347,10613348,10613349,10613350,10613351,10610351,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,10610417,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,10610842,10610843,10610844,10610845,10610846,10610847,10610848,10610849,10610850,10610851,10610852,10610853,10610854,10610927,10419227,10419228,10419229,10419230,10419231,10419232,10419233,10419234,10419259,10419260,10415332,10415342,10415343,10415344,10419375,10419376,10415397,10419440,10419441,10419442,10419443,10419444,10419445,10419470,10415492,10415671,10415673,10415674,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'