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(10939588,7075976,7068137,9214822,11001876,9214855,9214856,9215002,10870677,10870678,10870679,10870680,10870681,10870682,10870683,7076406,10459018,8631161,7068536,4970852,9215412,11041458,10976487,3229278,8631589,10963630,8631593,8631594,10963633,8631595,8631596,8631597,8631598,8631599,8631600,8631601,8631602,8631603,8631604,8631605,8631606,8631607,8631608,8631609,8631610,8631611,9215665,9215666,9215758,8631779,7066396,7066398,10951129,8632417,9216441,7066798,7066799,7066800,7066801,8632484,8632485,8632486,8632487,8632488,8632489,8632515,8632545,8632546,8632559,8632560,10844716,8067930,8629690,8629691,8629692,8629693,8629842,8629844,8630172,8630173,8630225,9214292,9214293,8620536,9214393,9214399,9214400,8838241,8838242,9214409,8630404,8630405,10962447,9214419,9214423,9214424,8630432,9214440,9214444,10939429,9214475,9214476,9214477,9214507,9214511,10962543,10962544,10962545,10962546,10962547,10962548,7201259,7201260,7201261,10103160,8594696,8594697,7201344,3238539,10842910,7064262,3238790,10960088,8835912,7064500,8559533,7201833,7201834,7201860,10843447,10843459,8628353,8628354,8628355,8628356,10843474,10999422,10999423,10103964,7202163,8628584,7202201,7202202,7202203,8628607,8628672,8628673,8628674,8628675,8628676,8628677,8628678,8628679,8628680,8628681,8628682,8628683,8628684,8628685,8628686,8628687,8628688,8628689,8628690,8628691,8628692,8628693,8628694,8628695,8628696,8628697,8628698,8628699,8628700,8628701,8628702,8628703,8628704,8628705,8628706,8628707,8628708,8628709,8628710,8628711,8628712,8628713,8628714,8628715,8628716,8628717,8628718,8628719,8628728,7073161,10867458,10867459,8628902,8628903,8628904,10867692,10867707,10867708,10844217,10844218,10844259,9794588,8629221,7073603,10844355,10844452,10844454,10844455,8629392,8629393,8629394,8629395,8629396,8629397,8629398,8629399,8629400,8629471,10102091,8616849,8616850,8616851,8616852,8626698,8626703,8626704,8626707,8626735,8626736,8626737,8626738,8626739,8626740,3927531,10997862,8626843,8626844,8626845,8626846,8910288,10985150,10985151,10985152,10985153,10985154,10985155,10985156,10985157,10985158,10985159,10985160,10985161,10985162,10985163,10985164,10985165,10985166,10985167,10985168,10985169,10985170,10985171,10985172,10985173,10985174,10985175,10985176,10985177,10985178,10985179,10985180,10985181,10985182,10985183,10985184,10985185,10985186,10985187,10985188,10985189,10985190,10985191,10985192,7201007,10102895,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,10842554,10103012,10103013,10839704,10839824,10100247,10100265,8624810,8624811,10940833,10940834,10940835,10940836,10940837,10940838,10940839,10940840,10940841,10940842,10940843,10940844,10940845,10940846,10940847,10940848,10940849,10940850,10940851,10839995,8556349,8556350,8556351,8556352,8556353,8556354,8556355,8556356,8556357,8556358,8556359,8556360,8556361,8556362,8556363,8615253,8556364,8556365,8556366,8556367,8556368,8556369,8556370,8556371,8556372,7198681,7198690,7069467,7069468,7069469,7069470,7069471,7069472,7069473,7069474,7069475,7069476,7069477,7069478,8625155,8625166,8625167,10941150,8625364,8625366,8625371,3236231,10840673,8625607,10840894,10840925,11035927,11035928,11035929,8616125,10841049,10841050,10841064,8557261,8626084,10101601,8626126,8626198,11048567,8626394,10101998,3927276,3927277,3927279,7196217,3233461,3233462,3233463,8613010,8613011,10967900,10967959,10967960,10967961,10967962,10967963,11046114,8554632,10968398,7196981,10968423,10968424,10968425,10968426,10968427,10968428,11007802,8614295,8614296,8614297,8614298,8614299,8614300,8614301,8614302,8614303,8614304,8614305,8614306,8614307,10839238,10839239,10839240,8624406,8624433,8624434,10839637,8634615,8634616,8634617,8634624,8634625,8634626,8634627,8634628,8634629,8634630,8634631,3232405,8634632,3232406,8634633,3232407,3232408,3232409,3232410,3232411,3232412,3232413,3232414,3232415,3232416,3232417,3232418,3232419,3232420,3232421,3232422,3232423,3232424,3232425,3232426,3232427,3232428,3232429,3232430,3232431,3232432,3232433,3232434,3232435,3232436,3232437,3232438,3232439,3232440,3232441,3232442,3232443,8634670,3232444,8634671,3232445,8634672,3232446,3232447,3232448,3232449,3232450,3232451,3232452,3232453,3232454,8541548,3232455,3232456,3232457,3232458,3232459,3232460,3232461,3232462,3232463,3232464,3232465,3232466,3232467,3232468,3232469,3232470,3232471,3232472,3232473,3232474,3232475,3232476,3232477,3232478,3232479,8611952,8611953,10622217,10966878,10966879,10966880,10622224,10622225,10622235,8634952,10837424,10837425,8542282,8542283,8579110,8579111,8579112,8632590,8632591,8632592,8632593,8632594,8632595,8570020,3230463,3230464,10620107,10620122,10620123,10620124,10620125,10620126,10620127,10620133,10620134,10615179,8632852,10615271,8632908,8632909,8632910,10848233,8633134,10848305,10848306,10848307,10848308,10848309,10848310,3231088,10965390,8633509,8633510,8633511,8633512,8633513,8633514,8633515,8633516,8633517,8633518,8633519,8633520,8633521,8633522,8633523,8633524,8633525,8633526,8633527,8633528,8633529,8633530,8633531,8633532,8633533,8633534,8633535,8633536,8633537,8633538,8633539,8633540,8633541,3231384,10621051,10621052,3231695,8540877,8634432,8541338,8634559,3654852,3654853,3654854,9189835,6670232,6670233,10614857,10122409,10122410,8851230,8851261,9187442,8851327,8851372,8851401,8851475,8851501,10612356,8851544,7057913,9211773,9211774,8862698,9172322,9172323,3653575,3653623,9914642,10610697,3654314,3654315,8567732,8853077,9173254,9161328,9185362,10515311,7055846,8592859,10517753,6674731,2809379,8850688,9170866,8850725,8850742,8850768,8850815,8850817,8850966,8851008,9176357,9176365,9176366,9176367,6680970,9209162,10122496,9182529,9182530,9182531,9182532,9182533,9182534,9182535,9182536,9182537,9182549,6671020,6671154,6671157,6671159,6671160,8916902,9207304,6671529,8917224,8917225,8917226,8917227,9191765,9176202,9176276,10883552,10904084,10170720,10176173,10176174,10186200,10186202,10186203,10186204,10186205,10186211,10186212,10632166,10164016,10627720,10893372,10893373,10161870,10161872,10161874,10161875,10172270,10891375,10891376,10631058,10626432,10626433,10626434,10626435,10163289,10650067,10606826,10648234,10582190,10579481,10525315,10525316,10525317,10525318,10525319,10525320,10525321,10528453,10522890,10420244,10420245,10422315,10422316,10422317,10422318,10422319,10422320,10422321,10420433,10420436,10507802,10484035,10486558,10477598,10482173,10714970,10714971,10480691) 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'