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(8067473,8067474,8067477,8067478,8067479,8067511,8067516,4968767,4968768,10938909,4968060,10918474,10918475,10918481,10918490,10918491,10918492,10918493,10918494,10918498,10918499,10918529,10918531,10918533,10918538,10918541,10918542,10918567,10918574,10918603,10918630,10918637,10918638,10918673,10918677,10918684,10918697,10918699,10918700,10918709,10918713,10918714,10918723,10918725,10918726,10918731,10918732,10918742,10918747,10918748,10918749,10918750,10918751,10918757,10918763,10918784,10918785,10918786,10918788,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918805,10918806,10918809,10918818,10918821,10918850,10918867,10918890,10918894,10918895,10918896,10918901,10918904,10918905,10918907,10918921,10918928,10918929,10918941,10918948,10918950,10918981,10918982,10918996,10919002,10919003,10919004,10919005,10919006,10919038,10919048,10919049,10919052,10919053,10919054,10919062,10919065,10919066,10919067,10919068,10919074,10919075,10919076,10919078,10919079,10919080,10919093,10919102,10919112,10919113,10919121,10919122,10919128,10919130,10919133,10919134,10919135,10919154,10919176,10919177,10919178,10919184,10919187,10919188,10919191,10919204,10919207,10919214,10919217,10919221,10919224,10919234,10919236,10919239,10919252,10919253,10919254,10919255,10919258,10919284,10919306,10919343,10919368,10919372,10919373,10919377,10919387,10919392,10919421,10919422,10919426,10919432,10919433,10919450,10919468,10919473,10919479,10919485,10919486,10919487,10919488,10919489,10919493,10919499,10919506,10919507,10919508,10919514,10919515,10919516,10919517,10919520,10919524,10919525,10919526,10919529,10919530,10919531,10919532,10919535,10919539,10919540,10919541,10919542,10919543,10919544,10919554,10919559,10919564,10919569,10919580,10919581,10919650,10919700,10919737,10919739,10919740,10919743,10919786,10919795,10919818,10919823,10919831,10919832,10919833,10919834,10919835,10919845,10919847,10919852,10919854,10919858,10919863,10919875,10919877,10919883,10919884,10919887,10919895,10919903,10919909,10919910,10919911,10919913,10919920,10919943,10919944,10919945,10920007,10920008,10920009,10920010,10920152,10920153,10920154,10920155,10920156,10920161,10624670,10920183,10624673,10920184,10624674,10920185,10920186,10920187,10920188,10920223,10920224,10920225,10917472,10917473,10917474,10917475,10917476,10917477,10917478,10917480,10917481,10917482,10917483,10917484,10917485,10917486,10917487,10917488,10917490,10917491,10917492,10917493,10917496,10917497,10917498,10917500,10917501,10917502,10917505,10917508,10917509,10917515,10917516,10917520,10917522,10917523,10917526,10917527,10917528,10917529,10917530,10917531,10917532,10917533,10917534,10917535,10917536,10917537,10917538,10917540,10917542,10917543,10917544,10917545,10917546,10917547,10917548,10917549,10917550,10917551,10917552,10917554,10917555,10917556,10917557,10917558,10917559,10917560,10917561,10917562,10917572,10917578,10917582,10917583,10917584,10917585,10917587,10917588,10917589,10917590,10917595,10917596,10917600,10917601,10917602,10917603,10917604,10917606,10917609,10917610,10917612,10917613,10917622,10917623,10917624,10917625,10917626,10917628,10917629,10917630,10917631,10917632,10917633,10917634,10917635,10917636,10917637,10917638,10917639,10917641,10917643,10917645,10917653,10917654,10917655,10917656,10917657,10917660,10917661,10917664,10917667,10917668,10917669,10917670,10917671,10917672,10917673,10917674,10917675,10917676,10917680,10917681,10917683,10917685,10917687,10917688,10917694,10917695,10917696,10917697,10917698,10917701,10917702,10917703,10917704,10917705,10917706,10917707,10917708,10917709,10917710,10917711,10917712,10917713,10917714,10917715,10917716,10917717,10917718,10917719,10917720,10917721,10917722,10917723,10917724,10917725,10917726,10917727,10917728,10917729,10917730,10917731,10917732,10917733,10917734,10917735,10917736,10917737,10917738,10917739,10917740,10917741,10917742,10917743,10917744,10917745,10917746,10917747,10917748,10917749,10917750,10917751,10917752,10917753,10917754,10917755,10917756,10917757,10917758,10917759,10917760,10917761,10917762,10917763,10917764,10917765,10917766,10917767,10917768,10917769,10917770,10917771,10917772,10917773,10917774,10917775,10917776,10917777,10917778,10917779,10917780,10917781,10917782,10917783,10917784,10917785,10917786,10917787,10917788,10917789,10917790,10917791,10917792,10917793,10917794,10917795,10917796,10917797,10917798,10917799,10917800,10917802,10917803,10917804,10917805,10917806,10917807,10917808,10917809,10917810,10917811,10917812,10917813,10917814,10917815,10917816,10917817,10917818,10917819,10917820,10917821,10917822,10917823,10917824,10917825,10917826,10917827,10917828,10917829,10917830,10917831,10917832,10917833,10917834,10917835,10917836,10917837,10917838,10917839,10917840,10917841,10917842,10917843,10917844,10917845,10917846,10917847,10917848,10917849,10917850,10917851,10917852,10917853,10917854,10917855,10917856,10917857,10917858,10917859,10917860,10917861,10917862,10917863,10917864,10917865,10917866,10917867,10917868,10917869,10917870,10917871,10917872,10917873,10917874,10917875,10917876,10917877,10917878,10917879,10917880,10917881,10917882,10917883,10917884,10917885,10917886,10917887,10917888,10917889,10917890,10917891,10917892,10917893,10917894,10917895,10917896,10917897,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10917905,10917906,10917907,10917908,10917909,10917910,10917911,10917912,10917913,10917914,10917915,10917916,10917917,10917918,10917919,10917920,10917921,10917922,10917923,10917924,10917925,10917926,10917927,10917928,10917929,10917930,10917931,10917932,10917933,10917934,10917935,10917936,10917937,10917938,10917939,10917940,10917941,10917942,10917943,10917944,10917945,10917946,10917947,10917948,10917949,10917950,10917951,10917952,10917953,10917954,10917955,10917956,10917957,10917959,10917960,10917962,10917965,10917970,10917975,10917976,10917985,10917986,10917987,10917988,10917999,10918003,10918004,10918056,10918075,10918076,10918079,10918084,10918091,10918100,10918125,10918131,10918133,10918134,10918180,10918194,10918222,10918229,10918233,10918236,10918237,10918238,10918244,10918286,10918288,10918289,10918290,10918293,10918296,10918297,10918298,10918299,10918304,10918325,10918326,10918327,10918328,10918348,10918378,10918430,10918447,10918453,10915472,10915473,10915474,10915475,10915476,10915477,10915478,10915479,10915480,10915481,10915482,10915483,10915484,10915485,10915486,10915487,10915488,10915489,10915490,10915491,10915492,10915493,10915494,10915495,10915496,10915497,10915498,10915499,10915500,10915501,10915502,10915503,10915504,10915505,10915506,10915507,10915508,10915509,10915510,10915511,10915512,10915513,10915514,10915515,10915517,10915518,10915519,10915520,10915521,10915522,10915523,10915524,10915525,10915526,10915527,10915528,10915529,10915530,10915531,10915532,10915533,10915534,10915535,10915536,10915537,10915538,10915539,10915540,10915541,10915542,10915543,10915544,10915545,10915546,10915547,10915548,10915549,10915550,10915551,10915552,10915553,10915554,10915555,10915556,10915557,10915558,10915559,10915560,10915561,10915562,10915563,10915564,10915565,10915566,10915567,10915568,10915569,10915570,10915571,10915572,10915573,10915574,10915575,10915576,10915577,10915578,10915579,10915580,10915581,10915582,10915583,10915584,10915585,10915586,10915587,10915588,10915589,10915590,10915591,10915592,10915593,10915594,10915595,10915596,10915597,10915598,10915599,10915600,10915601,10915602,10915603,10915605,10915606,10915607,10915608,10915609,10915610,10915611,10915613,10915614,10915615,10915616,10915617,10915618,10915619,10915620,10915621,10915622,10915623,10915624,10915625,10915626,10915627,10915628,10915629,10915630,10915631,10915632,10915633,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915643,10915644,10915645,10915646,10915647,10915648,10915649,10915650,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10915663,10915664,10915665,10915666,10915667,10915668,10915669,10915670,10915671,10915672,10915673,10915674,10915675,10915676,10915677,10915678,10915679,10915680,10915681,10915682,10915683,10915684,10915685,10915686,10915687,10915688,10915689,10915690,10915691,10915692,10915694,10915695,10915696,10915697,10915698,10915699,10915700,10915701,10915702,10915703,10915706,10915707,10915708,10915709,10915710,10915711,10915712,10915713,10915714,10915715,10915716,10915717,10915718,10915719,10915720,10915721,10915722,10915723,10915724,10915725,10915726,10915727,10915728,10915729,10915740,10915741,10915742,10915743,10915744,10915746,10915747,10915748,10915749,10915750,10915751,10915752,10915754,10915755,10915756,10915757,10915758,10915759,10915760,10915761,10915762,10915763,10915764,10915765,10915766,10915767,10915768,10915769,10915778,10915779,10915780,10915781,10915782,10915783,10915784,10915785,10915786,10915787,10915788,10915789,10565194,10565195) 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'