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(8630681,8630792,8630874,8630881,8630884,8630907,10861669,10861833,10861836,10861837,10940225,8631644,8631645,8631646,8631647,8631648,8631649,8631650,8575209,10868458,8632498,8632499,8632520,10869186,10869188,10869190,10869193,8632575,10869283,10869422,10860472,7067196,11001140,8630481,8630496,8630504,8630506,8835426,7201374,8594779,10866553,10866595,10866596,10866597,10866598,10866599,10866600,10866601,10843156,8628051,8628079,8628080,8628092,10999132,7201890,10960382,8628422,7202072,7202392,8628795,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,8628873,5654627,5654649,8629016,10867702,10867703,10867706,8629254,8629255,8629256,8629258,8629259,8629260,8629265,10844507,10844515,10844516,10844528,10865403,10959092,7200731,10959189,7200787,10857934,10857936,8624584,8624655,8624725,8624744,10995822,10863529,10863536,10863546,10863547,10863548,10863549,10863550,10863551,10863552,10863553,10863554,10863555,10863556,10863557,10863558,10863559,10863560,10863561,10863562,10863563,10863564,10863565,10863566,10863567,10863568,10863569,10863570,10863571,10863572,10863573,10863574,10863575,10863576,10863577,10855578,10863578,10863579,10863580,10863581,10863582,10863583,10863584,10863585,10863586,10863587,10863588,10863589,10863590,10863591,10863592,10863593,10863594,10863595,10863596,10863597,10863598,10863599,10863600,10863601,10863602,10863603,10863604,10855604,10863605,10863606,10863607,10863608,10863609,10863610,10863611,10863612,10863613,10863614,10863615,10863616,10863617,10863618,10863619,10863620,10855620,10863621,10855621,10863622,10863623,10863624,10863625,10863626,10863627,10863628,10863629,10863630,10863631,10863632,10863633,10863634,10863635,10863636,10863637,10863638,10863639,10863640,10863641,10863642,10863643,10863644,10863645,10863646,10863647,10863648,10863649,10863650,10863651,10863652,10863653,10863654,10863655,10863656,10863657,10863658,10863659,10863660,10863661,10863662,10863663,10863664,10863665,10863666,10863667,10863668,10863669,10863670,10863671,10863672,10863673,10863674,10863675,10863676,10863677,10863678,10863679,10863680,10863681,10863682,10863683,10863684,10863685,10863686,10863687,10863688,7198713,7198738,7198762,8625216,8908708,8908709,8908758,8626028,8626029,8626030,8626031,8626032,8626120,11048460,11048461,11048462,8557580,10857057,11045721,10837985,10967930,10853646,8070134,8070136,8070139,11046089,11007151,8070224,8070225,10838516,10838524,10838525,8554723,10838534,11007736,11007737,10838922,10838973,7197556,7197557,7197709,10624548,8907595,7197802,10995370,3235171,10855063,10855064,10855065,11047466,11047477,11047478,8905252,8541714,8541715,10617322,10617361,8612409,8612410,3922994,10837367,8609786,8609787,8632735,8632796,8632797,8632798,10615229,10850840,8633250,10620779,10620780,8540566,8540567,10851367,10851466,10616329,10616332,10616333,3231765,3231823,3231922,3231923,8611383,10851975,10851977,10851980,8541212,10427127,8634500,8634501,8634502,8634503,8853208,8853230,8853388,6669823,6669830,9173728,9173729,9173730,10614497,10614498,9214036,8542551,9187423,8542639,7058023,9171917,9172146,10609925,10609926,10609927,9196457,10610233,9188588,10613306,8852480,10610435,7018491,9204948,9197129,10613878,10613879,8863778,6673523,10117529,9177372,9911864,9912193,9912209,9912438,9912457,8850112,8850113,9913360,8848127,8848128,8848130,10427755,10416362,10419480,10419481,10419482,10419483,10419484,10415677,10415680,10418703,10419735,8848739,9160967,8848856,10417063,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,6670852,8550023,8550065,10465771,9175235,10465852,10467871,8563358,8563359,9191468,10464079,10464080,9183530,976358,976377,8847558,9183878,9167993,8848009,10893770,10893771,10628321,10628513,10628534,10884084,10910531,10910537,10900671,10900672,10895766,10895767,10895768,10895769,10630272,10161842,10900920,10886271,10886272,10886273,10626375,10626378,10626379,10887096,10887097,10892180,10892181,10892182,10907298,10887462,10598612,10582561,10579822,10539117,10543984,10421405,10421407,10421410,10420428,10420429,10420432,10421488,10421600,10421001,10425037,10425041,10488242,10483423,10483424,10484511,10484512,10484522,10496938,10496939,10408302,10496985,10478016,10408377,10497041,10412518,10412520,10493302,10408652,10408654,10408657,10410742,10410770,10410783,10410784,10410793,10478849,10478850) 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'