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(7201614,7201615,8068857,8835915,8835916,10873835,10873851,10873880,7076109,8618532,8618533,8618534,8618535,8618536,8618537,8618538,8618539,8618540,8618541,8618542,8618543,8618544,10859130,7202257,10198798,10198800,8628775,10843911,10843968,8560186,10844074,8619200,8619201,10933327,7073986,10844280,10844281,10844282,10099869,3227186,7074243,7066269,8837282,10100010,8560833,8560839,10929400,10251870,10226001,8558297,10249122,10249123,10249124,10249125,10249126,10249127,10249128,10249129,10249130,10249131,10249132,10249133,10249134,10249135,10249136,10249137,10249138,10249139,10249140,10249141,7075119,8835126,8910780,10236537,8558827,8558828,8558829,7067471,7201326,8618046,8618047,8627893,8627894,8627899,8627900,8627902,8627903,8627904,8627905,8627906,8627920,8627921,8627922,8627925,8627926,8627928,8627929,8627930,8627931,8627932,8627933,8594942,8594943,6000278,10840448,10840449,10234784,10101515,10196321,10932546,10932547,10932548,10932549,10932550,10932551,10932552,10932553,10932554,10932555,7073198,3927181,10248606,8626548,8626549,8626550,8626551,8626552,3927459,7073575,10933058,10933059,10933060,7065654,7065683,8558284,8558285,8558286,8558287,8558294,8558295,8558296,10942553,10942554,8861193,10839573,10839574,10839575,10839576,10839594,8861379,10207784,10207785,10257068,10257069,10257070,10257071,10257072,10257073,10257074,10257075,10257076,8542007,8612401,8542210,7156460,3923455,10853650,10245171,10245298,10245299,8613741,8613742,8613743,8613744,8613745,8613746,8613747,8613748,8613749,8613750,7157467,10245707,3924419,3924420,10867322,3234555,10245858,3234598,10281098,3582039,3582040,3582041,3582042,3582043,3582044,3582045,3582046,3582047,3582048,10623373,10623464,9217520,9217521,9217720,9217721,9217722,9217723,8577647,8541089,8541244,10269782,10217793,8612028,10865620,10865621,10927483,10927484,10927485,10927486,10922490,10927494,10228125,10215231,10215232,10215233,10215234,10215235,10215236,10215237,10215238,10215239,10215240,10254240,10215241,10622516,3230391,8609838,8632704,8576285,8576286,8576287,10254882,10850608,10850609,10850610,10850611,10268051,10268052,10845109,10845110,10845111,10845112,10845113,8630064,8630094,8630095,8630113,10615222,8561589,10925821,8620703,10930145,10278617,10278618,10278619,10278620,10278621,10278622,10278623,10278624,10278625,10278626,10278627,10278628,10278629,8570377,8570378,10861282,10252764,10252765,10252766,10252767,10252768,10252769,8838541,10930368,10201060,10279171,8621345,8621346,8621347,8621348,8621349,8621350,8621351,8621352,8621353,8621354,8621355,8621356,8621357,10848977,10926897,10266661,10846979,10846980,10922469,7059512,7059513,7059514,7059724,7059725,9916005,8568325,10559698,10559699,6678163,9198015,9198016,9198017,9198018,9198019,9198020,9198021,9198022,9198023,9198024,10614858,8549450,8542528,10563195,10563196,10563197,10563198,10563199,10563200,10563201,10563202,10563203,10563204,10563205,10563206,10563207,10563208,10563209,10563210,10563211,10563212,10563213,10563214,10563215,8566135,7057863,8067356,8067357,8067358,8851656,9171876,8851705,10612546,9195924,10612623,10612715,8067735,7017910,7017911,7017912,7017913,6676569,6676570,8862898,8862899,9914627,10558621,10558650,10558651,10558670,10558671,10558672,10558673,9172909,9189126,9189213,9189222,7015068,9201422,8849260,10117739,9911825,9911826,4974570,8849961,3286096,9178679,9178680,9178681,9178682,9178683,9178684,9178685,10118988,9913049,9913056,9203020,9203021,10516909,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10517025,10517026,10517027,9168328,8918020,8918021,10117034,10117066,10418849,10418850,10117141,10117219,4973922,4973923,4973924,10428481,10125308,7055445,6666518,6678849,6666807,9174846,9174847,9166876,10471540,9917194,9917195,3656198,9207188,9207189,9207190,10123431,6679493,8916986,10123777,9207585,9207586,8550745,6667653,10116136,8917607,8917608,8917609,8917610,8917611,8917612,6667981,8847931,8551269,8917787,8917788,7013827,9176226,9176227,9176228,10179599,10898711,10169874,10169875,10169876,10159897,10628491,10884087,10175136,10175137,10175138,10175139,10175371,10175372,10175373,10175374,10175375,10175376,10175377,10175378,10175379,10175380,10175381,10175382,10175383,10175384,10175385,10175386,10175387,10175388,10175389,10175390,10170674,10170675,10170911,10156359,10920404,10920405,10920406,10920407,10156420,10912813,10907836,10179053,10179054,10179055,10179056,10179057,10179058,10918095,10174380,10913448,10166508,10905793,10905794,10910946,10910947,10910948,10910949,10910950,10910951,10911001,10911002,10911003,10911004,10911005,10911006,10658566,10187467,10187468,10187469,10187470,10187471,10157513,10916690,10916691,10916692,10916693,10916694,10916695,10916696,10916697,10916698,10187780,10187790,10187870,10631444,10631445,10188093,10188204,10907430,10610965,10574236,10574237,10652314,10652466,10652467,10652468,10652469,10598858,10598859,10572154,10572155,10569655,10572837,10572838,10572839,10572840,10653975,10653976,10575939,10570018,10582445,10582446,10582447,10582448,10582449,10582450,10582451,10591803,10591804,10523661,10546166,10546167,10546168,10546169,10550173,10550174,10520271,10520272,10520273,10534371,10538766,10522788,10415249,10415250,10424462,10424478,10424508,10508426,10508427,10508428,10508429,10508430,10508431,10508432,10505941,10505942,10505943,10505944,10505945,10505946,10505947,10505948,10505949,10505950,10505951,10505952,10505953,10505954,10505955,10489902,10489903,10489904,10489905,10489906,10489907,10489908,10489909,10489910,10489911,10489912,10473200,10473201,10473202,10473203,10473204,10473205,10413629,10409672,10492395,10492396,10492397,10486560,10492765,10490910,10490911,10474297,10495543,10415030) 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'