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(8630951,3229053,7065919,8583432,10862688,10862689,10862690,10862691,10862692,10862694,8629686,10860384,10860950,10866672,10866673,10866674,10866675,10866676,10866677,10866678,10866679,10866680,10866681,10866684,8595045,10866896,10866897,10859141,10859143,7202609,10865381,7200393,7200394,7200395,7200396,7200397,7200558,7200559,7200560,7200561,7200562,7200563,7200564,7200565,7200566,7200923,10865994,10863164,8624724,8624725,10863443,10863444,7198750,7199365,10864491,10864492,10864493,10864494,7199568,7199569,10101457,10101458,3923398,10853354,8554340,8554341,8906550,7197248,8907063,10854414,10854416,10854417,10854418,10854419,10854420,10854421,10854422,10854423,10854424,10854425,10854426,10854427,10854428,10854429,10854430,10854431,10854432,10854433,10854434,10854435,10854436,10854437,10854438,10854439,10854440,10854441,10854442,10854443,10854444,10854445,10854446,10854447,10854448,10854449,10854450,10854451,10854452,10854453,10854454,10854455,10854456,10854457,10854458,10854459,10854460,10854461,10854462,10854463,10854464,10854465,10854466,10854467,10854468,10854469,10854470,10854471,10854472,10854473,10854474,10854475,10854476,10854477,10854478,10854479,10854480,10854481,10854482,10854483,10854484,10854485,10854486,10854487,10854488,10854489,10854490,10854491,10854492,10854493,10854494,10854495,10854496,10854497,10854498,10854499,10854500,10854501,10854502,10854503,10854504,10854505,10854506,10854507,10854508,10854509,10854510,10854511,10854512,10854513,10854514,10854515,10854516,10854517,10854518,10854519,10854520,10854521,10854522,10854523,10854524,10854525,10854526,10854527,10854528,10854529,10854530,10854531,10854532,10854533,10854534,10854557,10854558,10854559,10854560,10854561,10854573,10854574,10854575,10854576,10854577,10854578,10854603,10854604,10854605,10854606,10854610,10854611,10854612,10854613,10854614,10854615,10854616,10854621,10854622,10854623,10854624,10854625,10854626,10854627,10854628,10854629,10854630,10854631,10854632,10854633,10854634,10854635,10854636,10854637,10854638,10854639,10854640,10854641,10854642,10854643,10854644,10854661,10854662,10854663,10854664,10854665,10854666,10854667,10854668,10854669,10854670,10854671,10854672,10854673,10854674,10854675,10854676,10854677,10854678,10854679,10854680,10854681,10854682,10854683,10854684,10854685,10854686,10854687,10854688,10854689,10854690,10854691,10854692,10854693,10854694,10854695,10854696,10854697,10854698,10854699,10854700,10854701,10854702,10854703,10854704,10854705,10854706,10854707,10854708,10854709,10854710,10854711,10854712,10854713,10854714,10854715,10854716,10854717,10854718,10854719,10854720,10854721,10854722,10854723,10854724,10854725,10854747,10854748,10854749,10854750,10854751,10854752,10854753,10854754,10854755,10854756,10854757,10854758,10854759,10854760,10854761,10854762,10854763,10854764,10854765,10854778,10854779,10854780,10854781,10854782,10854783,10854784,10854785,10854786,10854787,10854788,10854789,10854790,10854791,10854792,10854793,10854794,10854807,10854808,10854809,10854810,10854811,10854812,10854813,10854814,10854815,10854816,10854817,10854818,10854819,10854820,10854821,10854822,10854823,10854824,10854825,10854826,10854827,10854828,10854829,10854830,10854831,10854832,10854833,10854834,10854835,10854838,10854839,10854840,10854841,10854842,10854843,10854844,10854845,10854846,10854847,10854848,10854849,10854850,10854851,10854852,10854853,10854854,10854855,8904984,8904985,8904986,8904987,8904988,8904989,8905139,8612185,10622537,10615086,10615087,10615145,8633376,8633377,8633378,10615919,10615920,10616087,10426382,10426383,10426384,10426385,8611449,10614102,10614178,6669783,6669820,10714111,6669910,10614443,10614444,10614445,10614446,10614819,10611959,10611960,10611961,10611962,10612270,7017783,7017784,7017785,7017786,7017787,7017790,10609854,10609855,10609856,10609857,10609859,10609860,10609861,10609862,10609863,10609864,10609866,10609867,10609868,10609869,10609870,10609871,10609873,10609874,10609875,10609876,10609877,10609878,10609879,10609881,10609944,10613026,10613675,10613676,10613677,10613722,10613853,10117496,6673731,9169563,9911811,9911812,9911813,10117836,10117858,10118056,9912204,9912205,9912425,8850106,10118500,10118501,10118502,10118600,9912776,9912777,9912961,8552174,10418300,10418301,6672601,9168489,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419560,10416714,9168799,10419777,10417801,10417802,10417803,10417804,10416979,10416980,10416981,10416982,6670730,10471127,8549937,8549938,8549940,8549941,8549942,8549944,10467606,10467607,10467608,10467609,10467610,10467611,10467612,10467613,10467614,10467840,10469902,10115669,976363,976432,976433,976546,9167831,9167834,9167835,9167836,9167837,10468520,10427632,10888584,10888930,10888933,10889066,10884461,10889664,10884689,10884690,10889758,10889759,10889938,10885338,10885339,10882905,10882906,10882907,10882909,10882910,10882911,10882912,10882913,10882914,10882916,10882921,10882922,10882923,10882924,10882926,10882928,10882929,10882930,10882931,10882932,10887958,10887959,10887960,10887961,10887962,10887964,10887965,10887966,10161822,10162119,10887408,10602694,10647350,10647351,10508449,10413640,10413642,10410134,10410136,10410137,10410138,10410139,10410140,10410141,10412469,10412470) 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'