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(11015272,8574784,8574785,8574786,8574787,8574788,8574789,8574790,8574791,8574800,8574801,8574802,8574803,8574804,8574805,8574806,8574807,8574808,8574809,8574810,8574811,8574812,8574813,8574814,8574815,8574816,8574817,8574818,8574819,8574820,8574821,8574822,8574823,8574824,8574825,8574826,8574827,8574828,8574829,8574830,8574831,8574832,8583801,8583802,8583803,8583804,8583805,8583806,8583807,8583808,8583809,8583810,8583811,8583812,8583813,8583814,8583815,8583816,8583817,8583818,8583819,8583820,8583821,8583822,8583823,8583824,8583825,8583826,8583827,8583828,8583829,8583830,10951294,10951295,10447678,8068729,8835656,8835657,8835658,8835659,8835660,8835661,8835662,8835663,8835664,8835665,8835666,8835667,8835668,8835670,8835671,8835672,8835673,8835674,8835675,8835676,8835677,8835678,8835679,8835680,8835681,8835682,8835683,8835684,8835685,8066888,8066889,8066890,10102461,10102464,10959500,10940562,10940563,10940564,10940565,10940566,10940567,10940568,10940569,10940570,10940571,8908053,8908054,8908055,8908056,8908057,8908058,8908059,8908060,7069064,7069065,7069066,7069067,7069068,7069069,7069070,7069071,7069072,7069073,10100235,10100314,10980734,10980735,10980736,10980737,10980738,10980739,10980740,10980741,10980742,10980743,10980744,10980745,10980746,10980747,10980748,10980749,10980750,10980751,10980752,10980753,10980754,10980755,10980756,10980757,10980758,10980759,10980760,10980761,10980762,10980763,10980764,10980765,10980766,10980767,10980768,10980769,10980770,10980771,10980772,10980773,10980774,10980775,10980776,10980777,10980778,10980779,10980780,10980781,10980782,10980783,10980784,10980785,10980786,10980787,10980788,10980789,10980790,10980791,10980792,10980793,10980794,10980795,10980796,10980797,10980798,10980799,10980800,10980801,10980802,10980803,10980804,10980805,10980806,10980807,10980808,10980809,10980810,10980811,10980812,10980813,10980814,10980815,10980816,10980817,10980818,10980819,10980820,10980821,10980822,10980823,10980824,10980825,10980826,10980827,10980828,10980829,10980830,10980831,10980832,10980833,10980834,10980835,10980836,10980837,10980838,10980839,10980840,10980841,10980842,10980843,10980844,10980845,10980846,10980847,10980848,10980849,10980850,10980851,10980852,10980853,10980854,10980855,10980856,10980857,10980858,10980859,10980860,10980861,10980862,10980863,10980864,10980865,10980866,10980867,10980868,10980869,10980874,10980875,10980876,10980877,10980878,10980879,10980880,10980881,10980882,10980883,10980884,10980885,10980892,10980893,10980894,10980895,10980896,10980897,10980898,10980899,10980900,10980901,10980902,10980903,10980905,10980906,10980907,10980908,10980909,10980911,10980912,10980913,10980914,10980915,10980916,10980917,10980918,10980919,10980920,10980921,10980922,10980923,10980924,10980925,10980926,10980927,10980928,10980929,10980930,10980931,10980932,10980933,10980934,10980935,10980936,10980937,10980938,10980939,10980940,10980941,10980942,10980943,10980944,10980945,10980946,10980947,10980948,10980949,10980950,10980951,10980952,10980953,10980954,10980955,10980956,10980957,10980958,10980959,10980960,10980961,10980962,10980963,10980964,10980965,10980966,10980967,10980968,10980969,10980970,10980971,10980972,10980973,10980974,10980975,10980976,10980977,10980978,10980979,10980980,10980981,10980982,10980983,10980984,10980985,10980986,10980987,10980988,10980989,10980990,10980991,10980992,10980993,10980994,10980995,10980996,10980997,10980998,10980999,10981000,10981001,10981002,10981003,10981004,10981005,10981006,10981007,10981008,10981009,10981010,10981011,10981012,10981013,10981014,10981015,10981016,10981017,10981018,10981019,10981020,10981021,10981022,10981023,10981024,10981025,10981026,10981027,10981028,10981029,10981030,10981031,10981032,10981033,10981034,10981035,10981036,10981037,10981038,10981039,10981040,10981041,10981042,10981043,10981044,10981045,10981046,10981047,10981048,10981049,10981050,10981051,10981052,10981053,10981054,10981055,10981056,10981057,10981058,10981059,10981060,10981061,10981062,10981063,10981064,10981065,10981066,10981067,10981068,10981069,10981070,10981071,10981072,10981073,10981074,10981075,10981076,10981077,10981078,10981079,10981080,10981081,10981082,10981083,10981084,10981085,10981086,10981087,10981088,10981089,10981090,10981091,10981092,10981093,10981094,10981095,10981096,10981097,10981098,10981099,10981100,10981101,10981102,10981103,10981104,10981105,10981106,10981107,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10621621,10621622,10621623,10621624,10621625,10621626,8904837,9181422,9181423,9181424,9179611,9179612,9179613,9179614,9179615,9179616,9179617,9179618,9179619,9179620,9179621,9179622,9179623,9179624,9179625,9179626,9179627,9179628,9179629,9179630,9179631,9179632,9179633,9179634,9179635,9179636,9179637,9179638,9179639,9179640,9179641,9179642,9179643,9179644,9179645,9179646,9179647,9179648,9179649,9179650,9179651,9179652,9179653,9179654,9179655,9179656,9179657,9179658,9179659,9179660,9179661,9179662,9179663,9179664,9179665,9179666,9179667,9179668,9179669,9179670,9179671,9179672,9179673,9179674,9179675,9179676,9179677,9179678,9179679,9179680,9179681,9179682,9179683,9179684,9179685,9179686,9179687,9179688,9179689,9179690,9179691,9179694,9179695,9179696,9179697,9179698,9179699,9179700,9179701,9179702,9179706,9179707,9179708,9179709,9179710,9179711,9179712,9179713,9179714,9179715,9179716,9179717,9179718,9179719,9179720,9179721,9179722,9179723,9179724,9179725,9179726,9179727,9179728,9179729,9179730,9179732,9179733,9179734,9179735,9179736,9179737,9179738,9179739,9179740,9179741,9179742,9179743,9179744,9179745,9179746,9179747,9179748,9179749,9179750,9179751,9179752,9179753,9179754,9179755,9179756,9179757,9179758,9179759,9179760,9179761,9179762,9179763,9179764,9179765,9179766,9179767,9179768,9179769,9179770,9179771,9179772,9179773,9179774,9179775,9179776,9179777,9179778,9179779,9179780,9179781,9179782,9179783,9179784,9179785,9179786,9179787,9179788,9179789,9179790,9179791,9179792,9179793,9179794,9179795,9179796,9179797,9179798,9179799,9179800,9179801,9179802,9179803,9179804,9179805,9179806,9179807,7056836,7056837,7056838,7056839,7056840,7056841,7056842,7056843,7056844,7056845,7056846,7056847,7056848,7056849,7056850,7056851,7056852,7056853,7056854,7056855,7056856,7056857,7056858,7056859,7056860,7056861,7056862,7056863,7056864,7056865,7056866,7056867,7056868,7056869,7056870,7056871,7056872,7056873,7056874,7056875,7056876,7056877,7056878,7056879,7056880,7056881,7056882,9166507,9166508,9166509,9166510,9166511,6666990,6666991,6666992,4972188,4972189,4972190,4972191,4972192,4972193,4972194,4972195,4972196,4972197,4972198,4972199,4972200,4972201,4972202,4972203,4972204,4972205,4972206,10169679,10169680,10169681,10169682,10169683,10169684,10169685,10169686,10169687,10169688,10169689,10169690,10169691,10169692,10169693,10169694,10169695,10169696,10169697,10169698,10169699,10169700,10169701,10169715,10169716,10169717,10169718,10169719,10169720,10169721,10169722,10169723,10169724,10169725,10169726,10169727,10169728,10169729,10169730,10169731,10169732,10169733,10169734,10169735,10169736,10169737,10169738,10169739,10169740,10169741,10169742,10169743,10169744,10169745,10169746,10169747,10169748,10169749,10169750,10169751,10169752,10169753,10169754,10169755,10169756,10169757,10169758,10169759,10169760,10169761,10169762,10169763,10169764,10169765,10169766,10169767,10169768,10169769,10169770,10169771,10169772,10169773,10169774,10169775,10169776,10169777,10169778,10169779,10169780,10169781,10169782,10169783,10169784,10169785,10169786,10169787,10169788,10169789,10169790,10169791,10169792,10169793,10169794,10169795,10169796,10160606,10160607,10160608,10160609,10155783,10173873,10173874,10626955,10626956,10626957,10523729,10523730,10523731,10523732,10523733,10523734,10523735,10523736,10523737,10523738,10523739,10523740,10523741,10523742,10523743,10523744,10523745,10523746,10523747,10421120,10480460,10480461,10480462,10480463,10480464,10480465,10480466,10480467,10480468,10480469,10480470,10480471,10480472,10480473,10480474,10480475,10480476,10480477,10480478,10480479,10480480,10480481,10480482,10480483,10480484,10480485,10480486,10480487,10480488,10480489,10480490,10480491,10480492,10480493,10480494,10480495,10480496,10480497,10480498,10480499,10480500,10480501,10480502,10480503,10480504,10480507,10480508,10480509,10480510,10480511,10480512,10480513,10480514,10480515,10480516,10480517,10480518,10480519,10480520,10480521,10480522,10480523,10480524,10480525,10480526,10480527,10480528,10480529,10480530,10480531,10480532,10480533,10480534,10480535,10480536,10480537,10480538) 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'