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(4970154,4970155,10939590,4970208,4970209,4970210,10939675,4970282,4970284,4970285,4970288,10939698,4970300,10939716,4970316,10939729,4970323,4970326,10939740,4970347,4970356,4970372,4970373,4970374,10939792,10939823,10939824,10939840,10939841,10939843,10939844,10939845,4970462,4970492,4970493,4970498,4970499,10939940,10939942,4970537,4970538,4970562,4970593,4970594,4970595,4970596,4970608,10940015,4970613,10940024,4970621,4970629,4970669,10940083,4970677,10940086,4970682,4970695,4970718,4970723,4970727,4970737,4970745,4970771,4970775,4970780,4970781,4970792,4970795,10940204,10940222,10940224,4970841,10940303,10940333,10940336,10940339,10940340,10940341,10940359,10940379,10940418,4971028,4971046,4971048,10940507,4971107,4971108,10940534,10940535,4971138,4971139,4971142,4971145,4971146,4971147,4968161,4968162,8066924,8066931,8066932,8066936,4968177,4968179,4968181,4968183,8066982,8067009,8067010,4968273,4968274,8067039,8067059,8067087,4968337,8067103,8067111,8067115,4968360,4968363,4968364,8067125,4968365,8067128,8067129,8067130,8067131,8067178,4968446,4968453,8067257,8067281,8067291,4968541,4968542,8067304,4968543,4968544,4968548,4968549,8067352,8067366,8067423,4968699,8067527,8067544,4968785,8067555,4968802,4968803,4968812,4968813,4968826,4968889,4968890,4968892,4968895,4968896,4968925,4968934,4968935,4968936,4968937,4968938,8067715,4968963,4968964,4968965,4968978,4968998,4969016,4969017,8067791,4969059,4969096,10938511,10938527,10938529,4969143,4969171,10938611,4969213,10938620,10938621,4969239,10938658,10938659,10938668,10938699,4969304,4969307,4969308,4969309,4969310,4969311,4969316,4969317,4969332,4969333,4969335,4969336,4969337,4969343,10938754,4969352,4969353,4969365,4969366,10938775,4969407,10938862,10938889,10938899,10938912,10938988,10939037,4969647,10939055,10939058,10939059,10939060,10939071,10939095,10939106,10939107,10939109,10939110,10939111,4969704,4969705,4969707,4969709,10939123,10939124,10939167,10939219,10939220,10939228,10939237,10939265,4969871,4969872,4969873,10939303,4969896,10939306,10939322,10939323,10939324,4969927,10939334,4969939,4969941,4969942,4969943,4969944,10939360,4969962,4969973,4969975,4969976,4969977,4969978,10939447,10939449,4970043,10939453,4970046,10939454,4970048,4970049,10939484,4970081,4970082,4970084,10939497,10939498,4970109,4970110,4970111,10939549,8064923,8064925,8064926,8064935,8064938,8064959,8064984,8064985,8064996,8065019,8065033,8065034,8065035,8074802,8074803,8074804,8074805,8074806,8074807,8065054,8065065,8065066,8065085,8065086,8065087,8074844,8065088,8074845,8065089,8074846,8074847,8074848,8074849,8065107,8065256,8065317,8065318,8065328,8065330,8065345,8065370,8065371,8065401,8065402,8065403,8065408,8065414,8065436,8065437,8065459,8065460,8065477,8075243,8075272,8065556,8065578,8065579,8065587,8065591,8065624,8065643,8065644,8065676,8065718,8065724,8065725,8065726,8065727,8065740,8065750,8065751,8065774,8065775,8065776,4967034,8065796,8065797,4967036,4967038,4967039,8065807,8065835,4967101,8065864,8065895,4967150,4967164,4967165,4967166,4967196,4967197,8065980,4967261,4967263,8066070,4967336,8066117,4967392,8066158,8066161,4967409,4967410,4967412,8066196,4967453,8066214,8066215,4967454,8066216,8066217,8066244,8066247,4967489,4967491,4967492,8066253,4967494,4967496,4967527,4967535,4967545,8066307,4967571,4967572,4967594,4967595,4967623,4967644,8066441,4967686,8066487,8066488,4967732,8066507,8066508,8066509,8066510,8066512,4967762,8066536,8066537,8066538,8066539,8066540,8066541,8066542,8066543,8066544,8066545,8066546,8066547,8066548,8066549,8066550,8066551,8066552,8066553,8066554,8066555,8066556,4967806,4967850,4967851,4967852,4967853,4967854,4967855,4967856,4967857,4967858,4967859,4967860,4967861,4967923,8066697,4967945,4967960,4967963,4967967,4967968,4967971,8066736,8066764,8066782,4968076,4968077,4968078,4968120,11049794,8063953,8063959,8063968,8064001,8064027,8064028,8064126,8064209,8064211,8064212,8064286,8064296,8064297,8064321,8064350,8064376,8064466,8064483,8064541,8064542,8064543,8064632,8064672,8064673,8064706,8064707,8064767,8064805,8064856,8064877,8064906,3655550,3655551,3655571,3655761,3655807,3655870,3655871,3655962,3656216,3656369,3656385,3656387,3656392,3656394,3656395,3656396,3656397,3656398,3656399,3656400,3656401,3656413,3656414,3656416,3656522,3656620,3656774,8072990,8072991,3656894,3656939,3656998,3657032,11049619,11049620,11049621,11049622,11049623,11049663,11049689,11049772,11049774,10622973,10622978,10622980,10622982,10622984,10623000,10623003,10623028,10623030,10623032,10623038,10623046,10623051,10623085,10623099,10623102,10623104,10918644,10623138,10918717,10918761,10918769,10918770,10918783,10623289,10623290,10623301,10918817,10918826,10918827,10623318,10623329,10623340,10623351,10918869,10623362,10918874,10623366,10623373,10623376,10623382,10623407,10623412,10623423,10623434,10918947,10623445,10623454,10623457,10623464,10623473,10919042,10623537,10623548,10623602,10919127,10919130,10919131,10623633,10919157,10623647,10623648,10623649,10919162,10919165,10919172,10623665,10623671,10919190,10623685,10623700,10919213,10623715,10919231,10623729,10919243,10623733,10623735,10919291,10623790,10919341,10623893,10919413,10623904,10623938,10919472,10919482,10624022,10624023,10624119,10624128,10624150,10624151,10624152,10624153,10919683,10624247,10624345,10624423,10624424,10624425,10624431,10624453,10624454,10624455,10919990,10624557,10920086,10920091,10920092,10920093,10920094,10920095,10920096,10920119,10920120,10624632,10624633,10624654,10624657,10624663,10624707,10624708,10624789,10624791,10624792,10624793,10624794,10920343,10920361,10920373,10920378,10920390,10920391,10920409,10920410,10920411,10920412,10920413,10920414,10920415,10920416,10920417,10624916,10621975,10622069,10622091,10917604,10622094,10917642,10917652,10917688,10917693,10917699,10917731,10917732,10917733,10622251,10917871,10917872,10917873,10917874,10917875,10622367,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10622410,10622412,10917947,10917949,10917950,10917951,10917952,10917953,10622485,10622512,10918022,10622534,10622545,10622570,10918098,10918099,10622677,10622710,10622719,10622725,10622729,10622733,10622803,10622942,10619980,10620048,10620094,10620108,10620116,10915648,10915649,10915650,10915651,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10915718,10915719,10915720,10915721,10915722,10915723,10915724,10620237,10620268,10620269,10620285,10620289,10620292,10620462,10620464,10620476,10620567,10620589,10620596,10620597,10620652,10620683,10620684,10620711,10620759,10620769,10620778,10620787,10620788,10620794,10620795,10620797,10620877,10916443,10916459,10916467,10916469,10916470,10916471,10916472,10916473,10916474,10916475,10916476,10916477,10916478,10916556,10621106,10916622,10916623,10916624,10916625,10916626,10916627,10916628,10916629,10916630,10916631,10621145,10621155,10621156,10621157,10621158,10621159,10621160,10621359,10621369,10621376,10621380,10621386,10621387,10621388,10621390,10621396,10621410,10621411,10621412,10621413,10621414,10621415,10621416,10621417,10621418,10621419,10621420,10621445,10621498,10621505,10621506,10621583,10621785,10621790,10621791,10621816,10621835,10621841,10621842,10621869,10621870,10621871,10621900,10621901,10621902,10621938,10621945,10621953,10565149,10565192,10565233,10565367,10565460,10565834,10565835,10565838,10565854,10565963,10565966,10566067,10563157,10563158,10563159,10563176,10563210,10563211,10563212,10563213,10563231,10563287,10563288,10563517,10563530,10563531,10563532,10563533,10563534,10563535,10563536,10563537,10563538,10563539,10563540,10563541,10563542,10563543,10563544,10563545,10563563,10564124,10564125,10564126,10564127,10564128,10564500,10564637,10564659,10564892,10564990,10517400,10517495,10517562,10517743,10517744,10517750,10517751,10517918,10517919,10517920,10517941,10518040,10518149,10518150,10518151,10518152,10518153,10518154,10518155,10518444,10518671,10518952,10518980,10518992,10518993,10519083,10519086,10519088,10519097,10519098,10419468,10419671,10419672,10419695,10419905,10419906,10419985,10419988,10420033,10420077,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10420134,10470936,10471081,10471099,10471103,10471128,10471284,10471291,10471297,10471298,10471299,10471300,10471312,10471313,10471314,10471322,10471335,10471339,10471353,10471528,10471545,10471552,10471553,10471554,10471555,10471556,10471564,10470095,10470761,10470766) 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'