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(10939624,10939625,10939634,10939635,7076141,10962840,10962841,10962842,10962843,10962844,10962845,10962846,10962847,10962848,10962849,10962850,10962851,10962852,10962853,10963006,10963007,10963008,10963009,10963010,10963011,10963012,10963013,8569401,8569540,8569571,8569572,8569636,8569654,10976369,8569708,4971066,7068850,4971067,7068851,4971068,7068852,4971069,7068853,7068854,7068855,7068856,7068857,7068858,7068859,7068860,7068861,7068862,7068863,7068864,7068865,7068866,7068867,7068868,7068869,7068870,7068871,7068872,7068873,4971125,8569911,10963637,10963675,8067138,4968481,4968556,10437250,10437251,10437252,10437253,10437254,10437255,10437307,7066605,7066608,7074683,7074816,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969312,4969313,4969314,4969315,4969316,4969317,4969318,4969319,4969320,4969321,4969322,4969323,4969324,4969325,4969326,4969327,4969328,4969329,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,4969338,4969339,4969340,4969341,4969342,4969343,4969344,4969345,4969346,4969347,4969348,4969349,4969350,4969351,4969352,4969353,4969354,4969355,4969356,4969357,4969358,4969359,4969360,4969361,4969362,4969363,7075184,7075186,7075321,10962057,10962066,10962067,10962074,10962075,10962076,10962077,10962083,10962084,10962085,10962091,10962092,10962093,10962106,10962107,10962108,10962109,10962110,10962111,10962112,10939104,10939105,10939106,10939107,10939108,10939109,10939110,10939111,10939112,10939113,10939114,10939115,10962197,7067558,7067782,7067783,7067788,7067792,7067793,7067794,10939429,7067823,7067824,10939460,7067885,7064063,7072073,7064098,7064099,8065099,8065100,8065101,8065102,8065103,8065104,8065105,8065106,8065107,8065108,8065109,8065110,8065111,8065112,8065113,8065114,8065115,8065116,8065117,7064140,8065118,8065119,7064148,7064156,7064164,7064165,7064166,7064168,7064176,7072178,7064179,7064181,7064183,7064185,7064188,7064192,7064394,7072538,7064663,7064888,10960730,10960732,10960733,7065344,7065345,7065346,7065347,7065348,7065349,7073389,10961233,7065763,11048953,11048955,7071123,10942781,11049152,7071547,10943185,7071570,7071571,7071572,7071573,7071579,7071580,7071581,7071582,7071583,7071584,7071585,11049541,10943297,10943311,10943312,10943416,10943417,7071878,7071879,3655681,3655683,3655684,3655725,3655727,3655729,3655730,11048311,7070472,10942149,7070644,11048546,10958354,10942303,10958387,10958388,10958389,10958390,10958392,10958393,10958394,10958395,10958396,10958397,10958398,10958399,10958400,10958401,10958402,10958403,10958404,10958405,10958406,10958407,10958408,10958409,10958410,10958411,10958412,10958413,10958414,10958415,10958416,10958417,10958418,10958419,10958420,10958421,10958422,10958423,10958424,10958425,10958426,10958427,10958428,10958429,10958430,10958431,10958432,10958433,10958434,10958435,10958436,10958437,10958438,11048654,10958439,11048655,10958440,10958441,10958442,10958443,10958444,10958445,10958446,10958447,10958448,10958449,10958450,10958451,11048670,10618182,10618183,10618234,10967919,10967920,10967921,10967922,10967923,10967924,10967925,10967926,10967927,10967928,10967929,10967930,10967931,10967932,10967933,10967934,10967935,10967936,10967937,10967938,10967939,10967940,10967941,10967942,10967943,10967944,10967945,10967946,10967947,10967948,10967949,10967950,10967951,10967952,10967953,10967954,10967955,10967984,10967985,10967986,10967987,10618391,10618473,10618474,10618475,10618476,10618583,10618584,10618585,10618586,10623658,10618720,10618972,8070886,8071198,10619833,10619834,10617208,10622235,10622238,10622239,10622246,10953997,10953998,10954022,10617475,10617518,10617519,10617522,10617523,10923078,10923079,10617602,10617603,10622694,10622695,10622699,10622876,10620123,10620124,10620125,10620126,10620127,10620128,10620129,10620130,10620131,10620132,10620133,10620134,10620135,10620136,10620138,8570160,8570161,8570175,10615265,8570270,10615412,10615413,10615415,8570386,8570389,8570390,8570393,8570394,8570433,8570466,10615681,10615684,10615710,10930855,10930975,10616048,10616049,10926832,10922400,10922401,10922402,10922403,10614345,10614351,10614352,10614353,8864298,8864299,8864300,8864304,8864305,10559705,10559706,10559741,10559742,10562789,10614722,10559889,10611781,10612059,10560267,10563347,10563348,8862103,8862104,8862105,8862106,8862107,10609330,10609717,10609987,10613017,10613094,10610438,10610564,10613750,10517143,10517144,10511198,10511239,10511240,10511241,10511242,10511243,10511275,10511276,10513342,10513343,10517402,10517403,10517404,10517405,10517406,10517407,10513407,10517408,10517409,10517410,10517411,10517412,10517413,10517414,10517415,10517416,10517417,10517418,10517419,10517420,10517421,10517422,10517423,10517424,10517425,10517426,10517427,10517428,10517429,10517430,10517431,10517432,10517433,10517434,10517435,10517436,10517437,10517438,10517439,10517440,10517441,10517442,10517443,10517444,10517445,10517446,10517447,10517448,10515499,10515511,10515512,10513624,10516235,10516236,10516237,10516663,10512768,10512771,10512772,10512773,10512774,10512775,10512776,10512777,10512778,10514896,4973258,4973259,4973260,4973261,4973262,4973263,4973264,4973265,4973266,4973267,4973268,4973765,4973766,4973767,10419926,10419927,10419928,10419929,10419930,10419931,10417176,10420181,10471323,10471324,10471325,10471326,10471327,10471328,10471329,10471330,10471331,10471332,10471333,10471334,10471335,10471336,10471337,10471338,10471339,10471340,10471341,10471342,10471343,10471344,10471345,10471346,10471347,10471348,10471349,10471350,10469576,10465918,10465919,10465920,10465921,10465922,10465923,10465924,10465925,10465926,10465927,10465928,10465929,10465930,10465931,10465932,10465933,10465934,10465935,10465936,10465937,10465938,10465939,10465940,10465941,10465942,10465943,10465944,10465945,10465946,10465947,10465948,10465949,10465950,10465951,10465952,10465953,10465954,10465955,10465956,10465957,10465958,10465959,10465960,10465961,10465962,10465963,10465964,10465965,10465966,10465967,10465968,10465969,10465970,10465971,10465972,10465973,10465974,10465975,10465976,10465977,10465978,10465979,10465980,10465981,10465982,10465983,10465984,10465985,10465986,10465987,10465988,10465989,10465990,10465991,10465992,10465993,10465994,10465995,10465996,10465997,10465998,10465999,10466000,10466001,10466002,10466003,10466004,10466005,10466006,10466007,10466008,10466009,10466010,10466011,10466012,10466013,10466014,10466015,10466016,10466017,10466018,10466019,10466020,10466021,10466022,10466023,10466024,10466025,10466026,10466027,10466028,10466029,10466030,10466031,10466032,10466033,10466034,10466035,10466036,10466037,10466038,10466039,10466040,10466041,10466042,10466043,10466044,10466045,10466046,10466047,10466048,10466049,10466050,10466051,10466052,10466053,10466054,10466055,10466056,10466057,10466058,10466059,10466060,10466061,10466062,10466063,10466064,10466065,10466066,10466067,10466068,10466069,10466070,10466071,10466072,10466073,10466074,10466075,10466076,10466077,10466078,10466079,10466080,10466081,10466082,10466083,10466084,10466085,10466086,10466087,10466088,10466089,10466090,10466091,10466092,10466093,10466094,10466095,10466096,10466097,10466098,10466099,10466100,10466101,8563524,8563544,10468491,10468492,10468493,10468494,10468495,10468496,10468497,10468819,10628007,10628008,10628009,10628010,10628151,10628451,10628453,10627278,10627279,10627280,10627281,10627282,10627283,10627284,10627285,10627286,10627287,10627288,10627289,10627290,10627291,10627292,10627293,10627294,10627336,10627501,10627502,10627503,10627504,10627505,10627506,10627507,10627508,10627509,10627510,10627511,10627512,10627513,10627514,10627663,10627744,10627764,10626436,10626437,10626502,10626505,10567448,10420334,10420643,10420718,10420719,10420720,10420721,10420722,10420723,10420724,10420725,10420726,10420727,10420728,10420729,10420730,10420731,10420732,10420733,10420734,10420735,10420736,10420737,10420738,10420739,10420740,10420741,10420742,10420743,10420744,10420745,10420746,10420747,10420748,10420749,10420750,10420751,10420752,10420753,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10420768,10420769,10420770,10420771,10420772,10420773,10420774,10420775,10420776,10420777,10420778,10420779,10420780,10420781,10420782,10420783,10420784,10420785,10420786,10420787,10420788,10420789,10420790,10420791,10420792,10420793,10420794,10420795,10420796,10420797,10420798,10420799,10420800,10420801,10420802,10420803,10420804,10420805,10420806,10420807,10420808,10420809,10420810,10420811,10420812,10420813,10420814,10420815,10420816,10420817,10420818,10420819,10420820,10420821,10420822,10420823,10420824,10420825,10420826,10420827,10420828,10420829,10420830,10420831,10420914) 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'