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(10939876,8574474,8574495,8574526,3229013,3229014,3229015,3229016,10846506,10871050,10862092,10862111,9215628,10868263,10868264,8583488,10849477,10849491,10849492,8583750,10862623,8632080,8632081,8632088,8632089,8632108,8632109,8632110,8632120,10964583,8561187,10860581,10860592,10860593,10860597,8629986,10860730,8620631,10870114,8627745,8627783,10866452,8628073,8628084,8595113,8595115,8595116,8595260,10104031,10859553,10859554,10859555,10932799,10932801,10932802,10932803,10932820,7202769,10932917,8560524,10932932,10857261,10857262,11036707,11036711,11036712,11036714,11036715,11036716,7200543,11037002,8558349,11037113,11037128,11037129,11037135,8064474,8064475,10855412,10863558,10863577,10863578,10863614,10863615,10863616,10863617,10863618,10863619,10863620,10863621,10863622,10863623,10863624,10863625,10863626,10863627,10863628,10863629,10863630,10863631,10863632,10863633,10863634,10863635,3235817,3235818,8908470,7198684,7198727,7198729,7198730,7198737,7198743,7198748,7198751,7198762,7198765,7198766,10996290,10996295,10996299,10996305,8625409,8625410,3656698,8565233,8565234,8565235,8565236,10997538,7196203,7196210,7196434,7196435,7196440,10967896,10623315,10853646,8554375,7157017,7157018,7196897,7196898,7196918,7196951,7196972,8613583,8906885,8906891,10854263,10838834,3234547,10838983,10838987,8555277,3234971,8624504,8634779,8634906,10852573,10852575,10852587,10852591,10617348,10617349,10617427,3232903,8905717,10853147,10951701,10951702,10951703,10620108,10615340,10850743,10850751,3581902,10952301,10952313,10952314,10851042,10851043,10952581,10616030,8540589,8540591,8633978,8611458,10992322,10992323,8577911,10922285,10922286,10922287,3232185,8577968,8577969,8577970,8577971,10852120,10852126,8634545,10922441,10922442,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10922451,9205343,9205344,9205346,8853317,8853320,8853331,8853332,8853342,8853343,8853354,8853361,8853387,8853388,8853390,10611479,9173981,9174050,9174051,9174065,9174076,9174088,10612050,8851442,8851443,8851444,7017940,10610104,10613144,10613147,10613148,10613149,7058800,7018617,9189013,10613818,9205287,6673552,6673763,7015284,9185809,4974715,4974716,4974717,4974718,10118062,4974719,4974720,4974721,4974722,4974723,4974724,4974725,4974726,4974727,4974728,4974729,4974730,4974731,4974732,4974733,4974734,4974735,4974736,4974737,4974738,4974739,4974740,4974741,4974742,4974743,4974744,9912469,9912470,8850095,8850836,8850837,8850844,9913354,8851104,10415599,10415600,9168816,10415794,10415795,10419821,6681111,6681146,6681147,9185131,10417103,10417104,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,8568847,8568851,8568864,8568865,8568866,8568871,7020034,8568910,8568911,8568912,8568913,10467104,10467136,10467143,10467146,9916922,10463394,10463395,8550063,7020566,10463662,10463748,10463752,10463755,10463756,10463768,10463771,10465771,10465773,10465774,10465775,10465778,10465779,10463795,10465798,9175223,10463804,10465842,9175275,10465852,10465855,10465857,9175289,9175290,10465878,10465879,8563204,10465886,10465892,10463905,10463915,10463916,10463917,10463918,8855259,10464041,10464045,9207667,9191735,10466313,10466314,10466315,10466337,10466338,10466358,10466359,10466377,10466391,10466393,8550974,8550975,8550976,10466399,10466400,10466425,10466426,10462447,10462456,9175885,9175895,10462484,10462520,10462536,10462615,10462724,10884082,10890104,10890133,10890134,10890138,10887557,10627129,10627133,10163786,10184013,10184014,10184015,10883045,10885564,10905692,10905693,10905694,10905695,10905701,10905702,10905703,10630240,10630241,10630242,10886093,10886209,10886210,10187581,10172899,10167969,10168028,10168050,10950079,10907401,10608091,10580257,10580350,10580363,10580364,10580365,10580366,10580367,10643469,10590266,10590267,10603692,10651687,10545356,10545357,10545358,10547080,10547081,10547082,10547083,10422597,10420861,10420862,10506824,10506825,10422001,10507938,10508036,10409352,10409651,10477387,10407800,10411955,10490629,10413992,10413993,10413994,10407998,10408004,10410024,10473697,10473698,10473699,10473700,10473701,10473702,10473703,10473704,10473705,10414062,10408159,10408160,10474001,10414686,10410698,10410706,10410707,10410720,10410735,10408768,10408774,10414839,10414840,10414844,10715151,10476514,10414963,10409028,10409031,10409045,10409046,10407064,10407077,10407078) 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'