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(10861553,3229135,3229136,3229137,3229138,3229139,3229140,3229141,3229142,3229143,3229144,3229145,3229146,3229147,3229148,3229149,3229150,3229151,3229152,3229155,3229156,3229157,3229158,3229159,3229160,3229161,3229162,3229163,3229164,3229165,3229166,3229167,3229168,3229169,8632519,3227580,10929912,10939430,10939431,10939432,8594795,8595180,8595239,8595240,8595241,7201865,7201975,7202296,10859574,3227185,7200470,8834753,7200881,7201108,7201109,7201110,7198758,10864144,10864145,10864146,10864147,10864148,10864149,10864150,10864151,10864152,10864153,10864154,10864155,10864156,10864157,10864158,10864159,10864160,10864161,10864162,10864163,10864164,10864165,10864166,10864167,10864168,10864169,10864170,10864171,10864172,10864173,10864174,10864175,10864176,10864177,10864178,10864179,10864180,10864181,10864182,10864183,10864184,10864185,10864186,10864187,10864188,10864329,7199515,8906021,8906022,8906023,8906024,8906025,8906026,8554338,7196852,7196853,7196854,7196855,7196856,7196857,7196858,7196859,7196860,7196861,7196862,7196863,7196864,7196865,7196866,7196867,7196868,7196869,7196870,7196871,7196872,7196873,7196874,7196875,7196876,7196877,7196878,7196879,7196880,7196881,7196882,7196883,7196884,7196885,7196886,7196887,7196888,10838909,10838910,10617174,3922922,10954408,10615551,10615552,10615553,10615554,10615555,10615556,10615557,10615558,10615559,10615560,10615561,10615562,10615563,10615564,10615565,10615566,10615567,10615568,10615569,10615570,10615571,10851154,10851155,8633952,8904577,8904578,8904579,8904580,8904581,8904582,8904583,8904584,8904585,8904586,8904587,8611405,10611343,8851269,10609239,7017365,7017366,7017367,7017368,7017369,7017370,7017371,7017372,7017373,7017374,7017375,7017376,7017377,7017378,7017379,7017380,7017381,7017382,7017383,7017384,7017385,7017386,7017387,7017388,7017389,7017390,7017391,7017392,7017393,7017394,7017395,7017396,7017397,7017398,7017399,7017400,7017401,7017402,7017403,7017404,7017405,7017406,7017407,7017408,7017409,7017410,7017411,7017412,7017413,7017414,7017415,7017416,7017417,7017418,8862560,8862561,9220277,9220286,9220287,9220288,8852382,8852383,9169544,9169545,9169546,9169547,9169548,9169549,9169550,9169551,6673757,8849729,8849730,8849731,8849732,8849733,6674163,9161964,10118405,10118406,10118407,10118408,10118409,10118410,10118411,10118412,10118413,10118414,10118415,10118416,10118417,10118418,10118419,10118420,8850631,8850673,9913080,9913081,9913082,8850916,8542438,8542439,10415450,10417502,10417503,10417504,10417505,10417506,10417507,10417508,10417509,10417510,10417511,10417512,10417513,10417514,10417515,10417516,10417517,10417518,10417519,10417520,10417521,10417522,10417523,10417524,10417525,10417526,10417527,10417528,10417648,9169089,976565,10464387,10464388,10464389,10464390,10464391,10464392,10464393,10464394,10464395,10464396,10464397,10464398,10464399,10464400,10464401,10464402,10464403,10464404,10464405,10464406,10464407,10464408,10464409,10464410,10464411,10464412,10464413,10464414,10464415,10464416,10464417,10464418,10464419,10464420,10464421,10464422,10464423,10464424,10888606,10888607,10888608,10888609,10888610,10888611,10888612,10888613,10888614,10888615,10888616,10888617,10888618,10888619,10888620,10888621,10888622,10888623,10888624,10888625,10888626,10888627,10888628,10888629,10888630,10888631,10888632,10888633,10888634,10888635,10888636,10155733,10155734,10890030,10877588,10877589,10877590,10877591,10877592,10877593,10877594,10877595,10877596,10877597,10877598,10877599,10877600,10877601,10877602,10877603,10877604,10877605,10882900,10887952,10883430,10602222,10644514,10607013,10604646,10604647,10604648,10604649,10604650,10604651,10604652,10604653,10604654,10604655,10604656,10604657,10604658,10604659,10604660,10604661,10604662,10604663,10604664,10604665,10604666,10604667,10604668,10604669,10604670,10604671,10604672,10604673,10604674,10604675,10604676,10604677,10604678,10604679,10604680,10604681,10604682,10604683,10604684,10604685,10604686,10604687,10604688,10604689,10604690,10604691,10604692,10604693,10604694,10604695,10604696,10604697,10604698,10604699,10604700,10604701,10604702,10604703,10604704,10508440,10508441,10508442,10508443,10508444,10508445,10414012,10414013,10408182) 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'