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(7076061,10846133,10846134,10846135,8574884,8574885,8574886,8574887,8574888,8574889,8574890,8574891,8574892,8574893,8574894,8574895,8574896,8574897,8574898,8574899,8574900,8574901,8574902,8574903,8574904,8574905,8574906,8574907,8574908,8574909,8574910,8574911,8574912,8574913,8574914,8574915,8574916,8574917,8574918,8574919,8569893,8569894,8569895,8569896,8569897,8066928,10951304,10951305,10929548,10929549,10929550,10929551,10929552,10929553,10929554,10447684,10447685,10447686,10447687,10447688,10447689,10447690,10447691,10447692,10447693,10447694,10959620,8835725,8835726,8835727,10843159,3899254,3899255,3899256,3899257,3899258,5654720,8573092,8573093,8573094,8573095,8573096,10841738,10841739,10841740,10841741,10841742,10841743,10841744,10841745,10841746,10841747,10841748,10841749,10841750,10841751,10841752,10841753,10841754,10841755,11023744,10102476,10102477,10102478,10102479,10102480,10102481,10102482,10102483,10102484,10102485,10959616,10959617,10959618,10959619,10940620,10940621,10940622,10940623,10940624,10940625,10940626,10940627,10940628,10940629,10940630,10940631,10940632,10940633,10940634,10940635,10940636,10940637,10940638,10940639,10940640,10940641,10940642,10940643,10940644,10940645,10940646,10940647,10940648,10940649,10940650,10940651,10940652,10940653,10944496,10944497,10944498,10944499,10944500,7069127,7069128,7069129,7069130,7069131,7069132,7069133,7069134,7069135,7069136,7069137,7069138,7069139,7069140,7069141,7069142,7069143,7069144,7069145,7069146,7069147,7069148,7069149,7069150,7069151,7069152,7069153,7069154,7069155,7069156,11035331,11035642,11035643,11035644,11009930,11048704,11048705,11048706,11048707,11048708,11048709,11048710,11048711,11048712,11048713,11048714,10981484,10981485,10981486,10981487,10981488,10981489,10981490,10981491,10981492,10981493,10981494,10981495,10981496,10981497,10981498,10981499,10981500,10981501,10981502,10981503,10981504,10981505,10981506,10981507,10981508,10981509,10981510,10981511,10981512,10981513,10981514,10981515,10981516,10981517,10981518,10981519,8613897,8613898,8613899,8907570,8907571,8907572,8907573,8907574,8907575,8907576,8907577,8907578,8907579,8907580,10427420,7155673,7155674,7155675,7155676,7155677,7155678,7155679,7155680,7155681,7155682,7155683,7155684,7155685,11045491,11045492,10615245,3582056,3582057,10926262,10930775,11004597,10427057,10427058,10427059,10427060,10427061,10427062,10427063,10621817,10621818,10621819,10621820,10621821,3232214,10621822,3232215,10621823,3232216,10621824,3232217,10621825,3232218,10621826,3232219,10621827,10621828,3232220,3232221,10621829,3232222,10621830,3232223,10621831,10621832,3232224,3232225,10621833,3232226,10621834,10621835,3232227,10621836,10621837,10621838,10621839,10621840,10621841,10621842,10621843,10621844,10621845,10621846,10621847,10621848,10621849,10621850,10621851,10621852,10621853,10621854,10621855,10621856,10621857,10621858,10621859,10621860,10621861,10621862,10621863,10621864,10621865,10621866,10621867,10621868,10621869,10621870,10621871,10621872,10621873,10621874,10621875,10621876,10621877,10621878,10621879,10621880,10621881,10621882,10621883,10621884,10621885,10621886,10621887,10621888,10621889,10621890,10621891,10621892,10621893,10621894,10621895,10621896,10621897,10621898,10621899,10621900,10621901,10621902,10621903,10621904,10621905,10621906,10621907,10621908,10621909,10621910,10621911,10621912,10621913,10621914,10621915,10621916,10621917,10621918,10621919,10621920,10621921,10621922,10621923,10621924,10621925,10621926,10621927,10621928,10621929,10621930,10621931,10621932,10621933,10621934,10621935,10621936,10621937,10562895,9179940,9179941,9179942,9179943,9179944,9179945,9179946,9179947,9179948,9179949,9179950,9179951,9179952,9179953,9179954,9179955,9179956,9179957,9179958,9179959,9179960,9179961,9179962,9179963,9179964,9179965,9179966,9179967,9179968,9179969,9179970,9179971,9179972,9179973,9179974,9179975,9179976,9179977,9179978,9179979,9179980,9179981,9179982,9179983,9179984,9179985,9179986,9179987,9179988,9179989,9179990,9179991,9179992,9179993,9179994,9179995,9179996,9179997,9179998,9179999,9180000,9180001,9180002,9180003,9180004,9180005,9180006,9180007,9180008,9180009,9180010,9180011,9180012,6676604,6676605,6676606,6676607,6676608,6676609,6676610,6676611,6676612,6676613,6676614,6676615,10120615,10120616,10120617,10120618,10120619,10120620,10120621,10120622,10120623,10120624,10120625,10120626,10120627,10120628,10120629,10120630,10120631,10120632,10120633,10120634,10120635,10120636,10120637,10120638,10120639,10120640,10120641,10120642,10120643,10120644,10120645,10120646,10120647,10120648,10120649,10120650,10120651,10120652,10120653,10120654,10120655,10120656,10120657,10120658,10120659,10120660,10120661,10120662,10120663,10120664,10120665,10120666,10120667,10120668,10120669,10120670,10120671,10120672,10120673,10120674,10120675,10120676,10120677,10120678,8567389,8567390,8567391,8567392,8567393,8567394,8863671,8863672,8863673,8863674,8863675,8863676,8863677,8863678,8863679,8863680,8863681,10513745,10513746,10515841,10515842,10515843,2809262,7056896,7056897,7056898,7056899,7056900,7056901,7056902,7056903,7056904,7056905,7056906,2809441,2809442,2809443,2809444,2809445,2809446,2809447,2809448,2809449,2809450,2809451,2809452,2809453,2809454,2809455,2809456,2809457,2809458,2809459,2809460,2809461,2809462,991223,2809463,991224,2809464,991225,2809465,991226,2809466,991227,2809467,991228,2809468,991229,2809469,991230,2809470,991231,2809471,991232,2809472,991233,2809473,991234,991235,991236,991237,991238,991239,991240,991241,991242,991243,991244,991245,991246,991247,991248,991249,991250,8552354,9166553,9166554,9166555,9166556,8549833,6666994,10469584,10469613,3963416,3963417,8550545,10470029,10470030,10470031,10470032,4972352,4972353,4972354,4972355,4972356,4972357,4972358,4972359,4972360,4972361,4972362,4972363,4972364,4972365,4972366,4972367,4972368,4972369,4972370,4972371,4972372,4972373,4972374,4972375,4972376,4972377,4972378,4972379,4972380,4972381,4972382,4972383,4972384,4972385,4972386,4972387,4972388,4972389,4972390,8917214,9207928,9191937,10466867,10466868,10466869,10466870,10466871,10899042,10899043,10899044,10899045,10899046,10899047,10899048,10899049,10899050,10899051,10170063,10899052,10170064,10170065,10170066,10170067,10170068,10170069,10170070,10170071,10170072,10170073,10170074,10170075,10170076,10170077,10170078,10170079,10170080,10170081,10170082,10170083,10170084,10170085,10170086,10170087,10170088,10170089,10170090,10170091,10170092,10170093,10170094,10170095,10170096,10170097,10170098,10170099,10170100,10170101,10170102,10170103,10170104,10170105,10170106,10170107,10170108,10170109,10170110,10170111,10170112,7000959,7000960,7000961,7000962,7000963,7000964,7000965,10892983,10888127,10948485,10948486,10948487,10880979,10880980,10880981,10880982,10880983,10880984,10162234,10949461,10949462,10949463,10949464,10949465,10949466,10949467,10949468,10949469,10949470,10949471,10949472,10949473,10949474,10949475,10949476,10949477,10949478,10949479,10949480,10949481,10949482,10949483,10949484,10949485,10949486,10949487,10949488,10949489,10949490,10949491,10949492,10949493,10626916,10626917,10646638,10579450,10579451,10579452,10579453,10649099,10649100,10649101,10649102,10649103,10649104,10649105,10649106,10649107,10649108,10649109,10649110,10649111,10649112,10649113,10649114,10649115,10649116,10649117,10649118,10649119,10649120,10649121,10649122,10649123,10649124,10649125,10649126,10649127,10649128,10649129,10649130,10649131,10649132,10649133,10649134,10649135,10649136,10649137,10649138,10649139,10649140,10649141,10649142,10649143,10523001,10523002,10523003,10523004,10523005,10523006,10421179,10421180,10421181,10421182,10421183,10421184,10421185,10421186,10421187,10421188,10480718,10480719,10480720,10480721,10480722,10480723,10480724,10480725,10480726,10480727,10480728,10480729,10480730,10480731,10480732,10480733,10480734,10480735,10480736,10480737,10480738,10480739,10480740,10480741,10480742,10480743,10480744,10480745,10480746,10480747,10480748,10480749,10480750,10480751,10480752,10480753,10480754,10480755,10480756,10480757,10480758,10480759,10480760,10480761,10480762,10480763,10480764,10480765,10480766,10480767,10480768,10480769,10480770,10480771,10480772,10480773,10480774,10480775,10480776,10480777,10480778,10480779,10480780,10480781,10480782,10480783,10480784,10480785,10480786,10480787,10480788,10480789,10480790,10480791,10480792,10480793,10480794,10480795,10480796,10480797,10480798,10480799,10480800,10480801,10480802,10480803,10480804,10480805,10480806,10480807,10480808,10480809,10480810,10480811,10480812,10480813,10480814) 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'