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(10988874,10988875,10988876,10988877,10988878,10988879,10988880,10988881,10988882,10988883,10988884,10988885,10988886,10988887,10988888,10988889,10988890,10988891,10988892,10988893,10988894,10988895,10988896,10988897,10988898,10988899,10988900,10988901,10988902,10988903,10988904,10988905,10988906,10988907,10988908,10988909,10988910,10988911,10988912,10988913,10988914,10988915,10988916,10988917,10988918,10988919,10988920,10988921,10988922,10988923,10988924,10988925,10988926,10988927,10988928,10988929,10988930,10988931,10988932,10988933,10988934,10988935,10988936,10988937,10988938,10988939,10988940,10988941,10988942,10988943,10988944,10988945,10988946,10988947,10988948,10988949,10988950,10988951,10988952,10988953,10988954,10988955,10988956,10988957,10988958,10988959,10988960,10988961,10988962,10988963,10988964,10988965,10988966,10988967,10988968,10988969,10988970,10988971,10988972,10988973,10988974,10988975,10988976,10988977,10988978,10988979,10988980,10988981,10988982,10988983,10988984,10988985,10988986,10988987,10988988,10988989,10988990,10988991,10988992,10988993,10988994,10988995,10988996,10988997,10988998,10988999,10989000,10989001,10989002,10989003,10989004,10989005,10989006,10989007,10989008,10989009,10989010,10989011,10989012,10989013,10989014,10989015,10989016,10989017,10989018,10989019,10989020,10989021,10989022,10989023,10989024,10989025,10989026,10989027,10989028,10989029,10989030,10989031,10989032,10989033,10989034,10989035,10989036,10989037,10989038,10989039,10989040,10989041,10989042,10989043,10989044,10989045,10989046,10989047,10989048,10989049,10989050,10989051,10989052,10989053,10989054,10989055,10989056,10989057,10989058,10989059,10989060,10989061,10989062,10989063,10989064,10989065,10989066,10989067,10989068,10989069,10989070,10989071,8569474,8067140,8067141,8067142,8067143,8067144,8067145,7072220,7072221,10931819,10931820,10931821,8075312,8075317,10960383,10999659,10999660,10999661,10999662,10999663,10999664,10999665,10999666,10999667,10999668,10999669,10999670,10999671,10999672,10999673,10999674,10999675,10999676,7064992,10999677,10999678,10999679,10999680,10999681,7065257,10932756,11048908,11048909,11048910,11048911,11048912,11048913,11048914,11048915,11048916,7071131,7071132,7071133,7071134,7071135,7071136,7071137,7071138,7071139,7071140,7071141,7071142,7071143,7071144,7071145,7071146,7071147,7071148,7071149,7071150,7071151,10940864,10941634,10941635,10941636,10941637,10941638,10941639,10941640,10941641,10941642,10941643,10941644,10941645,10941646,10941647,10941648,10941649,10941650,10941651,10941652,10941653,10941654,10941655,10941656,10941657,10941658,7070478,7070479,7070480,7070481,7070482,7070483,7070484,7070485,7070486,7070487,7070488,7070489,7070490,7070491,7070492,7070493,7070494,7070495,7070496,7070497,7070498,7070499,7070500,7070501,7070502,7070503,7070504,7070505,7070506,7070507,7070508,7070509,7070510,7070511,7070512,7070513,7070514,7070515,7070516,7070517,7070518,7070519,7070520,7070521,7070522,7070523,7070524,7070525,7070526,7070527,7070528,7070529,7070530,7070531,7070532,7070533,7070534,7070535,7070536,7070537,7070538,7070539,7070540,7070541,7070542,7070543,7070544,7070545,7070546,7070547,7070548,7070549,7070550,7070551,7070552,7070553,7070554,7070555,7070556,7070557,7070558,7070559,7070560,7070561,7070562,7070563,7070564,7070565,10942310,10942311,10942312,11048755,11048756,11048757,11048758,11048759,10994381,10994382,10994383,10994384,10994385,10994386,10994387,10994388,10994389,10994390,10994391,10994392,10994393,10994394,10994395,10994396,10994397,10994398,10994399,10994400,10994401,10994402,10994403,10994404,10994405,10994406,10994407,10994408,10994409,10994410,10994411,10994412,10994413,10994414,10994415,10994416,10994417,10994418,10994419,10994420,10994421,10994422,10994423,10994424,10994425,10994426,10994427,10994428,10994429,10994430,10994431,10994432,10994433,10994434,10994435,10994436,10994437,10994438,10994439,10994440,10994441,10994442,10994443,10994444,10994445,10994446,10994447,10994448,10994449,10994450,10994451,10994452,10994453,10994454,10994455,10994456,10994457,10994458,10994459,10994460,10994461,10994462,10994463,10994464,10994465,10994466,10994467,10994468,10994469,10994470,10994471,10994472,10994473,10994474,10994475,10994476,10994477,10994478,10994479,10994480,10994481,10994482,10994483,10994484,10994485,10994486,10994487,10994488,10994489,8070771,10928085,10928086,8570008,8570023,8570024,8570025,8570026,8570089,8570090,10930817,10930818,10930819,10930820,10930821,10930822,10930823,10559112,10559188,10559189,10559190,10559191,10559192,10559193,10559194,8864174,8864175,8864176,8864177,8864178,8864179,8864180,8864181,10559483,7057613,7057614,7057615,7057616,7057617,7057618,7057619,9187504,9187505,9187506,9187507,9187508,9187509,9187510,9187511,9187512,9187513,9187514,9187515,9187516,9187517,9187518,9187519,9187520,9187521,9187522,9187523,9187524,9187525,9187526,9187527,9187528,9187529,9187530,9187531,9187532,9187533,9187534,9187535,9187536,9187537,9187538,9187539,9187540,9187541,9187542,9187543,9187544,9187545,9187546,9187547,9187548,9187549,9187550,10609264,7058170,10613032,10613033,10558693,10558773,10558774,10558775,10558776,10558777,10558778,10558779,10558780,10558781,10558782,10558783,10558784,10558785,10558786,10558787,10558788,10558789,9189088,10559101,10559102,10559103,10559104,10559105,10559106,10559107,10559108,10559109,10559110,10559111,10515672,10515673,10515674,10515675,4975288,2809640,2809641,2809642,2809643,2809644,7057419,7057420,7057421,7057422,7057423,7057424,7057425,7057426,7057427,7057428,7057429,7057430,7057431,7057432,7057433,4973152,4973153,4973154,4973155,4973156,4973157,4973158,4973159,4973160,4973161,9185107,9185108,9185109,9185110,9185111,9185112,9185113,9185114,9185115,9185116,9185117,9185118,9185119,9185120,9185121,9185122,9185123,9185124,9185125,9185126,9185127,9185128,9185129,9185130,9185131,9185132,9185133,9185134,9185135,9185136,9185137,9185138,9185139,9185140,9185141,9185142,9185143,9185144,9185145,9185146,9185147,9185148,9185149,9185150,9185151,9185152,9185153,9185154,9185155,9185156,9185157,9185158,9185159,9185160,9185161,9185162,9185163,9185164,9185165,9185166,9185167,9185168,9185169,9185170,9185171,9185172,9185173,9185174,9185175,9185176,9185177,9185178,9185179,9185180,9185181,9185182,9185183,9185184,9185185,9185186,9185187,9185188,9185189,9185190,9185191,9185192,9185193,9185194,9185195,9185196,9185197,9185198,9185199,9185200,9185201,9185202,9185203,9185204,9185205,9185206,9185207,9185208,9185209,9185210,9185211,9185212,9185213,9185214,9185215,9185216,9185217,9185218,9185219,6667117,6667118,6667119,6667120,6667121,6667122,6667123,6667124,9175217,8563409,8563410,8563411,8563413,8563414,8563415,8563416,8563417,8563425,8563429,8563430,8563431,8563432,8563433,8563434,8563438,8563442,8563444,8563448,8563452,8563454,8563458,8917271,8563555,4973147,4973148,4973149,4973150,4973151,10627590,10625773,10625774,10625775,10625776,10625777,10625778,10625779,10625780,10625781,10625782,10625783,10625784,10625785,10625786,10625787,10625788,10625789,10625790,10625791,10625792,10625793,10625794,10625795,10625796,10625797,10625798,10625799,10625800,10625801,10625802,10625803,10625804,10625805,10625806,10625807,10625808,10625809,10625810,10625811,10625812,10625813,10625814,10625815,10625816,10625817,10625818,10625819,10625820,10625821,10625822,10625823,10625824,10625825,10625826,10625827,10625828,10625829,10625830,10625831,10625832,10625833,10625834,10625835,10625836,10625837,10625838,10625839,10625840,10625841,10625842,10625843,10625844,10625845,10625846,10625847,10625848,10625849,10625850,10625851,10625852,10625853,10625854,10625855,10625856,10625857,10625858,10625859,10625860,10625861,10625862,10625863,10625864,10625865,10625866,10625867,10625868,10625869,10625870,10625871,10625872,10625873,10625874,10625875,10625876,10625877,10625878,10625879,10625880,10625881,10625882,10625883,10625884,10625885,10625886,10625887,10625888,10625889,10625890,10625891,10625892,10625893,10625894,10625895,10625896,10625897,10625898,10625899,10625900,10625901,10625902,10625903,10625904,10625905,10625906,10625907,10625908,10625909,10625910,10625911,10625912,10625913,10625914,10625915,10625916,10625917,10625918,10625919,10625920,10625921,10625922,10625923,10625924,10625925,10625926,10625927,10521658,10522539,10525007,10525008,10525009,10525010,10422781,10421865,10421866,10421867,10421868,10421869,10421870,10421871,10421872,10421873,10421874,10421875,10421876,10421877,10421878,10421879,10421880,10421881,10421882,10421883,10421884,10421885,10421886,10421887,10421888,10421889,10421890,10422218,10422219,10422220) 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'