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(4970705,4970736,4970738,4970761,8569474,8569558,7065915,7065953,7065968,7065969,7065972,7066009,7066018,7066079,7066085,7066130,7066131,7066132,7066133,7066134,7066222,7066260,7066267,8067917,8067922,8067923,8067924,8067925,8067934,8067942,10939397,10939408,10939415,10939416,10939417,7064502,7064503,7064504,4967032,8065803,8065824,8065825,8065834,8065835,8065838,8065839,8065840,7065342,8859497,8859498,8859501,10941948,8860321,8860328,10618178,10618179,10618180,10618181,10618182,10618183,10618267,10618269,10618300,10618301,10623508,8070774,8070775,8070776,8070777,8070778,10619177,10619895,10619896,10616984,10617017,10617019,10617020,10622030,10622031,10622042,10622055,10617066,10617068,10617072,10617220,10622266,10622267,10617384,10617462,10617463,10617474,10617478,10622536,10614975,10614977,10614978,10614979,10615002,10615182,10615202,10615211,10615242,10615243,10615244,10615272,10615273,10615274,10615276,10615277,10610984,10610985,10610990,10610994,10614021,10611048,10614050,10611053,10611054,10611126,10611179,10614204,10614210,10611219,10611220,10611228,10614259,10614289,10614296,10614297,10614314,10614354,10614355,10614356,10611357,10614357,10611367,10611368,10611369,10611370,10614376,10611441,10611445,10614452,10614453,10614454,10614455,10614456,10614457,10614463,10614464,10614501,10611508,10614515,10611551,10611559,10614563,10614588,10614592,10611610,10559766,10611623,10614633,10614648,10614663,10611684,10611699,10611700,10611701,10611702,10611703,10611709,10611713,10614729,10611742,10611743,10614752,10611761,10611788,10611801,10611802,10611815,10611819,10611844,10611845,10611856,10614858,10614859,10614862,10614940,10614941,10614942,10614943,10611981,10611983,10611985,10609034,10612035,10609035,10609036,10612036,10612051,10612062,10612063,10612064,10612069,10609070,10609071,10609072,10609073,10609074,10609075,10612075,10609076,10612076,10609077,10609078,10609079,10609080,10609081,10612082,10609082,10609083,10612083,10609084,10609085,10609086,10609087,10609088,10609089,10609090,10609091,10609092,10609093,10609094,10609134,10609135,10609136,10609137,10609139,10612140,10612141,10609142,10612142,10612143,10609143,10612144,10612145,10612146,10612147,10612148,10612149,10612150,10612151,10612152,10612153,10612154,10612155,10612156,10612157,10609164,10609165,10612166,10609169,10609186,10609189,10609190,10609191,10609195,10609197,10609202,10609203,10609204,10609211,10609212,10609221,10609223,10609224,10609227,10609228,10612229,10612230,10612231,10609231,10612232,10612233,10612234,10612235,10612236,10609257,10609261,10609262,10612271,10612274,10609285,10612286,10612299,10612300,10612301,10612302,10612303,10612304,10612305,10612306,10612307,10612308,10612309,10612310,10612311,10612312,10609313,10612313,10612314,10612320,10612321,10609336,10612344,10612351,10612352,10612353,10612356,10609394,10609395,10609396,10609397,10609398,10612408,10612409,10612410,10612411,10612417,10612506,10612555,10612556,10612557,10612558,10609564,10609567,10612620,10612697,10609715,10609716,10609717,10612757,10609770,10609772,10609816,10609818,10609819,10612821,10612822,10609824,10609826,10609836,10609838,10609871,10609872,10612886,10612888,10612893,10612894,10612895,10612896,10612897,10612898,10612909,10612910,10612911,10612913,10612915,10612916,10609946,10612951,10612970,10609972,10609975,10609976,10610006,10613019,10610030,10613034,10613036,10613047,10613048,10613049,10613050,10613056,10613079,10613080,10613081,10613082,10613086,10613089,10610098,10613139,10613140,10613141,10613142,10613143,10613144,10613145,10613146,10613150,10613151,10610152,10613152,10613153,10613154,10613155,10613156,10613158,10613159,10613160,10613162,10613163,10613166,10610167,10610168,10613168,10613169,10613170,10613171,10613172,10613173,10613174,10613175,10613176,10613177,10613178,10613179,10613180,10613182,10613183,10613184,10613191,10613192,10613193,10613194,10613197,10613198,10613201,10613202,10613203,10613206,10613208,10613209,10613210,10613211,10613212,10613213,10613214,10613215,10613216,10613217,10613220,10613221,10613223,10613225,10613229,10613230,10613231,10613232,10613233,10613234,10613235,10610236,10613239,10613240,10613243,10613244,10613248,10613249,10613250,10613251,10613253,10613254,10613258,10613259,10613260,10613265,10613266,10610268,10610271,10613275,10613276,10613277,10613278,10613279,10610282,10613289,10610289,10613292,10613305,10613308,10613309,10613310,10613311,10613312,10613313,10613314,10613315,10610315,10610316,10613316,10613317,10610318,10613318,10610319,10613319,10613320,10613325,10613326,10613328,10613329,10613330,10613331,10610333,10613334,10613335,10610338,10613338,10613339,10613340,10613342,10613343,10613348,10613349,10613350,10613351,10610351,10613355,10613358,10613359,10613360,10613361,10613362,10613363,10613364,10613369,10613370,10613378,10613380,10610396,10613404,10613406,10613429,10613444,10613453,10613455,10610466,10613475,10613497,10613498,10613506,10613510,10613511,10613513,10613514,10613515,10613516,10613517,10613518,10613519,10610520,10613520,10613521,10610535,10613540,10613541,10613542,10613543,10613544,10613545,10613546,10613547,10613553,10613557,10613565,10613570,10613571,10613572,10613585,10613586,10613587,10613588,10613589,10613608,10613609,10613610,10613611,10613613,10613630,10613631,10613632,10613633,10613636,10613639,10613640,10613641,10613642,10613643,10613646,10613647,10613649,10613652,10613653,10613654,10613655,10613656,10613657,10613658,10613663,10613664,10613665,10613666,10613667,10613675,10613676,10613677,10613678,10613692,10613693,10613695,10613696,10610696,10613697,10613698,10613699,10613700,10613701,10613702,10613703,10613704,10613705,10613706,10613707,10613708,10613709,10610709,10613710,10613711,10613712,10613713,10613714,10613715,10613716,10613717,10613718,10613721,10613722,10613723,10613724,10613727,10613728,10613729,10613734,10613735,10613736,10613740,10613742,10613804,10613805,10613806,10613822,10610836,10610842,10610843,10613844,10610844,10610845,10610846,10610847,10610848,10610849,10610850,10610851,10610852,10610853,10610854,10610901,10613932,10610952,10610958,10514971,10415223,10419233,10417255,10417256,10419258,10417258,10417259,10419259,10419260,10417285,10417286,10417293,10419293,10417356,10417357,10419357,10417358,10419358,10419359,10417359,10417360,10419360,10419361,10419362,10419370,10419375,10416375,10416376,10416377,10416378,10416379,10416380,10416381,10416382,10417383,10417384,10417385,10417402,10417406,10417407,10417408,10419440,10419441,10419442,10416460,10419473,10419474,10419475,10419477,10419478,10419479,10419480,10419481,10419482,10419484,10419485,10415487,10419487,10419489,10419491,10416497,10416498,10417529,10416533,10416536,10417537,10416540,10416541,10416542,10416545,10416547,10416548,10416553,10416554,10416555,10416556,10416557,10416558,10416559,10416560,10416561,10416562,10416563,10416564,10417565,10416565,10416569,10419569,10419592,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10417609,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10416628,10419628,10416629,10416630,10419630,10416631,10419631,10416632,10419632,10416633,10419633,10419634,10417635,10419635,10417636,10419636,10419637,10419641,10419642,10419643,10419644,10419645,10419646,10419653,10419654,10419655,10419658,10419659,10419661,10419662,10419663,10419664,10419665,10419666,10419667,10415671,10415673,10415682,10415694,10415695,10417700,10416720,10416722,10416724,10416726,10416760,10419769,10419772,10419774,10416775,10419776,10419779,10419781,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,10417965,10417992,10417993,10417994,10417995,10417996,10417997,10417998,10417999,10418000,10418001,10418002,10418003,10418004,10418005,10418006,10418007,10418008,10418009,10418010,10418011,10418012,10418013,10418014,10418015,10418016,10418017,10418018,10418019,10418020,10418021,10418022,10418023,10418024,10418025,10418026,10418027,10418028,10418029,10418030,10418031,10418032,10418033,10418034,10418035,10417035,10418036,10416056,10416114,10416117,10462907,10462908,10462909,10463001,10463002,10471040,10471041,10471042,10471043,10471044,10471045,10471046,10471047,10471048,10471049,10471050,10471051,10471052,10471053,10471054,10471055,10471056,10471057,10471058,10471062,10471063,10471064,10471065,10471066,10471067,10471114,10471117,10467327,10467477,10469882,10469883,10469884,10469885,10469886,10469887,10469888,10469889,10469890,10469891,10469892,10463981,10463982,10463983,10470062,10470063,10470064,10470065,10470066,10470067,10470068,10470069,10470070,10470071,10470072,10470137,10470161,10470201,10470631,10470643) 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'