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(10962638,10962639,10962640,10962664,10962665,10962692,7076030,7076031,7068242,7076285,7068296,7076307,7076312,10939968,10939969,10939978,10939979,10939982,10939983,10939989,10939992,10940001,7068599,10944029,7068615,7068628,7068641,7068642,7068678,7068679,7068699,8569736,10963493,10963496,4971029,10940497,10940502,10963635,10963636,8066941,8066954,7073993,7066174,7074267,7074284,8067414,8067415,8067423,8067428,8067429,8067436,8067447,8067518,10437433,7066649,7066650,7066651,7074691,8067679,7066710,8067689,8067702,8067716,8067749,10961683,8067906,10961928,10961929,10961941,10961942,10961956,8068200,10962069,10962139,10962163,10962164,10962166,7075512,7067660,7067661,7067667,8068581,8068597,7067740,7067741,7067742,10962533,7075904,10939533,10939534,7064072,8065216,7072248,7072255,10960005,7064371,10960119,7072450,7072605,7072661,7072662,7072665,7072666,7072667,10960351,7072668,10932185,10932186,10932187,10932188,10932189,10960649,10960701,7073034,7073035,7073036,7073037,7073137,7073138,7073139,7073140,7073141,7073142,10960829,8066138,10961017,7065339,8066347,10932729,7073449,8066432,8066474,10961221,7065591,10932954,7073628,7073684,10933033,10933036,10933037,8066672,8066678,7073707,10933075,7065754,7065755,7065756,7065757,7065758,10961466,10961469,10961476,7073834,8066820,8066838,7073863,8066850,7073877,7073878,7073880,7073882,7073883,10961570,10961580,7070961,7070994,7071015,7071016,7071017,7071018,11048925,10942654,11048937,7071049,7071050,10942702,10942706,7071150,7071227,11049287,11049383,8064478,10943133,10959210,10943153,10943154,10943157,10943185,10943192,10943197,10959332,10959333,10943321,10943322,7071828,7071833,6000120,6000121,6000123,6000125,6000194,7068982,7068988,7068996,10944450,10940752,10940759,10940761,10944662,7069318,7069319,7069408,7069415,3655994,3656087,10941173,3656376,3656380,8072644,7069975,8072797,8072805,10941706,10941707,10941708,3656705,10941796,10941804,10941851,10941901,10941906,3656888,10941943,10941944,10941994,10942001,10942010,11048299,11048309,11048310,10942141,11048463,7070660,7070735,7070736,7070737,7070738,7070739,7070764,7070767,7070778,7070822,7070824,7070857,10928599,10923653,10923685,10923699,10618213,10923724,10923743,10618235,10923755,10923759,10923760,10928765,10923772,10923788,10923789,10923862,10923865,10618360,10618361,10618370,10923880,10923914,10923932,10923936,10923944,10923956,10923959,10923960,10923961,10923962,10923963,10923978,10923997,10924023,10924051,10924052,10919052,10924066,10924071,10924072,10924077,10924078,10924080,10924086,10924094,10924095,10924110,10924116,10924119,10924127,10924148,10924149,10924161,10924176,10924201,10924214,10924221,10924241,10924270,10623782,10924341,10623837,10623864,10924402,10924470,10924487,10919524,10924526,10919526,10624043,10924587,10924600,10924645,10919700,10619203,10619204,10924779,10924810,10924822,10924838,10924842,10924853,10924860,10924876,10924881,10619373,10619374,10619375,10924893,10924902,10924903,10924904,10924905,10919920,10924945,10924957,10924961,10924985,10924986,10924988,10924991,10924994,10924995,10925041,10925058,10925069,10925081,10624670,10925201,10925217,10925221,10925225,10925241,10925251,10925261,10925262,10925273,10925277,10925278,10925279,10925289,10925298,10925309,10925321,10925328,10925333,10925334,10925340,10925354,10925358,10927480,10621982,10621990,10621991,10922521,10622017,10953681,10617035,10617038,10953706,10622049,10622141,10622142,10622143,10622144,10922754,10922755,10922762,10622269,10922822,10922842,10927890,10622409,10954113,10928200,10617708,10928254,10619999,10620014,10925538,10620050,10620051,8570013,8570014,8570019,10615083,10615104,10615110,10615111,10615127,10615128,10615129,10615130,10615131,10615132,10615133,10615134,10615135,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,8570206,10920769,10920776,10920784,8570228,10615294,10620303,10620307,8570260,10620324,10920838,10620329,10615337,10920848,10920850,10920853,10620346,10620348,10620350,10620351,10620352,10615355,10620372,10620390,10620391,10620392,10620395,10620396,10920907,10620397,10620409,10620411,10620415,10620417,10620418,10620419,10920933,10620424,8570385,10920954,10920966,10920984,10921003,10926007,10926014,10926015,10921027,10926027,10926028,10921057,10921067,10921146,10926157,10926158,10926159,10926160,10926161,10926162,10926163,10926164,10926165,10926166,10926167,10926168,10926169,10921185,10930622,10926277,10926278,10930726,10926305,10930727,10926306,10930728,10930729,10930730,10930731,10930735,10930736,10921316,10930737,10930740,10930741,10615880,10921556,10616064,10921584,10921589,10921621,10952787,10952803,10952804,10926697,10926703,10616211,10616217,10616218,10926730,10616225,10616227,10616228,10616229,10616230,10616234,10616235,10616240,10616242,10616243,10616245,10616246,10616247,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616261,10616267,10616268,10616269,10616284,10616285,10616287,10616289,10616302,10616303,10616305,10616306,10616311,10616312,10616313,10616314,10616315,10616316,10616326,10616331,10616332,10616335,10616345,10616346,10616348,10616350,10616351,10616352,10616353,10616363,10616367,10616375,10616378,10616407,10616409,10616410,10621421,10616423,10616424,10616426,10616430,10616431,10616434,10921964,10921965,10621510,10621543,10616595,10621749,10616870,10922456,10610996,10611179,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565370,10565371,10611288,10611386,10611392,10611393,10611394,10611406,10611407,10611408,10611410,10565560,10611415,10611416,10611417,10611418,10611419,10611422,10611424,10611425,10611426,8864290,10611431,8864295,10611437,10611438,10611440,10611449,8864314,10565619,10565620,10565621,10611484,10565653,10559731,10559732,10559733,10559734,10559738,10559753,10559754,10611624,10611635,10611636,10611667,10611670,10611671,10611680,10611682,10611699,10611700,10611701,10611705,8864569,8864586,8864671,8864672,8864674,10611821,8864727,10611893,10566061,10566062,10608974,8861980,8861981,10612219,10609306,10609348,10563510,10612381,10612396,10609408,10557819,8862567,10557865,10557866,10557867,10609852,10609854,10612961,10610021,10613086,10613097,8863102,8863103,8863105,8863108,8863111,8863113,8863115,8863118,8863121,8863122,8863124,8863125,8863126,8863143,8863144,8863145,8863146,8863150,8863153,8863157,8863158,8863168,8863169,8863171,8863174,8863175,8863176,10558477,10613356,10613357,10564611,8863339,8863359,10613520,10613521,8863421,8863446,8863483,8863535,8863540,8863556,8863567,8863581,8863588,10610737,10610740,10610748,10613756,10613760,10613761,10613764,10613765,10613783,10613809,10610941,4974155,4974156,10517287,10517288,10517402,10517403,10513403,10517404,10517405,10517406,10517407,10517408,10513435,10513436,10513437,10515526,10515527,10515536,10515537,10515538,10515539,10515594,10515595,10515596,10517650,10517651,10517652,10517653,10517656,10517670,10515731,10515742,10515743,10515744,10513827,10513900,10513901,10513902,10516061,10516062,10516063,10516064,10516065,10514218,10512288,10514316,10512359,10514368,10514369,10512371,10512380,2809331,10556517,10514532,10514533,10514534,10514535,10514536,10514537,10514538,10514539,10514540,10512577,10516597,10516598,10514692,10514693,10514694,10514695,10514696,10514697,10514698,10514699,10514700,10514701,10514702,10514703,10514704,10514705,10514735,10514736,10514737,10514738,10514739,10514740,10514741,10514759,10514760,10514761,10514762,10514763,10514764,10514765,10514766,10514767,10514768,10514907,10516919,10516920,10513047,10513048,10513049,10513050,10513051,10513052,10513053,10515078,10515081,10417222,10417225,10415409,10415410,4973428,10417502,4973434,10417503,10416535,4973601,10416932,10419951,10417079,10420150,10420151,10420152,10417163,4974136,4974137,4974138,10417212,10465022,10463023,10463025,10463026,10463027,4971347,10467075,10467076,4971353,4971357,4971358,4971359,10467146,4971477,4971478,4971503,4971504,4971505,4971506,4971507,4971508,4971525,4971527,4971528,4971529,4971530,4971531,4971532,4971533,4971539,4971546,4971563,4971564,10469290,10469292,4971573,4971574,4971575,4971576,4971579,4971581,4971582,4971583,4971584,4971590,4971591,4971600,4971601,4971602,4971603,4971604,4971607,4971615,4971624,4971633,10463394,10463395,10467440,10469587,10469602,10463741,10463751,10465754,10465760,10463765,10463771,10465772,10465773,10465793,10465846,10465910,10469992,10470008,10464043,10470217,10466304,10466336,10462407,10462413,10462417,10462421,10466424,10462428,10462439,10462441,10462450,10462451,10462452,10462528,10462530,10462531,10466606,10462613,10462614,10462723) 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'