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(10962693,10962694,7076106,4970426,4970427,4970428,10939994,7068605,8569898,8569899,8569900,8569901,8569902,8569903,8569904,8569905,8066938,8066939,8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066947,8066948,8066949,8066950,8066951,8066952,8066953,8066954,8066955,8066956,8066957,8066958,8066959,8066960,8066961,8066962,8066963,8066964,8066965,8066966,8066967,8066968,7074236,7074273,7066347,8067732,8067733,10990488,10437684,7075068,4969298,4969299,7075290,7067373,10939344,10972685,10972686,10972687,10972688,10972689,10972690,10972691,10972692,10972693,10972694,10972695,10972696,10972697,10972698,10972699,10972700,7072017,10972701,10972702,10972703,10972704,10972705,10972706,10972707,10972708,10972709,10972710,10972711,10972712,10972713,7072030,10972714,10972715,10972716,10972717,7072033,10972718,10972719,10972720,10972721,10972722,10972723,10972724,7072040,7072041,10972725,10972726,7072042,10972727,7072043,10972728,10972729,10972730,10972731,10972732,10972733,10972734,10972735,10972736,10972737,10972738,10972739,10972740,10972741,10972742,10972743,10972744,10972745,10972746,10972747,10972748,10972749,10972750,10972751,10972752,10972753,10972754,10972755,10972756,10972757,10972758,10972759,10972760,10972761,10972762,10972763,10972764,10972765,10972766,10972767,10972768,10972769,10972770,10972771,10972772,10972773,10972774,10972775,10972776,10972777,10972778,10972779,10972780,10972781,10972782,10972783,10972784,10972785,10972786,10972787,10972788,10972789,10972790,10972791,10972792,10972793,10972794,10972795,10972796,10972797,10972798,10972799,10972800,10972801,10972802,10972803,10972804,10972805,10972806,10972807,10972808,10972809,10972810,10972811,10972812,10972813,10972814,10972815,10972816,10972817,10972818,10972819,10972820,10972821,10972822,10972823,10972824,10972825,10972826,10972827,10972828,10972829,10972830,10972831,10972832,10972833,10972834,10972835,10972836,10972837,10972838,10972839,10972840,10972841,10972842,10972843,10972844,10972845,10972846,10972847,10972848,10972849,10972850,10972851,10972852,10972853,10972854,10972855,10972856,10972857,10972858,10972859,10972860,10972861,10972862,10972863,10972864,10972865,10972866,10972867,10972868,10972869,10959869,10972870,10972871,10972872,10972873,10972874,10972875,10972876,10972877,10972878,10972879,10972880,10972881,10972882,10972883,10972884,10972885,10972886,7072203,10972887,10972888,10972889,10972890,10972891,10972892,10972893,10972894,10972895,10972896,10972897,10972898,10972899,10972900,10972901,10972902,10972903,10972904,10972905,10972906,10972907,10972908,10972909,10972910,10972911,10972912,10972913,10972914,10972915,10972916,10972917,10972918,10972919,10972920,10972921,10972922,10972923,10972924,10972925,10972926,10972927,10972928,10972929,10972930,10972931,10972932,10972933,10972934,10972935,10972936,10972937,10972938,10972939,10972940,10972941,10972942,10972943,10972944,10972945,10972946,10972947,10972948,10972949,10972950,10972951,10972952,10972953,10972954,10972955,10972956,10972957,10972958,10972959,10972960,10972961,10972962,10972963,10972964,10972965,10972966,10972967,10972968,10972969,10972970,10972971,10972972,10972973,10972974,10972975,10972976,10960183,10960184,7064527,7064528,8065709,10932667,7065326,7073411,7073412,7073413,7065666,10933270,10933271,7071253,7071275,7071283,7071296,11049364,11049365,10943115,8970211,10982620,10982621,10982622,10982623,10982624,10982625,10982626,10982627,10982628,10982629,10982630,10982631,10982632,10982633,10982634,10982635,10982636,10982637,10982638,10982639,10982640,10982641,10982642,10982643,10982644,10982645,10944381,10982646,10944382,10982647,10982648,10982649,10982650,10982651,10982652,10982653,10982654,10982655,10982656,10982657,10982658,10982659,10982660,10982661,10982662,10982663,10982664,10982665,10982666,10982667,10982668,10982669,10982670,10982671,10940708,10940709,10940710,10940711,10940712,10944508,10940713,10940714,10940715,10940716,10940717,10940718,10940719,10940720,10940721,10940722,10940723,10940724,10940725,10940726,10940727,10940728,10940729,10940730,10940731,10940732,10940733,10940734,10940735,10940736,10940737,10940738,10940739,10940740,10940741,10940742,10940743,10940744,10940745,10940746,10940747,10940748,3655724,3655725,3655726,3655727,3655728,3655729,3655730,7069225,7069226,7069227,7069228,7069229,7069230,7069231,7069232,7069233,7069234,7069235,7069236,7069237,7069238,7069239,7069240,7069241,7069242,7069243,7069244,7069245,7069246,7069247,7069248,7069249,7069250,7069251,7069252,7069253,7069254,7069255,7069256,7069257,7069258,7069259,7069260,7069261,7069262,7069263,7069264,7069265,7069266,7069267,7069268,7069269,7069270,7069271,7069272,7069273,7069274,7069275,7069276,7069277,7069278,7069279,7069280,7069281,7069282,7069283,7069284,7069285,7069286,7069287,7069288,7069289,7069290,7069291,7069292,7069293,7069294,7069295,7069296,7069297,7069298,7069299,7069300,7069301,7069302,7069303,7069304,7069305,7069306,7069308,10944969,3656531,3656532,3656533,3656534,3656535,3656536,3656537,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8073036,10971313,7070704,11048715,11048716,11048717,11048718,11048719,7070879,10967668,10967669,10967670,10967671,10967846,10623380,8070855,8070856,8070857,8070858,10920444,10621981,10621982,10621983,10621984,10621985,10621986,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622012,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622034,10622035,10622036,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622056,10622057,10622058,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622071,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10622093,10622094,10622095,10622096,10622097,10622098,10622099,10622100,10622101,10622102,10622103,10622104,10622105,10622106,10622107,10622108,10622109,10622110,10954285,10954286,10954287,10954288,10954289,10954290,10954291,10954292,10954293,10954294,10954295,10954296,10954297,10954298,10615078,10615079,10925689,10925690,10620346,10620347,10620348,10620349,10620350,10620351,10926080,10926083,10926086,10926092,10926093,10926118,10926119,10926150,10926151,10926152,10926153,10926188,10930776,10930777,10930778,10930794,10916792,10916793,10926902,7059490,7059491,7059492,10614236,7059782,7059877,10559794,10559795,10559796,10559797,10559798,10559799,10559800,10559801,10559802,10559803,10559804,10559805,10559806,10559807,10559808,10559809,10559810,10559811,10559812,10559813,10559814,10559815,10559816,10559817,10559818,10559819,10559820,10613232,10613233,10613234,8863175,10561534,8863703,8863704,8863705,8863706,8863707,8863708,8863709,8863710,8863711,8863712,8863713,8863714,8863715,7055691,7056226,7056227,7056228,7056229,7056230,4974935,4974936,4974937,7056997,7056998,7056999,7057000,7057001,7057002,7057003,7057004,7057005,7057006,7057007,7057008,7057009,7057010,7057011,7057012,7057013,7057014,7057015,7057016,7057017,7057018,7057019,7057020,7057021,7057022,7057023,7057024,7057025,7057026,7057027,7057028,7057029,7057030,7057031,7057032,7057033,7057034,7057035,7057036,7057037,7057038,7057039,7057040,7057041,7057042,7057043,7057044,7057045,7057046,7057047,7057048,7057049,7057050,7057051,7057052,7057053,7057054,7057055,7057056,7057057,7057058,7057059,7057060,7057061,7057062,7057063,7057064,7057065,7057066,8917976,8917977,8918260,7054904,10418694,10418695,10418696,4973777,4973778,8864846,8864847,8864895,8864926,8864947,10464048,10464049,10464050,10464051,10464052,10464053,10464054,10464055,10464056,10464057,10464058,10464059,10464060,10464061,10464062,10464063,10464064,10464065,10464066,8563426,8917215,4972429,4972430,4972431,4972432,4972433,4972434,4972435,4972436,4972437,4972438,4972439,4972440,4972441,4972442,4972443,4972444,4972445,4972446,4972447,4972448,4972449,4972450,4972451,4972452,4972453,4972454,4972455,4972456,10470726,10470727,10470728,10628145,10628146,10628147,10155695,10631134,10569664,10521848,10523042,10421202,10421203,10421204,10421205,10421206,10421207,10421208,10421209,10421210,10421211,10421212,10421213,10421214,10421215,10421216,10421217,10421218,10421219,10472563,10472564) 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'