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(8630906,8630907,4970723,4970724,10861712,10861713,10861714,10861715,3228944,3228945,10861823,10861827,3228964,3229057,3229059,3229060,8583475,7066260,3230230,10869298,10869299,10869300,8573340,10860716,10858118,10858119,7201202,7201203,7201204,7201205,7201213,7201214,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,7201223,7201224,7201225,7201226,7201227,7201228,7201229,7201230,7201231,7201232,7201233,7201234,7201235,7201236,7201237,7201238,7201239,7201240,7201241,7201242,7201497,7201503,7201504,7201505,7201506,7201507,7201508,7201636,7201637,7201643,7201663,7201664,7201883,7201884,7202049,7202050,7202052,7202209,7202210,7202299,7202300,7202301,7202302,7202303,7202304,7202305,7202306,7202307,7202308,7202309,7202310,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628827,8628828,8628829,8628830,8628831,8628832,8628833,8628834,8628835,8628836,8628837,8628838,8628839,8628840,8628841,8628889,8628890,8628891,8628892,8628893,8628894,8628895,8628899,8628900,8628901,8628902,8628903,8628904,8628905,8628906,8628907,10859555,8628955,10859605,7202583,8910047,8910048,8910049,8910050,8910051,8910052,8910053,8910054,8910055,8626970,8626971,8626972,8626973,8626974,8626975,8626985,8626989,8626990,8626991,8626992,8626993,8626994,7200625,7200626,7200633,7200787,7200788,7200896,7200897,8910812,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,8624777,8624778,8624779,8624780,8625110,8625111,8625112,8625113,8625127,8625129,10863835,10863836,10863837,10863838,10863839,10863840,10863841,8625237,8625238,8625239,7199002,7199003,7199004,10856247,10856248,10856249,10856250,10856251,10856252,10856253,10856254,10101448,10101449,10101504,10101578,3926877,8860393,8626176,10856942,10856943,10856944,10856945,10856946,10856947,10856948,10856966,10856968,10856970,10856971,10856973,10853667,10853674,10853675,10853676,10853677,10853678,10853679,10853680,10853681,10853682,10853683,10853684,10853685,10853686,10853687,10853688,10853689,10853690,10853691,10853692,10853693,10853694,10853695,10853696,10853697,10853698,10853699,10853700,10853701,10853702,10853703,10853704,10853705,10853706,10853707,10853708,10853709,10853710,10853711,10853712,10853713,10853714,10853715,10853716,10853717,10853718,10853719,10853720,10853721,10853722,10853723,10853724,10853725,10853726,10853727,10853728,10853729,10853730,10853731,10853732,10853733,10853734,10853735,10853736,10853742,10853743,10853757,10853758,10853759,10853760,10853761,10853762,10853763,10853764,11007190,11007198,10854078,10854079,10854080,10854081,10854082,10854083,10854084,10854085,10854086,7197105,7197106,7197107,7197108,7197109,7197110,7197111,7197112,7197113,8070780,8070781,8070782,10838830,8904917,8904918,8904919,8634547,8634548,8634549,8634550,8634551,8634552,8634553,8634554,3232358,8905764,10615117,8632620,8632811,8632812,8632813,8632814,8632815,8632816,8632817,10615398,10615400,10615477,10426204,10426205,8540793,8611389,10616790,10616791,10616905,10616940,10616941,10616942,10616943,10611052,10611053,10611054,10611055,10611056,10611057,10611058,10611059,10611060,10611061,10612206,10119748,10612290,10609375,10609391,10609392,10609393,10609394,10609395,10609396,10609397,10609398,10609399,10609401,10609715,10609716,10609764,10609765,10609766,8852014,8852015,8852016,10612883,10613174,10613275,10613276,10613277,10613278,10613315,10613359,10613803,9169344,9911603,9911604,9911605,9169461,10117696,9169552,10117798,10117860,10117902,9912071,9169943,10118246,10118329,8850066,8850067,8850068,8850069,8850070,8850071,8850094,10118674,9913002,9913033,6672564,10417285,10417286,10417287,10417288,10417289,10417290,10417291,10417292,9168370,9168375,9168405,9168460,9168481,10116718,10116798,10116799,10415583,10415584,10415585,10415586,10116889,10415668,10415672,9168852,9169026,9169114,10117420,10117437,10117438,10117439,10469328,10469329,10469330,10469331,10469332,10469333,10469334,10469335,10469336,8549927,8550045,8550046,10467485,8550167,8550168,8550169,8550170,8550171,8550172,8550173,8550174,8550175,8550176,8550177,8550178,8854913,8854914,8854915,10123512,10115643,10115644,10115704,8550688,9167671,9167672,9167673,9167674,9167675,10468252,9167676,9167677,9167678,9167679,9167680,9167681,9167682,9167683,9167962,9168126,9168127,9168128,10628321,10884126,10884127,10884128,10884129,10884130,10884131,10884132,10884133,10628917,10628918,10628919,10884527,10889756,10887543,10632040,10632041,10632042,10632043,10632044,10632045,10632046,10632047,10887558,10632048,10632049,10632050,10632051,10632052,10632053,10632054,10632055,10632056,10887654,10882938,10627712,10883245,10888435,10888436,10888437,10161773,10886051,10886052,10886053,10886054,10886055,10886056,10886057,10886058,10886059,10886060,10886061,10886062,10886063,10886064,10886065,10626296,10887186,10887187,10887189,10882421,10882422,10882423,10882424,10882425,10882426,10882427,10882428,10882429,10882430,10882431,10882432,10882433,10882434,10882435,10882436,10882437,10647272,10546759,10421502,10421503,10421504,10508450,10508553,10507555,10507918,10411335,10411336,10411337,10411338,10411339,10411340,10411341,10409685,10409692,10409693,10409694,10409695,10409696,10409697,10409698,10409699,10409700,10409701,10409702,10409703,10409704,10409705,10409706,10409707,10409708,10409709,10409710,10409711,10409712,10409713,10409714,10409715,10409716,10409717,10409718,10409719,10409720,10409721,10409722,10409723,10409724,10409725,10409726,10409727,10409728,10409729,10409730,10409731,10409732,10409733,10409734,10409735,10409736,10409737,10409738,10409739,10409740,10409741,10409742,10409743,10409744,10409745,10409746,10409747,10409748,10409749,10409750,10409751,10409752,10409756,10409757,10411837,10409877,10409878,10409879,10409880,10409881,10409882,10409883,10409884,10409885,10413994,10414041,10414951,10414952,10414953) 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'