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(7068159,10460418,10973622,10973623,10973624,10973625,10973626,10973627,10973628,10973629,10973630,10973631,10973632,10973633,10973634,10973635,10973636,10973637,10973638,10973639,10973640,10973641,10973642,10973643,10973644,10973645,10973646,10973647,10973648,10973649,10973650,10973651,10973652,10973653,10973654,10973655,10973656,10973657,10973658,10973659,10973660,10973661,10973662,10973663,10973664,10973665,10973666,10973667,10973668,10973669,10973670,10973671,10973672,10973673,10973674,10973675,10973676,10973677,10973678,10973679,10973680,10973681,10973682,10973683,10973684,10973685,10973686,10973687,10973688,10973689,10973690,10973691,10973692,10973693,10973694,10973695,10973696,10973697,10973698,10973699,10973700,10973701,10973702,10973703,10973704,10973705,10973706,10973707,10973708,10973709,10973710,10973711,10973712,10973713,10973714,10973715,10973716,10973717,10973718,10973719,10973720,10973721,10973722,10973723,10973724,10973725,10973726,10973727,10973728,10973729,10973730,10973731,10973732,10973733,10973734,10973735,10973736,10973737,10973738,10973739,10973740,10973741,10973742,10973743,10973744,10973745,10973746,10973747,10973748,10973749,10973750,10973751,10973752,10973753,10973754,10973755,10973756,10973757,10973758,10973759,10973760,10973761,10973762,10973763,10973764,10973765,10973766,10973767,10973768,10973769,10973770,10973771,10973772,10973773,10973774,10973775,10973776,10973777,10973778,10973779,10973780,10973781,10973782,10973783,10973784,10973785,10973786,10973787,10973788,10973789,10973790,10973791,10973792,10973793,10973794,10973795,10973796,10973797,10973798,10973799,10973800,10973801,10973802,10973803,10973804,10973805,10973806,10973807,10973808,10973809,10973810,10973811,10973812,10973813,10973814,10973815,10973816,10973817,10973818,10973819,10973820,10973821,10973822,10973823,10973824,10973825,10973826,10973827,10973828,10973829,10973830,10973831,10973832,10973833,10973834,10973835,10973836,10973837,10973838,10973839,10973840,10973841,10973842,10973843,10973844,10973845,10973846,10973847,10973848,10973849,10973850,10973851,10973852,10973853,10973854,10973855,10973856,10973857,10973858,10973859,10973860,10973861,10973862,10973863,10973864,10973865,10973866,10973867,10973868,10973869,10973870,10973871,10973872,10973873,10973874,10973875,10973876,10973877,10973878,10973879,10973880,10973881,10973882,10973883,10973884,10973885,10973886,10973887,10973888,10973889,10973890,10973891,10973892,10973893,10973894,10973895,10973896,10973897,10973898,10973899,10973900,10973901,10973902,10973903,10973904,10973905,10973906,10973907,10973908,10973909,10973910,10973911,10973912,10973913,10973914,10973915,10973916,10973917,10973918,10973919,10973920,10973921,10973922,10973923,10973924,10973925,10973926,10973927,10973928,10973929,10973930,10973931,10973932,10973933,10973934,10973935,10973936,10973937,10973938,10973939,10973940,10973941,10973942,10973943,10973944,10973945,10973946,10973947,10973948,10973949,10973950,10973951,10973952,10973953,10973954,10973955,10973956,10973957,10973958,10973959,10973960,10973961,10973962,10973963,10973964,10973965,10973966,10973967,10973968,10973969,10973970,10973971,10973972,10973973,10973974,10973975,10973976,10973977,10973978,10973979,10973980,10973981,10973982,10973983,10973984,10973985,10973986,10973987,10973988,10973989,10973990,10973991,10973992,10973993,10973994,10973995,10973996,10973997,10973998,10973999,10974000,10974001,10974002,10974003,10974004,10974005,10974006,10974007,10974008,10974009,10974010,10974011,10974012,10974013,10974014,10974015,10974016,10974017,10974018,10974019,10974020,10974021,10974022,10974023,10974024,10974025,10974026,10974027,10974028,10974029,10974030,10974031,10974032,10974033,10974034,10974035,10974036,10974037,10974038,10974039,10974040,10974041,10974042,10974043,10844111,10974044,10844112,10974045,10974046,10974047,10974048,10974049,10974050,10974051,10974052,10974053,10974054,10974055,10974056,10974057,10974058,10974059,10974060,10974061,10974062,10974063,10974064,10974065,10974066,10974067,10974068,10974069,10974070,10974071,10974072,10974073,10974074,10974075,10974076,10974077,10974078,10974079,10974080,10974081,10974082,10974083,10974084,10974085,10974086,10974087,10974088,10974089,10974090,10974091,10974092,10974093,10974094,10974095,10974096,10974097,10974098,10974099,10974100,10974101,10974102,10974103,10974104,10974105,10974106,10974107,10974108,10974109,10974110,10974111,10974112,10974113,10974114,10974115,10974116,10974117,10974118,10974119,10974120,10974121,10974122,10974123,10974124,10974125,10974126,10974127,10974128,10974129,10974130,10974131,10974132,10974133,10974134,10974135,10974136,10974137,10974138,10974139,10974140,10974141,10974142,10974143,10974144,10974145,10974146,10974147,10974148,10974149,10974150,10974151,10974152,10974153,10974154,10974155,10974156,10974157,10974158,10974159,10974160,10974161,10974162,10974163,8072451,8613167,4938189,3231768,3231769,3231770,3231771,3231772,3231773,3231774,3231775,3231776,3231777,3231778,3231779,3231780,3231781,3231782,3231783,9191930,10895341,10895342,10895343,10167416,10167417,10167418,10167419,10649449,10582560,10652018,10545490,10545491,10545492,10545493,10545494,10545495,10545496,10545497,10545498,10545539,10545540,10545645,10545646,10545701,10523067,10478524) 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'