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(4970670,10944265,7065947,8583441,8629478,8629481,8067927,8629688,8629695,10860733,7201676,8595163,10866810,10866813,10866814,10866821,10866823,10866837,10866838,10866839,10866843,10866844,10866846,10866864,10866865,10866866,10866926,10866953,10866954,8628440,10859208,8595719,7202367,7202369,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202412,7202413,7202415,7202417,7202419,7202421,7202423,7202425,7202427,7202430,7202432,10865254,10865255,10865256,10865257,10865258,10865259,10865260,10865261,10865265,8834765,7200523,7200524,8910466,10857791,7198368,7198720,10855783,10855784,10855785,10855786,10855787,10855788,10855789,10855790,10855791,10855792,10855793,10855794,10855795,10855796,10855797,10855798,10855799,10855800,10855801,10855802,10855803,10855804,10855805,10855806,10855807,10855808,10855809,10855810,10855811,10855812,10855813,10855814,10855815,10855816,10855817,10855818,10855819,10855820,8908715,8908716,8908750,8908753,8908755,7199005,3923417,3923418,3923419,3923420,11045737,11045738,11045739,11045740,10853394,10854103,8905015,8905167,8905168,8905169,8905170,8905171,8905172,8905173,8905174,8905175,8905176,8905177,8905178,8905179,8905180,8905184,8905185,8905186,8905187,8634953,10622456,10617471,10617476,10617482,10617501,8540643,8853198,8863986,10609585,10609586,10612673,10612711,10612862,10609975,10609979,10610272,10610503,10610504,10610505,10610506,10610511,10610512,10610513,10610514,10610515,10610516,10610517,10610518,10610519,10610520,10610521,10610522,10610523,10610524,10610525,10610526,10610527,10610528,10610529,10610530,10610531,10610532,10610533,10610534,10610535,10610536,10610537,10610538,10610539,10610540,10610541,10610542,10610543,10610544,10610545,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10613722,10117584,10117585,10117586,10117587,10117592,10117593,10117594,10117595,10117596,10117597,10117598,6673685,9911741,8592692,9911983,9911984,9911985,9911986,9911987,9911988,9911989,9911990,9911991,9911992,9911993,8850229,8850230,8850231,8850232,8850233,8850234,8850235,8850236,8850237,8850238,8850239,8850240,8850241,8850242,8850243,8850244,8850245,8850246,8850247,8850248,8850249,8850250,8850251,8850252,8850253,8850254,8850255,8850256,8850257,8850258,8850259,8850260,8850280,8850281,8850282,8850283,8850284,8850285,8850286,8850287,8850288,8850289,8850290,8850291,8850292,8850293,8850294,8850295,8850296,8850297,8850298,8850299,8850300,8850301,8850302,8850303,8850304,8850305,8850306,8850307,8850308,8552175,9913295,6672722,6672723,6672724,10418561,10418562,10418563,10418564,10418565,10418566,10418570,10419675,10419677,10419678,10419687,10419689,10419694,10419708,10419709,10419710,10419714,10419715,10419717,10419745,10419746,10419747,10419807,10419837,10419838,8848785,8549972,3963318,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,9167708,9167996,9167997,9167998,9168000,9168001,8848052,8848053,8848054,10427638,10427639,10883499,10883500,10883501,10883502,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10884069,10632011,10161850,10161851,10161852,10161853,10161854,10161855,10161856,10161857,10161858,10647389,10647397,10647398,10647401,10647402,10647403,10647404,10647405,10647406,10647407,10647408,10647409,10647410,10647411,10409551,10410938,10410939,10410940,10410941,10410942,10410943,10410944,10410945,10410946,10410947,10410948,10410949,10410950,10410951,10410952,10410953,10410954,10410955,10410956,10410957,10410958,10410959,10410960,10410961,10410962,10410963,10410964,10410965,10414966,10410966,10410967,10410968,10410969) 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'