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(10861555,10861556,10861557,10861558,10861559,10861560,10861561,10861562,10861563,7066166,7066168,7066208,10862924,8632424,8632425,8632426,8632427,8632428,8632429,8632546,8629790,10860985,10860988,10860992,10860996,10866234,7201196,10866250,7201451,7201452,10866517,7201614,7201615,8595189,8595190,8595246,8595247,8595248,8595249,8595250,7201861,7201862,8628265,8065848,7202699,7200486,7200487,7200488,8834755,10866152,10866153,10855534,10855536,10855537,10855538,10855540,10855541,10855542,10855543,10855544,10855547,10855548,10855549,10855557,10855558,10855559,10855560,10855561,10855562,10855563,10855564,10855565,10855566,10855568,10855569,10855570,10855571,10855572,10855573,10855574,10855575,10855576,10855620,10855621,10855622,10855623,10855624,3235763,7198887,7199175,7199176,7199177,7199178,7199526,7199527,7199528,7199529,7199530,7199531,7199532,7199533,7199534,7199535,7199536,7199537,7199538,7199539,7199540,7199541,7199542,7199543,7199544,7199545,7199546,7199547,7199548,7199549,7199550,7199551,7199552,7199553,10856620,10101505,10101570,10864741,10864742,10864743,10864744,10864745,10864746,10864747,10864748,10864749,10864750,10864751,10864752,10864753,10864754,10864755,10864756,10864757,10864758,10864759,10864760,10864761,10864762,10864763,10864764,10864765,10864766,10864767,10864768,10864769,10864770,10864771,10864772,10864773,10864774,10864775,10864776,10864777,10864778,10864779,10864780,10864781,10864782,10864783,10864784,10864785,10864786,10864787,10864788,10864789,10864790,10864791,10864792,10864793,10864794,10864795,10864796,10864797,10864798,10864799,10864800,10864801,10864802,10864803,10864804,10864805,10864806,10864807,10864808,10864809,10864810,10864811,10864812,10864813,10864814,10864815,10864816,10864817,10864818,10864819,10864820,10864821,10864822,7200093,7200130,7200143,7200146,7200148,7200151,8906536,8906537,8906538,8906539,8906540,8906849,8906860,10854324,10854325,10854327,10838912,8624257,7197916,10617035,8905119,8905120,10617343,8905859,8905860,10615147,10615151,10425589,10425590,10615314,10615711,10615712,10615713,10615714,10615715,10615716,10615717,10615718,10615719,10615720,10615721,10615722,10615723,10615724,10615725,10615726,10615727,10615728,10615729,10615730,10615731,10615732,10615733,10615734,10615735,10615736,10615737,10615738,10615739,10615740,10615741,10615742,10615743,10615744,10615745,10615746,10615747,10615748,10615749,10615750,10615751,10615752,10615753,10615754,10615755,10615756,10615757,10615758,10615759,10615760,10615761,10615762,10615763,10615764,10615765,10615766,10615767,10615768,10615769,10615770,10615771,10615772,10615773,10615774,10615775,10615776,10615777,10615778,10615779,10615780,10615781,10615782,10615783,10615784,10615785,10615786,10615787,10615788,10615789,10615790,10615791,10615792,10615793,10615794,10615795,10615796,10615797,10615798,10615799,10615800,10615801,10615802,10615803,10615804,10615805,10615806,10615807,10615808,10615809,10848536,10615810,10615811,10615812,10615813,10615814,10615815,10615816,10615817,10615818,10615819,10615820,10615821,10615822,10615823,10615824,10426404,8540593,8611406,8611407,8611408,8611409,8611410,8611411,8611412,8611413,8611414,8611415,8611416,8611417,8611418,8611419,8611420,8611421,8611422,8611423,8611424,8611425,8611426,8611427,8611428,8611429,8611430,8611431,8611455,10616913,10614048,10611179,10611344,10611345,10611346,10611347,10611348,10614426,10614427,10614428,10614429,10614430,10614431,10614432,10614433,10614434,10614435,10614436,10614437,10614438,10614439,10614637,10614638,10612030,10612033,10612042,10612172,10612173,10612248,10612268,7017419,7017420,8851801,8862564,8862565,10612725,7017785,7017786,7017787,7017788,7017789,7017790,7017791,7017792,7017793,7017794,7017795,7017798,7017799,7017800,10609841,8566712,8566740,8566743,10612929,10612930,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,9196366,9196371,9196372,9196373,8852311,10613305,9914876,8852524,10610365,10610366,10613369,10610902,9169637,9169638,9169639,9169640,10117888,9912025,9169836,9169916,9169917,6674186,6674187,9912225,10118243,6674304,10118494,10118495,10118496,10118629,9912770,9912771,9912772,8552219,9913149,9913150,9913151,9913152,9913153,9913154,9913155,9913156,9913312,10419264,10419265,10419342,10419354,10415451,10415452,10415453,10415454,10415455,10415456,10415457,10415458,10415459,10419463,10416495,10418048,10418049,10418050,10418051,10418052,10418053,10418054,10418055,10418056,10418057,10418058,10418059,10418060,10418061,10418062,10418063,10418064,10418065,10418066,10418067,10418068,10418069,10418070,10418071,10418072,10418073,10418074,10418075,10418076,10418077,10418078,10418079,10418080,10418081,10418082,10418083,10418084,10418085,10418086,10418087,10418088,10418089,10418090,10418091,10418092,10418093,10418094,10418095,10418096,10418097,10418098,10418099,10418100,10418101,10418102,10418103,10418104,10418105,10418106,10418107,10418108,10418109,10418110,10418111,10418112,10418113,10418114,10418115,10418116,10418117,10418118,10418119,10418120,10418121,10418122,10418123,10418124,10418125,10418126,10418127,10418128,10418129,10418130,10418131,10418132,10418133,10418134,10418135,10418136,10418137,10418138,10418139,10418140,10418141,10418142,10418143,10418144,10418145,10418146,9169254,9169255,9169256,9169257,10468901,8549966,8550194,10467816,10467817,10467818,10467819,10470206,10470207,10470208,10470209,10470210,10470211,10470212,10470213,10470214,10470215,10470216,976430,9167975,9167976,9168213,10888815,10888816,10888817,10888818,10888819,10888820,10888821,10888822,10888823,10888824,10888825,10888826,10888827,10888828,10888829,10888830,10888831,10888832,10888833,10888834,10888835,10888836,10888837,10888838,10888839,10888840,10888841,10888918,10888919,10884424,10884587,10884588,10889751,10889842,10889922,10885027,10885028,10885029,10885335,10885336,10885337,10631994,10627142,10627321,10883452,10883453,10883454,10885980,10885981,10885982,10886058,10886059,10886060,10162177,10887161,10887164,10887165,10887389,10887390,10887391,10887392,10887393,10887394,10887395,10887396,10887397,10887398,10887399,10887400,10887401,10887402,10887403,10602393,10602715,10647454,10647544,10647598,10647599,10647600,10647660,10647661,10647662,10647663,10603879,10604067,10607411,10604658,10604659,10508112,10508113,10508114,10508115,10508116,10508117,10508118,10508119,10508120,10508121,10508122,10508466,10507662,10508047,10508048,10508049,10508050,10508051,10508052,10508053,10508054,10508055,10508056,10508057,10508058,10508059,10508060,10508061,10508062,10508090,10508091,10508092,10508093,10508094,10508095,10508096,10508097,10508098,10508099,10508100,10508101,10508102,10508103,10508104,10508105,10508106,10508107,10508108,10508109,10508110,10508111,10410698,10410700,10410701,10410702,10410704,10410705,10410706,10410707,10410708,10410711,10410712,10410713,10410721,10410722,10410723,10410724,10410725,10410726,10410727,10410728,10410729,10410730,10410732,10410733,10410734,10410735,10410736,10410737,10410738,10410739,10410740,10410783,10410784,10410785,10410786,10410787,10415010,10415013,10415017,10415021) 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'