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(8068818,8068821,10930136,10930139,10939586,10845749,10845758,10845759,10845763,10870497,10870506,10870513,9214979,9214980,10870616,3228852,10950295,7073842,7073843,8066954,10849582,10849583,10849584,10849663,10847133,10847134,10847135,10847136,10847137,10847138,10847139,10847140,10847141,10847142,10847143,10868809,7066523,8583993,10868820,10868839,10964350,10844823,10872382,10872389,10844964,7067257,4430441,4430457,10102980,6000198,6000199,10866207,8617759,11011854,11011855,11011856,11011857,11011858,11011859,11011860,11011861,7072204,8835740,8835743,8835744,8835769,8835795,8559324,8559325,10999064,10843222,10866771,10866772,10843259,8559545,10986294,10986295,10986296,10986297,10986298,10986299,10986300,10986301,10986302,10986303,10986304,10986305,10843390,8595318,10843718,10999663,10999664,10960840,10960841,10960842,10960843,10960844,8595887,8837018,10844323,10844501,10942594,11010600,11010601,11010602,11010603,11010604,7071227,7071228,3927721,8834832,10102885,4430423,10863127,3925509,3925510,10995880,10995881,10995882,7198463,10996184,11035187,11035188,11035189,10996189,10996190,10996191,10996192,10996211,7198772,10996212,10996213,10996228,10996229,10996241,10996242,10996247,10996277,10996278,10996282,10996304,8615459,8615462,8615463,7198902,10970482,10970483,10864156,8909087,8909088,7070074,10864416,8557300,8557301,10942088,11036141,10942308,10857038,10928632,8612816,11045764,10928740,11045842,11045848,10618318,11045862,11032944,11033082,11033083,11033084,11033085,11033086,11033087,11033088,11007121,10994169,10994170,10994171,11007176,11007177,11007178,10994182,10994192,10994193,10994194,10994195,10968248,11033286,11033287,11033288,11033289,11033290,11033291,11033292,11033293,11033294,11033295,11046647,10838775,10838777,8613965,3234633,3234635,10995127,10995128,10995129,10995130,10995131,10995132,10995133,10995134,10995135,10995136,10995137,10995138,10995144,10995145,10995146,10995147,10995148,3235016,10622000,10622001,10622002,10622003,10953620,11044640,10966722,8541799,10951599,10951627,10951628,10951629,10951630,8570030,8570131,10850673,10850685,10926129,3231073,10965365,11004685,11004686,11004687,11004688,11004706,11004707,11004708,10952668,8540630,8540718,11005074,10927437,8541311,8541313,8567847,8567852,8567853,8567854,6677759,6677760,6677761,6677762,6677763,6677764,6677765,6677766,6677767,6677768,6677769,10614250,9189588,9213596,10614261,3654826,3654829,8568138,9213644,3654880,3654881,3654882,3654883,3654884,9173709,8864236,8864237,6665760,9197770,9197779,10714293,10559753,10559754,8853818,8853819,10122389,10122391,10122392,10122393,9187308,9187309,9187310,9187313,9187314,9187329,7057653,9211513,10612190,7057717,10609240,10563573,9195887,9195901,9195955,9195960,9212094,9212110,9188175,9188176,9188177,9188178,9188179,9188180,9188187,9188188,9188189,9188190,9188228,9172494,9188502,7058802,9188644,9188650,9188651,9188652,9188653,9188665,9188666,10613363,9204901,9204902,9204905,9915116,8567413,6677308,9205130,9915348,8567727,8567729,10515115,10513359,10513360,10513361,10513362,10513363,10513364,10513365,10513366,10513367,10513368,10513369,10513370,10513371,10513372,7055765,9161760,8592903,9193850,9912111,9209950,9169982,10515918,10515919,10515920,10515921,9186201,9194445,9912711,9912712,6674949,6674950,9168358,10419316,10419627,10419628,4973574,10416676,10417727,9169110,10122520,10122521,10122522,10122523,10122588,9190696,9206743,9175538,9175550,976368,9199622,9199626,8917299,8917300,10466252,9175754,9191950,9175966,10174704,10174705,10174706,10883828,10904006,10170140,10170232,10170233,10170277,10170340,10170393,10170466,10170467,10899491,10629236,10629237,10629238,10629257,10629258,10629259,10629260,10629261,10629262,10170891,10170892,10909893,10165906,10909894,10900329,10900330,10900331,10900332,10900333,10900334,10900335,10900336,10900337,10900338,10900339,10900340,10900341,10912497,10912498,10912499,10912500,10912505,10912506,10912507,10912508,10912509,10912510,10912511,10912516,10887526,10908020,10908021,10908022,10908023,10908024,10908025,10908026,10908027,10174085,10908224,10905671,10905672,10905673,10905674,10905675,10905688,10176983,10176984,10167331,10626170,10626178,10631306,10626343,10626507,10626558,10626559,10626736,10601386,10601387,10601388,10601389,10652692,10652693,10652801,10652802,10589875,10602746,10590307,10590610,10590611,10651550,10651551,10651552,10651553,10651554,10600515,10607439,10607440,10607441,10607442,10652070,10652071,10652072,10652073,10652074,10652075,10521187,10521188,10521189,10521196,10543293,10543294,10526058,10526059,10526060,10526061,10526062,10526063,10526064,10526065,10526066,10526067,10526068,10526069,10526070,10526071,10544072,10526072,10544073,10526073,10544074,10526074,10544075,10526075,10544076,10526076,10544077,10526077,10544078,10526078,10544079,10526079,10544080,10526080,10544081,10526081,10544082,10526082,10544083,10526083,10544084,10526084,10544085,10526085,10544086,10526086,10544087,10526087,10544088,10526088,10544089,10526089,10544090,10526090,10544091,10526091,10544092,10526092,10544093,10526093,10544094,10526094,10544095,10526095,10544096,10526096,10544097,10526097,10544098,10526098,10544099,10526099,10544100,10526100,10544101,10526101,10544102,10526102,10544103,10526103,10544104,10526104,10544105,10526105,10544106,10526106,10544107,10526107,10544108,10526108,10544109,10526109,10544110,10526110,10544111,10526111,10544112,10526112,10544113,10526113,10546113,10544114,10544115,10544116,10544117,10544118,10544119,10544120,10544121,10544122,10544123,10544124,10544125,10544126,10544127,10544128,10544129,10544130,10544131,10544132,10544133,10544134,10544135,10544136,10534381,10522519,10522520,10536687,10536688,10536689,10423519,10423525,10422193,10422201,10480971,10480972,10481101,10481102,10481103,10481104,10481105,10481329,10481330,10481331,10481332,10481333,10481507,10481534,10411894,10407934,10407946,10481863,10407211) 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'