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(10447924,8574295,8574296,7068469,7068470,7068471,7068472,7068473,7068474,7068475,7068476,7068477,7068478,7068479,7068480,10873978,8583200,8583201,8583202,10950373,10871061,10976513,10976514,10976515,10976516,10976517,10976518,10976519,10976520,10976521,10976522,10976523,10976524,10976525,10976526,10976527,10976528,10976529,10976530,10976531,10976532,10976533,10976534,10976535,10976536,10976537,10868484,10868485,8067268,8583985,8575858,10437541,10437542,8609760,8609761,8609762,10938725,10938726,10938727,10938728,10103119,8594761,8594762,8594763,8594764,8594765,8594766,8559103,7064474,7064475,7064476,8618355,8618357,8595538,8595539,8595540,3899464,8572235,8572236,8619057,8595926,8595927,8595928,8837000,10844412,7073807,4968037,4968038,4968039,4968040,4968041,4968042,4968043,4968044,4968045,4968046,4968047,3227270,8910199,8910200,11049054,10102300,10998043,10998044,10998045,10998046,10998047,10998048,10998049,10998050,10998051,10998052,10998053,10998054,10998055,10998056,10998057,10998058,10998059,10998060,10998061,10998062,10998063,10998064,10998065,10998066,10998067,10998068,10998069,10998070,10998071,10998072,5999947,8558629,8558630,8558631,6000038,7071922,7071923,7071924,7071925,7071926,3926304,3926305,3926306,3926307,8615867,8615868,8615869,8615870,8615871,8615872,8615873,8615874,8625974,8625975,8625976,8625994,8625995,8625996,8625997,8625998,8625999,10841219,10841220,10841221,10942209,8557605,8557606,8557607,7156541,3234177,3924307,3924308,10954035,10954036,10954037,10954038,10954039,10954040,10954041,10954042,10954043,10954044,10954045,10954046,10954047,10954048,10954049,10954050,10954051,10954052,10954053,10954054,10954055,10954056,10954057,10954058,10954059,10954060,10954061,10954062,10954063,10954064,10954065,10837145,10837146,10837147,3922900,3922901,10850729,10850730,10850731,10850732,10850733,11043325,10620862,10620863,10620864,10620865,10620866,10620867,10620868,10620869,10620870,10620871,10930912,9217623,9217646,8904452,8904453,6665793,8864368,8864369,3655103,3655104,9174232,9174233,9174234,9174235,7057877,7058584,7058588,10561588,10561589,10561590,10561591,10561592,10561593,10561594,10561595,10561596,10561597,9177478,9177479,9177480,9177481,9177482,9177483,9177484,9177485,9177486,9177487,9177488,9177489,9177490,9177491,9177492,9177493,9177494,9161550,9161551,9161552,9161553,9161554,9161555,9161556,9161557,9161558,9161559,9161560,9161561,9161562,9161563,9161564,9161565,9161566,9161567,9161568,9161569,9161570,9161571,9161572,9161573,9161574,9161575,9161576,8551593,8565770,8565771,8565772,4973463,4973464,4973465,4973466,4973467,10122908,10122909,10122910,10122911,10122912,9190783,9190784,9190785,9190786,9190787,9190788,9190789,9190790,9190791,9190792,9190793,9190794,4971875,10463696,10463697,10463698,10463699,10463700,10463701,10463702,10463703,10463704,10463705,10463706,10463707,10463708,10463709,10463710,10463711,10463712,10463713,10463714,10463715,10463716,10463717,8917569,8917570,10116157,9207994,9208002,8917734,9208090,10179825,10629137,10907544,10907545,10907546,10907547,10907548,10907549,10907550,10907551,10907552,10907553,10627173,10627174,10627175,10627176,10627177,10627178,10627179,10912856,10896034,10896035,10896036,10896037,10896038,10896039,10896040,10896041,10896042,10896043,10896044,10896045,10896046,10896047,10896048,10896049,10896050,10896051,10896052,10896053,10896054,10896055,10896056,10896057,10896058,10896059,10896060,10172256,10172257,10911905,10173134,10877138,10877139,10877140,10877141,10877142,10877143,10877144,10877145,10877146,10877147,10877148,10877149,10877150,10877151,10877152,10877153,10877154,10877155,10877156,10877157,10877158,10877159,10877160,10877161,10877162,10877163,10877164,10877165,10912353,10587277,10644385,10644386,10644387,10644388,10644389,10644390,10644391,10644392,10644393,10644394,10644395,10644396,10587599,10587600,10587601,10587602,10604048,10604049,10604050,10604051,10604052,10604053,10604054,10604055,10604056,10604057,10604058,10604059,10604060,10604061,10604062,10604063,10604064,10604065,10604066,10651457,10651458,10651459,10648996,10648997,10648998,10648999,10601059,10601060,10519406,10543442,10529456,10541561,10541562,10541563,10541564,10541565,10541566,10541567,10541568,10541569,10541570,10541571,10541572,10541573,10541574,10551923,10551924,10551925,10551926,10551927,10551928,10551929,10551930,10551931,10534219,10522953,10522954,10522955,10422607,10421019,10478949,10478950,10478951,8562352,10496064,10407982,10407983,10407984,10407985,10407986,10490642,10492770,10486983,10486984) 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'