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(10861202,10861211,10861229,10873798,10950681,10950682,10950688,10862440,10862475,10862480,10849530,8067928,10860627,10860634,10860640,10860641,10860700,10860708,10939386,10939387,10861002,10861003,10861004,10861005,10861006,10861007,10861008,10861009,10861010,10861011,10861012,10861013,10861014,10861015,10861016,10861017,10861018,10861019,10861020,10861021,10861022,10866136,10866137,10866139,10866142,7201335,7201336,8595062,8911578,8911579,8911580,8911581,10858959,7202133,7202165,7202168,7202171,7202209,7202210,10859669,10859673,10859674,10859691,3237399,10855528,10855529,10855530,10855531,10855532,10855533,10855534,10855535,10855536,10855537,10855538,10855539,10855540,10855541,10855542,10855543,10855544,10855545,10855546,10855547,10855548,10855549,10855550,10855551,10855552,10855553,10855554,10855555,10855556,10855557,10855558,10855559,10855560,10855561,10855562,10855563,10855564,10855565,10855566,10855567,10855568,10855569,10855570,10855571,10855572,10855573,10855574,10855575,10855576,10855577,10855578,10855579,10855580,10855581,10855582,10855583,10855584,10855585,10855586,10855587,10855588,10855589,10855590,10855591,7198681,10856913,10856914,3923567,10838792,8905114,8905115,8905116,8905117,8905280,8905281,8905282,8905283,8905284,8905285,8905286,8905287,8905288,8905783,8905784,8905785,8905786,8905787,10615439,10426341,10426392,10851996,10614078,10614079,10614080,10614081,10614082,10614083,10614084,10614085,10614086,10614087,10614088,10614089,10614090,10614091,10614092,10614093,10614094,10614095,10614376,10611799,10609239,8852024,8852025,8852026,8852027,8852028,8852029,8852030,8852031,8852032,8852033,8852034,8852035,8852036,8852037,8852038,10610348,10610349,10610350,10610351,7055523,6673701,7015406,7015407,7015408,7015409,7015410,7015411,7015412,7015413,7015414,7015415,7015416,7015417,7015418,7015419,9911973,7015420,7015421,9911974,7015422,7015423,7015424,7015425,7015426,7015427,7015428,7015429,7015430,7015431,7015432,7015433,7015434,7015435,7015436,7015437,7015438,7015439,7015440,7015441,7015442,7015443,7015444,7015445,7015446,7015447,7015448,7015449,7015450,7015451,7015452,7015453,7015454,7015455,7015456,7015457,7015458,7015459,7015460,7015461,7015462,7015463,7015464,7015465,7015466,7015467,7015468,7015469,7015470,7015471,7015472,7015473,7015474,7015475,7015476,7015477,7015478,7015479,7015480,7015481,7015482,7015483,7015484,7015485,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015498,7015499,7015500,7015501,7015502,7015503,7015504,7015505,7015506,7015507,7015508,7015509,7015510,7015511,7015512,7015513,7015514,7015515,7015516,7015517,7015518,7015519,7015520,7015521,7015522,7015523,7015524,7015525,7015526,7015527,7015528,7015529,7015530,7015531,7015532,7015533,7015534,7015535,7015536,7015537,7015538,7015539,7015540,7015541,7015542,7015543,7015544,7015545,7015546,7015547,7015548,7015549,7015550,7015551,7015552,7015553,7015554,7015555,7015556,7015557,7015558,7015559,7015560,7015561,7015562,7015563,7015564,7015565,7015566,7015567,7015568,7015569,7015570,7015571,7015572,7015573,7015574,7015575,7015576,7015577,7015578,7015579,7015580,7015581,7015582,7015583,7015584,7015585,7015586,7015587,7015588,7015589,7015590,7015591,7015592,7015593,7015594,7015595,7015596,7015597,7015598,7015599,7015600,7015601,7015602,7015603,7015604,7015605,7015606,7015607,7015608,7015609,7015610,7015611,7015612,10118156,7015613,7015614,7015615,7015616,7015617,7015618,7015619,7015620,7015621,7015622,7015623,7015624,7015625,7015626,7015627,7015628,7015629,7015630,7015631,7015632,7015633,7015634,7015635,7015636,7015637,7015638,7015639,7015640,7015641,7015642,7015643,7015644,7015645,7015646,7015647,7015648,7015649,7015650,7015651,7015652,7015653,7015654,7015655,8850178,8850179,8850180,8850181,8850182,9912663,9912664,9912665,9912666,9912667,9912668,9913005,9913006,10419257,6672711,6672712,6672814,9168748,9168749,9169096,9169097,9169098,9169099,9169100,9169101,9169102,10416076,10416113,10416118,10117445,10117482,10469389,10469390,10469391,10469392,10469393,10469394,10469395,10467814,9167970,10884178,10884605,10883443,10883444,10161848,10949011,10886881,10886882,10886883,10886884,10886885,10886886,10886887,10886888,10886889,10886890,10886891,10886892,10886893,10886894,10886895,10886896,10886897,10886898,10886899,10886900,10886901,10886902,10886903,10886904,10886905,10886906,10647390,10647391,10647578,10424427,10507598,10508603,10486247,10486248,10486249,10486250,10486251,10486252,10486253,10486254,10414099,10414103,10414104,10414123,10410694,10410695,10410696,10410697,10410698,10410699,10410700,10410701,10410702,10410703,10410704,10410705,10410706,10410707,10410708,10410709,10410710,10410711,10410712,10410713,10410714,10410715,10410716,10410717,10410718,10410719,10410720,10410721,10410722,10410723,10410724,10410725,10410726,10410727,10410728,10410729,10410730,10410731,10410732,10410733,10410734,10410735,10410736,10410737,10410738,10410739,10410740,10410741,10410742,10410743,10410744,10410745,10410746,10410747,10410748,10410749,10410750,10410751,10410752,10410753,10410754,10410755,10414869,10414876,10414883,10414884,10414935,10414941,10415031,10415032,10415033,10415034,10415035,10415036,10415037,10415038,10415039,10415040,10415041,10415042,10415043,10415044,10415045,10415046,10415047,10415048,10415049,10415050,10415051,10415052,10415053,10407112,10407118,10415169,10415179,10415198) 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'