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(9214639,3228940,8631278,8631279,8631280,8631281,8631282,8631283,8631284,8631285,10846476,3229279,9215620,10849524,10849535,7074370,8622293,10962503,8627584,8627585,8627586,8627587,8627588,8627589,8627590,8627591,8627592,8627593,8627594,8627595,8627596,8627657,8627658,8627659,8627660,8627661,8627662,8627663,8627664,8627665,8627666,8627667,8627668,8627669,8627670,8627671,8627672,8627673,8627674,8627675,8627676,8627677,8627678,8627679,8627680,8627681,8627682,8627683,8627684,8627685,8627686,8627688,8627689,8627690,8627691,8627692,8627693,8627738,8627740,8627742,8627743,8627745,8627748,8627750,8627752,8627753,8627755,8627757,8627758,8627760,8627761,8627763,8627764,8627765,8627766,8627767,8627768,8627770,8627771,8627772,8627774,8627775,8627777,8627778,8627779,8627780,8627781,8627782,8627783,8627784,8627865,8627983,8627984,8627985,8627986,8627987,8627988,8627989,8627990,8618688,10104059,10104068,8559957,5654577,5654578,5654579,5654580,11039012,11039013,11039014,9794575,9794576,3927364,3927369,3237407,8627211,8627212,8627213,8627214,8627215,8627216,8627217,8627218,8627219,8627220,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627461,8627462,8627463,8908201,8908202,8908204,8908206,8908207,8908208,8908210,8908211,8908212,8625106,10855899,10855900,10855901,10855902,10855903,10855904,10855905,10855906,10855907,10855908,10855909,10855910,10855911,10855912,10855913,10855914,10855915,10855916,10855917,10855918,10855919,10855920,10855921,10855922,10855923,10855924,10855925,10855926,10855927,10855928,10855929,10855930,10855931,10855932,10855933,10855934,10855935,10855936,10855937,10855938,10855939,10855940,10855941,10855942,10855943,10855944,10855945,10855946,10855947,10855948,10855949,10855950,10855951,10855952,10855953,10855954,10855955,10855956,10855957,10855958,10855959,10855960,10855961,10855962,10855963,10855964,10855965,10855966,10855967,10855968,10855969,10855970,10855971,10855972,10855973,10855974,10855975,10855976,10855977,10855978,10855979,10855980,10855981,10855982,10855983,10855984,10855985,10855986,10855987,10855988,10855989,10855990,10855991,10855992,10855993,10855994,10855995,10855996,10855997,10855998,10855999,10856000,8615562,11035972,11035973,11048373,11048374,11048375,11048376,11048377,11048378,3923770,11007123,11007124,8906913,10838753,7197605,7197606,7197607,7197608,7197609,7197610,7197611,7197612,7197613,7197614,7197615,7197616,7197617,7197618,7197619,7197620,7197621,7197622,7197623,7197624,7197625,7197626,7197627,7197628,7197629,7197630,7197631,7197632,7197633,7197634,7197635,7197636,7197637,7197638,7197639,7197640,7197641,7197642,7197643,7197644,7197645,7197646,7197647,7197648,7197649,7197650,7197651,7197652,7197653,7197654,7197655,7197656,7197657,7197658,7197659,7197660,7197661,7197662,7197663,7197664,7197665,7197666,7197667,7197668,7197669,7197670,7197671,7197672,7197673,7197674,7197675,7197676,7197677,7197678,7197679,7197680,7197681,7197682,7197683,7197684,7197685,7197686,7197687,7197688,7197689,7197690,7197691,7197692,7197693,7197694,7197695,7197696,7197697,7197698,7197699,7197700,7197701,7197702,7197703,7197704,7197705,7197706,7197707,7197708,7197709,7197710,7197711,7197712,7197713,7197714,7197715,7197716,7197717,7197718,7197719,7197720,7197721,7197722,7197723,7197724,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,3234982,3234983,3234984,10621982,10622029,8634670,8634671,8634672,10622053,10922564,10622054,10922579,10922621,10922622,10922623,10622130,8611943,8905204,8905205,8905206,8905207,8905208,8905209,8905210,8905211,8905212,8905213,8905214,8905215,8905216,8905217,8905218,8905219,8905220,3232804,10848198,10615548,8540644,8540877,9218122,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10610995,10610997,10614199,8853482,8853510,8853524,8853527,8853531,8853534,8853536,8853537,8853541,8853546,8853548,9166150,10609387,8862503,10612916,9172274,10610167,10610168,10120775,9204790,9204791,10610854,10515162,10117611,10117612,10117613,10117614,10117615,10117616,8849315,8849335,8849336,8849349,8849350,6673732,8849354,8849366,8849367,8849373,8849374,8849375,8849376,8849379,8849425,8849426,8849427,8849428,8849429,8849430,7055840,7055841,7055842,8849523,8849524,4974715,4974716,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,8849700,8849701,4974730,8849702,4974731,4974732,4974733,4974739,8849750,8849751,8849752,8849779,8849785,8849786,8849890,8849891,8849898,8849899,8849900,8849910,8849911,8849914,8849915,8849924,8849925,8849926,8849932,8849933,8849934,8849936,8849953,8849954,8849957,8849958,8849968,8849969,8849974,8849999,8850021,8850025,8850033,8850035,8850036,8850041,8850352,8850353,8850354,8850355,8850356,8850357,8850358,8850359,8850360,8850361,8850362,8850363,8850364,8850365,8850366,8850367,8850368,8850369,8850370,8850371,8850372,8850373,8850374,8850375,8850376,8850377,8850378,8850379,8850380,8850381,8850382,8850383,8850384,8850385,8850386,8850387,8850388,8850389,8850390,8850391,8850392,8850393,8850394,8850395,8850396,8850397,8850398,8850399,8850400,8850401,8850402,8850403,8850404,8850405,8850406,8850407,8850408,8850409,8850410,9912884,8848134,8918227,8848699,8848700,8848704,8848710,8848711,8848713,8848778,8848779,8848780,8848787,8848788,8848836,6681221,8848859,8848862,8848892,8848893,10117479,8568910,8568911,8568912,8563209,10467952,10467953,10467954,10467955,10467956,10467957,10467958,10467959,10467960,10467961,10467962,10467963,10467964,10467965,10467966,10467967,10467968,10467969,10467970,10467971,10467972,10467973,10467974,10467975,10467976,10467977,10467978,10467979,10467980,10467981,10467982,10467983,10467984,10467985,10467986,10467987,10467988,10467989,10467990,10467991,10467992,10467993,10467994,10467995,10467996,10467997,10467998,10467999,10468000,10468001,10468002,10468003,10468004,10468005,10468006,10468007,10468008,10468009,10468010,10468011,10468012,10468013,10468014,10468015,10468016,10468017,10468018,10468019,10468020,10468021,10468022,10468023,10468024,10468025,10468026,10468027,10468028,10468029,10468030,10468031,10468032,10468033,10468034,10468035,10468036,10468037,10468038,10468039,10468040,10468041,10468042,10468043,10468044,10468045,10468046,10468047,10468048,10468049,10468050,10468051,10468052,10468053,10468054,10468055,10468056,10468057,10468058,10468059,10468060,10468061,10468062,10468063,10468064,10468065,10468066,10468067,10468068,10468069,10468070,10468071,10468072,10468073,10468074,10468075,10468076,10468077,10468078,10468079,10468080,10468081,10468082,10468083,10468084,10468085,10468086,10468087,10468088,10468089,10468090,10468091,10468092,10468093,10468094,10468095,10468096,10468097,10468098,10468099,10468100,10468101,10468102,10468103,10468104,10468105,10468106,10468107,10468108,10468109,10468110,10468111,10468112,10468113,10468114,10468115,10468116,10468117,10468118,10468119,10468120,976427,8847506,10462569,10462571,10462572,10462574,10462575,10462576,6680370,10883691,10883956,10899564,10899936,10879976,10890120,10890121,10882664,10630823,10630843,10630853,10630856,10630865,10630866,10507802,10425090,10425091,10411037,10411038,10411039,10411040,10411041,10411042,10411043,10411044,10411045,10411046,10411047,10411048,10411049,10411050,10411051,10411052,10411053,10411054,10411055,10411056,10411057,10411058,10411059,10411060,10411061,10411062,10411063,10411064,10411065,10411066,10411067,10411068,10411069,10411070,10411071,10411072,10411073,10411074,10411075,10411076,10411077,10411078,10411079,10411080,10411081,10411082,10411083,10411084,10411085,10411086,10411087,10411088,10411089,10411090,10411091,10411092,10411093,10411094,10411095,10411096,10411097,10411098,10411099,10411100,10411101,10411102,10411103,10411104,10411105,10411106,10411107,10411108,10411109,10411110,10407111,10411111,10411112,10411113,10411114,10411115,10411116,10411117,10411118,10411119,10411120,10411121,10411122,10407122,10411123,10411124,10411125,10411126,10411127,10411128,10411129,10411130,10411131,10411132,10411133,10411134,10411135,10411136,10411137,10411138,10411139,10411140,10411141,10411142,10411143,10411144,10411145,10411146,10411147,10411148,10411149,10411150,10411151,10411152,10411153,10411154,10411155,10411156,10411157,10411158,10411159,10411160,10411161,10411162,10411163,10411164,10411165,10411166,10411167,10411168,10411169,10411170,10411171,10411172,10411173,10411174,10411175) 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'