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(7068018,11040704,11040710,11040784,7076123,11040817,10975856,10975870,10939812,10939813,10939814,10939815,10939816,10939817,10939827,10939839,10939847,10939849,11041067,10963095,10963097,8569437,8569560,8569561,8569562,10989374,10976391,8569691,10989549,10989578,10989658,10963661,10963665,10989786,10989889,10989989,8067300,10437236,10990100,10964295,7066684,10964409,7074772,8067799,10938513,10990592,10974732,7075086,7075087,7067141,7067204,10938928,10974990,10962059,4969654,7067490,7067491,7067492,7067493,7067494,7067495,7067496,7067497,7067498,7067499,7067500,7067505,7067509,7067512,7067513,7067515,7067518,7067521,4969745,11001228,11001342,11040461,10988568,10988569,10988570,7075892,7064083,10931554,11011961,10998988,10985988,11012156,10960311,8065771,8065779,10960492,4967258,8066053,8066054,10999868,7073209,7073210,7073213,7073232,7073235,7073258,7073259,7073266,7065279,7073285,10987033,10987034,7065453,7065511,7065685,4967937,4967940,7065774,7065810,10933227,10933280,11048875,11048876,11010764,11010809,10997955,10997987,11011120,11011150,10998185,10985216,10998230,11011278,11011483,8970223,10998586,10944401,7069172,10944720,10944721,10944722,10944723,10940983,10940984,7069479,10941145,10945078,7069670,7069693,11035390,3656282,10941496,10941497,10941498,10941499,10941500,10941501,7069898,3656505,7070057,10941688,10957790,10957791,10957792,10957793,10957794,10957795,10957796,10957797,10957798,10957799,10957800,10957801,10957802,10957803,11009811,11009843,7070190,8072957,11009933,10942109,7070602,7070606,11048624,11048625,11048626,11048627,10954663,10618183,10623235,10623388,10623491,10994343,10994390,10994396,10619220,10619221,10619222,11008113,10619627,10619628,10619629,10619630,10619631,10619632,10619633,10619634,10619635,10619636,10619637,10619638,10619639,10619640,10619641,10619642,10619643,10619644,10619645,10619646,10619647,10619648,10619649,10619650,10619651,10619652,10619653,10619654,10619655,10619656,10619657,10619658,10619659,10619660,10619661,10619662,10619663,10619664,10619665,10619666,10619667,10619668,10619669,10619670,10619671,10619672,10619673,10619674,10619675,10619676,10619677,10619678,10619679,10619680,10619681,10619682,10619683,10619684,10619685,10619686,10619687,10619688,10619689,10619690,10619691,10619692,10619711,10995387,10995388,10619745,10995407,10619771,10619801,10619806,10616971,10616997,10616998,10617005,10617006,10617007,10617008,10966694,10617085,10617093,10617094,10617095,10617096,10617097,10617098,10617289,10617290,10617291,10617292,10617293,10622397,10617598,10928283,10928286,10967438,10954520,10990639,10925533,10990800,10925694,10925700,10925703,10964990,10964991,10964992,10964993,10964994,10964995,10964996,10964997,10964998,10964999,10965000,10965001,10965002,10965003,10965004,10965005,10965006,10965007,10965008,10965009,10965010,10965011,10965012,10965013,10965014,10965015,10965016,10965017,10965018,10965019,10965020,10965021,10965022,10965023,10965024,10965025,10965026,10965027,10965028,10965029,10965030,10965031,10965032,10965033,10965034,10965035,10965036,10965037,10965038,10965039,10965040,10965041,10965042,10965043,10965044,10965045,10965046,10965047,10965048,10965049,10965050,10965051,10965052,10965053,10965054,10965055,10965070,10965082,10965098,10965118,10965148,10965152,10965155,10965175,10965206,10965207,10965210,10991217,10965226,10965231,10965234,10965242,10930688,10916310,10916311,10991459,10916312,10916313,10916314,10916315,10916316,10620841,10930813,10916429,10916430,10916431,11017580,10916432,11017581,11017582,11017583,10921470,11017760,10978796,10616178,10921964,10616479,10616482,10616503,10616504,10616518,10927050,11018368,10616715,10953529,10565181,10614055,7059603,10565261,10565262,10565263,10565264,10565265,10565266,10565267,10565268,10565269,10565270,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10562292,9173513,9189554,8864093,9189584,9189619,9173652,10611435,8864378,9197928,9166112,9166113,9166114,9166115,9166116,10611875,9182270,9171465,9171471,9171475,9187526,9171533,9187543,10563397,8862114,8862182,10563531,10612426,10612427,9171866,9171867,9171905,9171933,10609777,9172119,9172120,9172165,9172166,9172167,8862740,8862747,10612890,8862779,9180298,7058471,9172328,9172329,8862900,8862901,8862902,8862903,10610073,10610074,10610075,9196447,9196738,10558640,10558641,10558654,9196975,9189030,10610944,9169360,9169361,9169449,7055685,7055686,9185578,4974521,9161677,7056015,7056016,7056017,7056018,7056019,7056020,7056021,9161856,7056022,7056027,7056032,10513728,10513729,10513851,9162213,10516068,10516069,9186341,9186349,9186350,9170656,9186765,2809627,7057346,7057347,7057348,7057349,10513031,10513034,10513047,10513048,10513049,10513050,10513051,10513052,10513053,10519065,8918063,9160530,10415572,10415573,10415574,10415575,10415576,9184906,9184907,9184908,9184909,9184910,9184911,9184912,9184913,10416904,10416905,10416906,10416907,10416908,10416909,9169087,9169088,4971215,10470941,10470942,4971227,4971228,4971229,4971230,4971231,4971232,4971233,4971234,4971235,4971236,4971243,4971248,4971258,4971281,4971285,4971292,10471025,10469384,6666812,6666813,6666814,6666815,6666816,6666817,6666818,6666819,10467413,10467415,10467416,10467417,10467418,10467419,10467423,10467424,10467425,10467426,6666867,9174898,9174899,9174900,9174901,9174902,9174903,9174904,9174905,9174906,9174907,9174908,9174909,9174910,9174911,9174912,9174913,9174914,9174915,9174916,9174917,9174918,9174919,9174920,9174921,9174922,9174923,9174924,9174925,9174926,9174927,9174928,9174929,9174930,9174931,9174932,9174933,9174934,9174935,9174936,9174958,9174975,9174988,9175004,10469685,10469686,9183226,8916931,9191316,9191317,8916998,8916999,9191437,9191446,8563429,8563430,8563432,9167536,9167539,10468117,8563519,9175656,9191693,9167712,9183833,9183834,9167889,9167893,9167894,9167895,9167896,8917617,9191989,9192137,10470772,10470773,9184227,9184228,10174538,10628232,10174906,10629333,10155891,10629431,10173519,10178596,10178597,10178598,10178599,10163627,10163628,10163629,10163630,10163631,10163632,10163633,10163634,10163635,10163636,10163637,10163638,10163639,10163640,10163641,10163642,10163643,10163644,10163645,10163646,10163647,10163648,10163649,10163650,10163651,10163652,10163653,10163654,10163666,10163691,10163705,10178742,10159114,10159116,10159124,10159130,10176675,10161729,10625235,10171829,10171833,10171834,10171835,10171836,10171837,10171839,10171846,10171848,10171855,10625374,10625375,10625376,10625377,10625378,10625379,10625380,10625381,10625382,10625383,10625384,10625385,10625386,10625387,10625388,10161943,10162345,10625846,10177658,10631298,10626558,10168206,10571149,10571150,10568409,10568477,10568548,10587102,10587103,10587104,10567447,10567449,10567452,10585474,10570810,10570811,10582905,10519122,10521233,10531438,10531439,10531474,10521596,10521597,10520218,10526442,10526443,10526444,10526445,10526446,10526447,10526448,10526449,10520484,10520487,10520488,10520489,10520490,10520491,10520492,10520493,10520494,10520495,10520496,10520497,10520498,10520499,10520500,10520501,10520502,10520503,10520504,10520505,10520506,10520507,10520508,10520509,10520510,10520511,10520512,10520513,10520514,10520515,10520516,10520517,10520518,10520519,10520520,10520521,10520522,10520523,10520524,10520525,10520526,10520527,10520528,10520529,10520530,10520531,10520532,10520533,10520534,10520535,10520536,10520537,10520538,10520539,10520540,10520541,10520542,10520543,10520544,10520545,10520546,10520547,10520548,10520549,10520550,10520551,10520552,10520553,10520554,10520555,10520556,10520557,10520558,10520559,10520617,10520619,10520627,10528680,10526686,10526687,10526688,10526689,10526690,10526691,10520692,10526692,10526693,10526694,10526695,10526696,10526697,10526698,10526699,10526700,10526701,10526702,10526703,10526704,10526705,10526706,10526707,10526708,10526709,10526710,10526711,10526712,10526713,10526714,10520715,10526715,10526716,10526717,10526718,10526719,10526720,10526721,10526722,10526723,10526724,10526725,10526726,10526727,10526728,10526729,10526730,10526731,10526732,10526733,10526734,10526735,10526736,10526737,10526738,10526739,10526740,10526741,10526742,10526743,10526744,10526745,10526746,10526747,10526748,10526749,10526750,10526751,10526752,10526753,10526754,10526755,10526756,10529019,10529031,10529032,10498397,10420632,10420633,10420634,10420635,10420636,10498633,10476879,10476880,10476881,10476882,10476883,10476884,10476885,10476886,10476887,10476888,10476889,10476890,10476891,10476892,10476893,10476894,10476895,10476896,10476897,10476898,10476899,10476900,10476901,10476902,10476903,10476904,10476905,10476906,10476907,10476908,10476909,10476910,10476911,10476912,10476913,10476914,10476939,10476972,10476986,10481829,10481830,10481831,10482758,10482873) 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'