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(10447782,10447783,10447784,10447791,10447799,10447805,8574198,8574438,7076287,7076289,7076296,8574478,8574498,8574499,8574521,10940222,3228951,3228957,3228960,3229011,3229172,10950529,8583487,8583741,8622251,8067757,10437751,3227256,10929371,10929372,8573309,8573335,10929609,10447544,10962461,10102945,10959562,7201155,7201156,7201384,7201385,10842934,10842952,10843036,10843048,10843049,10843097,10843098,8911413,7201894,7201896,8911744,8836221,8065853,7202078,10999688,10999689,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202346,7202477,7202478,7202479,7202480,7202481,7202482,7202483,5654579,5654581,7073283,7073327,7202597,3227064,3227082,10929083,11010511,11010512,10997538,7200508,10958988,7200558,7200559,7200608,7200615,7200616,8910446,7200639,7200640,7200641,7200642,7200643,8910458,10959087,10959092,10102548,10959188,8835224,11047505,7198385,7198695,7198697,7198699,7198700,7198701,7198710,7198711,7198713,7198714,7198766,7198772,8908752,10941696,10941699,10941700,10941713,10941724,10941725,10941726,10941741,10941752,10941753,10941754,10941756,8909098,10941759,10941762,8909106,10941768,10941775,10941779,10941838,10941849,7199540,7199541,8565097,8860345,8860346,8860419,8860558,8860559,8542366,7196194,7196206,7196213,3233411,3233412,3233413,3233420,10618255,10618256,7196375,10618280,7196436,7196437,7196442,7196444,7196445,7196449,7196454,10838099,11046097,11046098,11046099,10994229,10994230,10994238,8906651,7196900,7196912,7196919,3234097,7196935,3234115,7196953,7196957,7196979,7196980,7196982,10838520,10838529,10838537,7197052,7197072,7197076,8906893,8906894,8906895,8906896,10838972,7197518,10619459,3234743,8907532,7197721,7197799,7197806,7197807,7197808,7197809,7197811,7197814,7197815,7197817,8907644,11047460,11047486,11047488,11047498,11044768,11044769,11044770,10617326,8905255,8905263,10622360,10617367,10617368,10617370,10617371,10617377,10617390,10617391,10617392,10617399,10617400,10617401,10617402,10617406,10617407,10617408,10617424,10617431,10617453,8905383,8905384,8905385,10617511,10993350,10993356,10928352,10993380,10993381,10993412,10993414,10993415,10993416,8609684,10964581,10964606,10951589,10951597,10951603,10425352,10425353,10425360,10951625,10425385,10425389,10425486,10425553,10425568,10425569,10425570,10425572,10425577,10847967,10425587,10991226,10991227,10991228,10991229,10926204,10425932,10425934,10425937,10620769,10620770,10426016,10426153,10991486,10848562,10991494,10991495,10991501,10991505,10991509,10991510,10426199,10965520,10965521,8540351,8540355,8540356,8540362,8540363,8540364,8540365,8540366,8540367,8540368,8540369,8540370,10991580,10991697,8540541,8540542,10991728,10991729,10991731,8540565,8540570,8540571,8540575,8540576,8540577,8540589,8611003,8611004,10616332,10991915,10991916,10991917,10991918,10991919,10991920,10952921,10991926,10991927,10991928,10991929,10991930,10991931,10991932,10991952,10991953,10991954,10991955,10991961,8904348,10991977,10991992,10991995,10991996,10991997,10992002,8611259,8541006,8541009,10992327,10992380,10992381,10992382,10992389,10992393,10610965,9173384,9173385,9173386,7019066,7019101,7019139,10611184,10611187,10611188,10611191,7019294,7019328,7059868,7019360,10614495,10614499,10559703,10559711,10611568,10122108,10122110,10122111,9174066,10614744,9174089,9174090,10612060,9211540,9211541,9211542,9211543,9171593,10120108,9196015,9172146,10120364,10612931,7017943,7017963,10609988,7017983,8862875,10610064,10610065,10613099,10613106,10613110,10613111,10613115,10613116,7018182,9172533,9172540,9172542,9172543,10613369,7018518,7018544,7018545,7018546,7018547,7018548,7018549,7018550,7018551,7018552,7018553,7018554,7018555,7018556,7018557,7018558,7018559,7018560,7018586,7018620,7018654,9205064,10613831,10613832,10613833,10613834,7018826,10613835,10613836,10613837,10613838,10613839,10613840,10613841,10613842,10613843,10610850,7018860,10610890,7018894,10610958,10117516,10117517,9169329,9177369,7015133,7015134,7015135,7015136,7015137,7015138,7015139,7015140,10515316,9185610,9185618,9185619,9185624,7015287,7015307,7015327,9185722,9185735,9185736,9185741,9185743,9185747,9185748,9185749,10513562,10513563,10513564,7055922,9185826,7015492,7015493,7015494,7015495,7015496,7015497,9185852,9185855,9185859,9185860,9185861,9185873,9185877,9185878,9185888,9185889,9185893,9185894,9185895,9185906,9185909,9185910,9185911,9185912,9185913,9185914,9185917,9185922,9185931,9185932,9185933,9185934,9185935,9169936,9185936,9185940,9185942,9185949,10118177,9186036,9186037,10118234,9186128,9186130,9186132,9186135,9186147,10516122,9186353,10118606,10118610,9178490,9186754,10119047,8552199,8552200,10512852,10513076,10416257,10416383,10116703,10116704,10116711,10419457,10116818,10415601,10419669,10419670,10419695,10419711,10419738,10419755,10419756,9168870,10416810,10418843,10418844,9168932,10415882,10419905,10419906,9193120,10420085,10417089,10420091,10420096,10417101,10417110,10117401,10417140,10417148,10417155,10417156,10417157,7019953,7019974,7019975,7019976,7019977,7019978,7019979,7019980,7019981,7019982,7019983,7019984,7019985,7019986,7019987,7020009,7020037,7020065,10463031,10463034,10463044,9174514,9174516,10467101,10467108,10467110,10467111,10467112,7020190,10467125,10467128,10467132,7020218,10467145,10467152,7020246,10471171,8549885,10463398,7020490,7020491,7020492,7020493,7020494,7020495,7020496,7020497,7020498,7020499,7020500,7020501,8550003,10463429,10463432,10467433,10467434,10467437,10467458,10467459,10469573,7020658,7020659,7020690,10463675,10465689,7020768,10465696,10465697,10463753,10463757,6667178,10463758,10463759,10463763,10463769,10463772,10463780,10465781,10465783,10465786,10465787,10463789,10465796,10465799,10465800,10465805,10463806,10463823,10465823,10463824,10463826,10465826,10465827,10463831,10463832,10465843,10465844,10465845,9175298,10463876,9175303,10463882,10465887,10465894,10465895,10465896,10465897,10465898,10465900,10465907,10465911,10465913,10463914,10463919,10463920,10463930,10463931,10464042,8550649,10123787,10466210,10466213,10466229,10466231,10466232,10468237,10466243,10466318,10466321,10466322,10466323,10466325,10466328,10466345,10466348,10466370,10466375,10462398,10466401,10466404,10462409,10462410,10462411,10462427,9175850,10462431,10466432,10466433,10462436,10462437,10466439,10466440,9167864,10466444,10466447,10462454,10462455,10462458,10462462,10462463,10462472,10462489,10462501,10462502,10462503,10462504,10462505,10462510,10462518,10462544,10464581,10462598,10462599,10462607,10462612,9168100,9168162,10466851,10466855,10883559,10883560,10883561,10883562,10883586,10883622,10889066,10884723,10884799,10890139,10890141,10890142,10890143,10890144,10890145,10890151,10176228,10176267,10880307,10163534,10887546,10632168,10627406,10153994,10883044,10627724,10627725,10883358,10883359,10883378,10883403,10883404,10883421,10172014,10172017,10172018,10172020,10172073,10172083,10172084,10172088,10172090,10172091,10172093,10172098,10886133,10886134,10886135,10886136,10886137,10886138,10886139,10886140,10886141,10886142,10886143,10886144,10886145,10886146,10886147,10886148,10886149,10172194,10172563,10626233,10626234,10626237,10626291,10172899,10167941,10631431,10631432,10631439,10631440,10167968,10168007,10168039,10887075,10631795,10882359,10601399,10568558,10598577,10598578,10598590,10598591,10598592,10598593,10598604,10598605,10598606,10598615,10598616,10598617,10598618,10598619,10598639,10598640,10598641,10598659,10598660,10598666,10598679,10598681,10598686,10598706,10598707,10598708,10598709,10598710,10598711,10598712,10598713,10598714,10598734,10598735,10598736,10598737,10598738,10598739,10598740,10598741,10598742,10598743,10598744,10598757,10598758,10598764,10598765,10598784,10598785,10598786,10598787,10598788,10598789,10598790,10598791,10598803,10598821,10598830,10598857,10590273,10590278,10590279,10590280,10590308,10591360,10591929,10591930,10591931,10591932,10591933,10591934,10591935,10591936,10528140,10528144,10528145,10528150,10528153,10528154,10528161,10528182,10528183,10522388,10520769,10520777,10524895,10527005,10521025,10420250,10420252,10420256,10420264,10420424,10420426,10420427,10424485,10424486,10420571,10420573,10420578,10420588,10420589,10420592,10420598,10423621,10423622,10423624,10420676,10422750,10420850,10424871,10421951,10421952,10421953,10421954,10421955,10421956,10421961,10421962,10421965,10421984,10420997,10421999,10425031,10425032,10425033,10425036,10425037,10425054,10425056,10425097,10485931,10483160,10484505,10484506,10484518,10484519,10496617,10496911,10486951,10486952,10486953,10486954,10496982,10478012,10482036,10476537,10476538,10476652,10407067,10407075,10407079,10478843) 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'