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(10861593,10861594,10848672,10848673,10848674,10848675,8631061,10848797,4970772,3229192,8631533,3229303,8583567,7066215,7066233,8583952,8632191,8632502,8632503,8067905,8067930,8067939,10860373,8629780,8573329,8629892,10860575,8630401,10939437,10939438,10866421,7201452,8627870,10866532,8595162,8628447,8065799,8065850,7202211,7202212,7202213,8628656,7202484,7200224,10865268,10857388,10857390,10857391,10865409,10865411,7200396,8626904,10865558,10865561,10865562,10865563,10865564,10958961,10865565,10865566,10865567,10865764,10865765,7200782,10865848,10865867,10865868,10865894,10865895,10865896,10865907,10865922,8627506,8627507,8627508,8627509,8627510,8627511,8627512,8627513,8627514,8627515,8627516,8627517,10858159,8627518,10855688,10855704,7198682,7198683,7198687,7198727,7198734,7198735,7198741,7198744,7198745,7198757,7198760,7198761,7198764,7198766,7198767,10863842,10863843,8625262,8625265,10864148,7199180,7199555,10856615,10856619,7199606,10856652,7199614,7199616,7199618,7199619,7199626,7199627,7199663,7199689,7199712,7199717,7199718,7199719,7199720,7199721,7199793,7199808,7199809,7199848,7199896,7199897,7199912,10865003,7199983,7199984,7199985,7199986,7199987,7199988,7199989,7199990,7199991,7199992,7199993,7200012,10865067,10865068,10865069,10857119,7200127,3237339,10853287,10853288,10853289,10853290,10853291,10853292,10853293,10853294,10853307,10853320,3923569,3923654,3923655,3923661,10853657,8554356,8554369,8906570,8906602,8906631,8906636,8906683,8906684,8906685,8906686,8906771,8906851,7197065,7197066,7197067,7197218,7197249,10838924,10838935,10854649,10854650,7197608,10854651,10854652,10854653,10854654,10854674,10854675,10854676,10854677,7197640,7197644,7197649,10854695,10854696,10854697,10854698,10854735,10854736,10854737,10854738,10854739,10854740,10854741,10854742,10854771,10854772,10854773,10854800,10854801,10854802,10854803,10854804,10854826,10854860,10854861,10854862,10854863,10854864,10854865,10855139,10855140,8624548,8624549,10617018,10617019,10617020,8905237,8905371,10615086,8632801,8632803,8632804,10615390,10615398,10615435,3581859,3581876,8633270,8633271,10615820,10426241,10615954,10615956,10616016,10426357,10616033,10616064,10426417,10616093,10616098,10616099,10426447,10426448,10426449,10426450,10426451,10426452,10616423,10616424,10616425,10616426,10616427,10616428,10616538,10616570,10616638,8611448,10616646,10616647,10616688,10616689,10616690,10616691,10616692,10851985,10616728,10616729,7155309,10616817,10616818,10616863,10616864,10616868,10616902,10616932,8904987,8853216,8853227,10614205,6669823,10714171,10714189,10614458,10614516,10714418,10611801,8851298,8851302,8851308,8851320,8851324,8851326,8851338,8851345,10612287,10612333,10612429,10609882,10609925,10609926,10609927,10612937,10610035,10610053,10610054,8852314,10610298,10613308,10613309,10613310,10613311,8852660,8852661,8852662,10613654,10610669,10613695,10613696,10613697,10610793,10610952,10117504,9169419,9169420,9169423,6673659,9911778,10117826,9911844,9169661,9169670,9169712,10117929,7015442,7015443,9169789,7015444,7015445,7015466,7015467,9169818,7015528,7015529,9169884,9169885,9169886,6674107,6674147,9161950,7015634,7015635,7015636,7015637,6674254,6674281,10118309,10118310,9912336,8849973,8850108,8850125,10118507,10118522,10118599,9912638,8850607,8850615,9913195,9913233,9913315,9913316,10417293,10418293,10417294,10417295,10418356,10418357,10418358,6672654,6672683,9168489,9168490,10415488,10418573,9168765,10418707,10418795,10418798,10418799,10418800,10418801,10418802,10418976,10418977,10419038,10419064,10419065,10419072,10419093,10419095,10470882,10470913,10470914,10470915,10470928,10470943,10470954,10470970,10471013,10471028,10471064,10471166,8550033,10469494,10469556,9175061,10469662,10467857,9167658,9167800,9167910,9167911,10468520,10470677,10470678,10470762,10470793,10470803,10470819,10470830,10470832,10889006,10889009,10884026,10884027,10884068,10889119,10889241,10889243,10889244,10889245,10889267,10889280,10889315,10889476,10889569,10889584,10889611,10889676,10889683,10889687,10889710,10889716,10889717,10884926,10879927,10879930,10889953,10889954,10889955,10889974,10890011,7000861,10627332,10882916,10882917,10882928,10882937,10882938,10882945,10882946,10882947,10887969,10887970,10887975,10882987,10883135,10883231,10883232,10888409,10883450,10885930,10949013,10897075,10897076,10897079,10897080,10887423,10887464,10602140,10647673,10603873,10604303,10604696,10607702,10522577,10522578,10522579,10522580,10522581,10522582,10522583,10522584,10522585,10522586,10550596,10550597,10550598,10550599,10550602,10550603,10522863,10508123,10508157,10508297,10508543,10508546,10505561,10505562,10505564,10505565,10505566,10505567,10505568,10505569,10505570,10505571,10505572,10409479,10409676,10411953,10414024,10412140,10412142,10410339,10412728,10412736,10472575,10406935,10406936,10406937,10472592,10406938,10406939,10406940) 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'