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(8838436,8068873,8068874,8068875,8068876,8068877,8068878,8068879,8068880,10930314,8620990,8620994,8620995,8620996,8620997,8620998,8620999,8621000,8621001,8621002,8621003,8621004,8621005,8621006,8621007,8621008,8621009,8621010,8621011,8621012,8621013,8621014,10846788,8067683,8067684,8067685,8067686,8067687,8067688,8067689,8067690,11039620,11039621,11039622,11039623,11039624,11039625,11039626,11039627,11039628,11039629,11039630,11039631,11039632,11039633,11039634,11039635,8911408,8911409,8911410,8911411,8911412,8911413,8911414,8911415,8911416,8911417,8911418,8911419,8911420,8911421,8911422,8911423,8911424,8911425,8911426,8911427,8911428,8911429,8911430,8911431,8911432,8911433,8911434,8911435,8911436,8911437,8911438,8911439,8911440,8911441,8911442,8911443,8911444,8911445,8911446,8911447,8911448,8559990,8559991,8559992,10104176,10104177,8559993,10104178,10104179,10104180,11039578,11039585,11039586,11039587,11039589,11039590,11039591,11039593,11039594,11039595,11039596,11039597,11039602,11039603,11039608,11039609,11039610,11039611,11039612,11039613,11039614,11039615,11039616,11039617,11039618,11039619,10943036,10943037,10943038,10943039,10943040,11049345,11049346,11049347,3926607,8565303,8565304,8565305,8565306,8565307,8565308,8565309,7157282,7157283,10924969,10924970,10924971,10924972,10924973,10924974,10924975,10924976,10924977,10924978,10924979,10924980,10924981,10924982,10924983,10924984,10924985,10924986,10924987,10924988,10924989,10924990,10924991,10924992,10924993,10924994,10924995,10924996,10924997,10924998,10924999,10925000,10925001,10925002,10925003,10925004,10925005,10925006,10925007,10925008,10925009,10925010,10925011,10925012,10925013,10925014,10925015,10925016,10925017,10925018,10925019,10925020,10925021,10925022,10925023,10925024,10925025,10925026,10925027,10925028,10925029,10925030,10925031,10925032,10925033,10925034,10925035,10925036,10925037,10925038,10925039,10925040,10925041,10925042,10925043,10925044,10925045,10925046,10925047,10925048,10925049,10925050,10925051,10925052,10925053,10925054,10925055,10925056,10925057,10925058,10925059,10925060,10925061,10925062,10925063,10925064,10925065,10925066,10925067,10925068,10925069,10925070,10925071,10925072,10925073,10925074,10925075,10925076,10925077,10925078,10925079,10925080,10925081,10925082,10925083,10925084,10925085,10925086,10925087,10925088,10925089,10925090,10925091,10925092,10925093,10925094,10925095,10925096,10925097,10427385,10427386,10427387,10427388,8578753,8578754,8578755,8578756,8578757,8578758,8578759,8578760,8578761,8578762,8578763,8578764,8578765,8578766,8578767,8578768,8578769,8578770,8578771,8578772,8578773,8578774,8578775,8578776,8578777,8578778,8578779,8578780,8578781,8578782,8578783,8578784,8578785,8578786,8578787,8578788,8578789,8578790,8578791,8578792,8578793,8578794,8578795,8578796,8578797,8578798,8578799,8578800,8578801,8578802,8578803,8578804,8578805,8578806,8578807,8578808,8578809,8578810,8578811,8578812,8578813,8578814,8578815,8578816,8578817,8578818,8578819,8578820,8578821,8578822,8578823,8578824,8578825,8578826,8578827,8578828,8578829,8578830,8578831,8578832,8578833,8578834,8578835,8578836,8578837,8578838,8578839,8578840,8578841,8578842,8578843,8578844,8578845,8578846,8578847,8578848,8578849,8578850,8578851,8578852,8578853,8578854,8578855,8578856,8578857,8578858,8578859,8578860,8578861,8578862,8578863,8578864,8578865,8578866,8578867,8578868,8578869,8578870,8578871,8578872,8578873,10714463,4974809,4974818,4974819,4974820,4974821,4974822,9911170,6681255,6681258,6681259,6681260,6681261,6681262,6681263,6681264,6681265,6681266,6681267,6681268,6681269,8864835,8864836,9206522,9206523,9206524,9206525,9206526,9206527,9206528,9206529,9206530,9206531,9206532,9206533,9206534,9206535,8569093,8569094,8569095,8569096,8569097,8569098,8569099,8569100,8563395,8563396,8563397,8563398,976701,10175046,10175049,10175054,10879886,7001318,7001319,10186704,10186705,10186706,10186707,10186708,10186709,10186710,10186711,10186712,10186713,10186714,10186715,10186716,10186717,10186718,10186719,10186720,10186721,10186722,10186723,10186724,10186725,10186726,10186727,10186728,10186729,10186730,10186731,10186732,10186733,10186734,10186735,10186736,10186737,10186738,10186739,10186740,10186741,10186742,10186743,10186744,10186745,10186746,10186747,10186748,10186749,10186750,10186751,10186752,10186753,10186754,10186755,10186756,10186757,10186758,10186759,10186760,10186761,10186762,10186763,10186764,10186765,10186766,10186767,10186768,10186769,10186770,10186771,10186772,10186773,10186774,10186775,10186776,10186777,10186778,10186779,10186780,10186781,10161885,10161886,10161887,10161888,10161889,10161890,10161891,10161892,10161893,10161894,10161895,10161896,10161897,10161898,10161899,10161900,10161901,10631005,10631006,10631007,10631008,10631009,10631010,10631011,10631012,10653653,10653654,10653655,10653656,10653657,10653658,10653659,10494887,10494888,10494889,10494890,10494891,10494892) 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'