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(8630673,8630682,8630683,8630684,8630717,8630734,8630737,8630742,8630750,8630752,8630860,8630908,8630918,8631034,8631035,8631036,8631039,8631041,8631043,8631045,8631046,8631047,8631050,8631059,8631076,3228908,8631139,8631140,4970714,8631159,8631188,8631194,8631195,8631207,8631210,3228986,3229001,8631244,8631245,8631246,8631247,8631276,8631346,8631347,8583199,8631387,8631392,8631396,8631399,8631404,8631416,8631419,8631425,8631431,8631435,8631440,8631451,8631461,8631469,8631473,8631486,8631489,8631495,8631501,8631503,8631504,8631505,8631506,8631507,8631513,8631517,8631519,8631531,8631536,8631537,8631545,8631546,8631561,8631575,8631576,8631579,8631582,8631691,7066123,8583746,10847287,8632548,8632549,8632550,8632551,8632552,8632553,8632554,8632557,8632558,8629622,8067924,8067925,8629719,8629720,8629721,8629722,8629725,8629726,8629727,8629728,8629729,8629730,8629831,8629832,8629834,8629835,8629836,8629839,8629849,8629850,8629851,8629852,8629853,8629854,8629855,8629856,8629857,8629860,8629861,8629862,8629863,8629864,8629865,8629878,8629879,8629880,8629881,8629891,8629893,8629895,8629907,8629922,8629923,8629926,8629927,8629962,8629963,8629983,8629984,8629985,8630049,8630050,8630052,8630054,8630059,8630060,8630061,8630104,8630106,8630107,8630108,8630109,8630110,8630111,8630117,8630118,8630127,8630155,8630200,8630201,8630227,8630262,8630263,8630418,8630421,8630478,8627585,8627590,8627592,8627596,8627604,8627605,7201216,7201217,8627628,8627633,8627639,8627644,8627649,8627662,8627667,8627672,8627677,8627686,8627692,8627807,8627832,8627839,8627844,8627850,8627855,8627860,8627868,8627871,8627873,8627875,8627892,8627898,8627914,8627923,8627924,8627927,8627947,8627948,8627949,8627950,8627951,8627952,8627954,8627958,8627959,8627962,8627964,8627965,8627968,8627973,8627983,8627987,8627989,7201661,7201662,10960174,8628169,8628170,8911630,10960416,8628387,8628435,8628493,8628503,8628504,8628505,8628506,8628507,8628508,8628510,8628512,8065844,8628514,8628516,8628518,8628520,8628522,8628523,8628524,8628525,8628527,8628528,8628530,8628532,8628539,8628540,8628541,8628542,8628543,8628544,8628548,8628549,8628550,8628576,8628586,7202196,7202197,7202216,7202217,8628618,8628619,8628630,8628631,8628655,8628660,8628692,7202296,7202297,7202298,8572245,8628731,8628785,8628840,8628841,8628844,7202525,7202526,7202657,8629093,8629094,8629095,8629096,8629098,8629099,8629100,8629109,8629111,8629165,8629166,9794592,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629232,8629271,8629275,8629366,8629369,8629370,8629372,8629377,8629400,8629410,8629421,8629442,8629447,8629464,8629562,8629568,8626609,8626613,8626617,7200220,8626628,8626665,8626666,8626667,8626668,8626692,8626696,8626701,8626702,8626715,8626729,8626730,8626756,8626757,8626758,8626759,8626760,8626761,8626762,8626763,8626764,8626765,8626766,8626767,8626768,7200405,8626845,10102355,10102356,10102358,10102359,8626895,8626902,8626907,8626908,8626909,8626910,10958959,8626938,8626939,8626950,8626951,8626952,8627004,8627005,7200633,7200726,7200732,7200737,7200743,10959184,7200747,8627268,8627281,8627305,8627309,8627323,8627332,8627338,8627342,8627344,8627349,8627352,8627354,8627357,8627377,8627381,8627386,8627390,8627392,8627394,8627395,8627397,8627400,8627403,8627407,8627410,8627414,8627418,8627473,8627474,8627475,8627476,8627486,8627499,8627500,8627501,8627502,8627503,8627504,8627505,8627514,8627517,10103013,7201142,8624581,8624582,8624707,7198325,8624726,7198327,8624751,8624788,8615017,8625057,8625116,7198719,8625122,7198732,8625147,8625148,8625151,7198770,8625232,7198849,7199023,8625481,8625482,8625484,8625492,8625504,8625527,8625528,8625572,8625580,8625581,8625598,7199581,7199582,7199583,7199584,7199585,10101491,8626035,8626037,8626053,7199669,11048475,11048476,8626243,8626244,8626245,7199897,10958379,8626373,7199984,8626403,7196187,7196203,7196222,7196376,7196380,7196382,7196418,7196437,7196453,10618304,8906684,7196893,7196901,7196912,7196920,7196936,7196955,7196970,7196984,7196997,7197013,7197044,8906939,7197621,7197663,7197664,3234866,3234984,7197913,8624427,8907855,8624451,10619844,7198066,7198067,7198068,7198069,7198070,8624495,8907909,8624499,8624500,8624510,8624515,7198118,10619905,8624550,8624555,8624556,8624563,7198176,8624580,8905113,8905354,8541833,10622363,10622462,3232886,10622537,8905658,8905826,10614962,10425392,10615079,10425471,10425484,10425485,10425487,10847921,10615202,10425556,10425573,10425579,10425585,10615336,10425911,10965294,10615941,10615960,10615985,10616020,10616021,10616060,8540637,10616193,10426628,10616300,10616372,10616373,10616374,10616645,10616666,10616667,10616668,10427110,7155309,10616866,10616869,10614064,10614083,10614162,10614191,10614194,10614197,10614207,10614210,6669815,6669818,10611315,10611316,10611317,10614581,10614582,10614583,10614632,10611685,10611764,10611788,10611816,10611818,10614822,10611859,10611860,10611878,10611895,10611989,10612075,10612076,7017193,10609203,7017194,7017195,7017196,7017197,7017198,7017199,7017200,7017201,7017202,7017203,7017204,7017205,7017206,10609376,10612533,10612559,10612563,10612623,10612637,10612646,8862530,10612716,10612733,10612734,10612735,10612736,10612767,10609770,10120323,10120325,10120327,10612797,10120338,7017801,7017802,7017803,7017804,10609828,10609829,10612884,8566725,10609916,10609917,10609918,10609919,10609920,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609937,10609939,10609940,10612945,10610006,10613184,10610233,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613305,10613322,10613324,10613342,10613348,10613356,10613357,10613359,10613365,10613366,10613367,10613368,10613369,10610396,10613440,10613442,10610476,10613536,10613537,10610676,10610698,10613744,10610858,10610859,10610865,6673536,10117681,7055652,7055664,7055722,9169559,6673804,9169675,9169676,9169677,9169684,7015410,7015411,7015412,7015413,7015434,7015435,7015436,7015437,9169795,7015462,7015463,7015482,7015483,7015512,7015513,7015524,7015525,7015538,7015539,7015544,7015545,10118095,7015564,7015565,7015566,7015567,7015582,7015583,6674136,7015588,7015589,6674144,7015614,7015615,6674172,7015630,7015631,6674204,6674208,6674214,6674225,6674226,10118223,6674278,6674279,10118308,10118528,7016036,7016037,7016038,7016039,10118601,7016068,7016069,7016070,7016071,7016072,7016073,10118627,7016096,7016097,7016098,7016099,7016116,7016117,10118664,7016128,7016129,9178477,7016140,7016141,9178491,9178493,7016160,7016161,2809285,9168350,10415313,10415314,10418314,6672604,6672711,10415443,6672780,6672781,6672783,6672808,6672911,10416631,10416633,10416635,10418689,10418690,9168800,6673108,9168921,10418864,10418865,6673156,10418909,10415935,9169025,10416988,10416989,6673274,6673300,9169101,10418146,7055450,10117491,10471072,10471103,10469226,8549997,8550210,10465711,4972028,10469876,9167406,6671918,10468347,9167975,10116207,10116208,10116209,10116210,10116211,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,10116221,10116222,10116223,10470665,9168097,10470683,10883555,10883556,10883609,10883610,10883615,10883618,10883619,10883621,10883629,10883657,10888839,10888888,10888920,10883944,10884214,10884215,10889223,10889224,10889230,10889231,10889241,10889264,10889278,10884505,10884506,10889544,10884585,10884600,10889661,10889760,10884770,10884771,10884773,10879870,10890014,10885034,10885078,10885080,10885237,10890242,10880304,10880305,10877477,10877478,10877480,10877483,10877484,10877485,10882539,10887545,10887594,10887623,10627319,10887850,10887994,10887995,10888103,10888129,10888161,10883317,10883325,10885578,10161867,10161931,10162066,10886882,10167914,10886902,10167936,10167937,10167943,10167954,10167957,10167968,10167969,10167971,10167977,10167978,10167983,10167987,10167992,10168007,10168012,10168015,10168025,10168027,10168028,10168046,10168047,10887035,10168056,10887053,10168067,10168072,10877068,10887129,10887130,10887153,10887182,10887204,10887217,10882353,10887357,10589894,10589895,10527917,10527918,10527919,10528350,10522580,10522581,10522582,10422598,10407462,10407928,10407995,10408003,10408046,10408047,10408050,10406917,10406930,10406931,10406932,10406933,10406934,10408975,10408979,10409034,10407057,10409072,10407072,10409073,10409074,10409075,10409076,10409092,10409095) 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'