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(10861441,10861442,10861443,10861444,10861445,10861446,10861447,10861448,10861767,8583519,8583520,10950679,10861115,10861116,10861117,10861118,10861119,10861120,10861121,10861122,10861123,10861124,10861125,10861126,10861127,10861128,10861129,10861130,10861131,10861132,10861133,10861134,10861135,10861136,10861137,10861138,10861139,10861140,10861141,10861142,10861143,10861144,10861145,10861146,10861147,10861148,10861149,10861150,10861151,10861152,10861153,10861154,10861155,10861156,10861157,10861158,10861159,10861160,10861161,10861162,10861163,10861164,10861165,10861166,10861167,10861168,10861169,10861170,10861171,10861172,10861173,10861174,10861175,10861176,10861177,10861178,10861179,10861180,10861181,10861182,10861183,10861184,10861185,10861186,10861187,10861188,10861189,10861190,10861191,10861192,10861193,10861194,10861195,10861196,10861197,10861198,10861199,10861200,10861201,7201339,7201340,7201341,7201342,7201343,8595180,7201783,7201784,7201785,7201786,7201787,7201788,10859523,7202525,7202526,10865280,10865282,10865284,10865286,10865288,10865290,10865292,10865294,10865296,10865298,10865300,10865314,10865316,10865318,10865322,10865324,10865326,10865327,10865332,10865334,10865336,10865338,10865339,10865340,10865342,10865343,10865345,10865347,10865349,10865351,7200407,8910445,8910446,8910447,8910448,8627085,8556311,10856121,10856122,10856123,10864441,10864442,10864443,10864444,10864752,10864754,10864756,3923580,3923581,3923582,3923583,8907406,10855008,10855010,8905824,8611309,8611387,10614227,10614228,10614229,10614230,10614231,10614232,10614233,10614234,10614235,10614236,10614237,10614238,10614239,10614240,10614241,10614242,10614243,10614244,10614245,10614246,10614247,10614248,10614249,10614250,10614251,10614252,10614253,10614254,10614255,10614256,10614257,10614258,10614259,10614260,10614261,10614262,10614263,10614264,10614265,10614266,10614267,10614268,10614269,10614270,10614271,10614272,10614273,10714158,10614377,10611969,8566699,8566700,8566701,8566702,8852060,8852061,8852062,8852063,8852064,8852065,8852066,8852067,8852068,8852069,8852070,8852071,8852072,8852073,8852074,8852075,8852076,8852077,8852078,8852079,8852080,8852081,8852082,8852083,8852084,8852085,8852086,8852087,8852088,8852089,8852090,8852091,8852092,8852093,8852094,8852095,8852096,8852097,8852098,8852099,8852100,8852101,8852102,8852103,8852104,8852105,8852106,8852107,8852108,8852109,8852110,8852111,8852112,8852113,8852114,8852115,8852116,8852117,8852118,8852119,8852120,10613741,10610869,10610870,10610871,8853092,10610948,6673712,6673713,6673714,6673715,6673716,6673717,6673718,6673719,6673720,6673721,6673722,10118179,10118180,10118181,10118182,10118183,10118184,10118185,10118186,10118187,10118188,7015694,7015695,7015696,7015697,9912711,9912712,9912713,9912714,9912715,9912716,9912717,9912718,9912719,9912720,9912721,9912722,10415377,10418586,10418588,10418590,10418592,10418595,10418597,10418599,10418601,10418603,10418605,10418607,10418609,10415616,10418623,10418624,10418626,10418628,10418630,10418632,10418634,10418636,10418638,10418639,10418641,10418646,10418648,10418650,10418652,10418653,10418654,10418656,10418658,10418660,10418662,10418664,6673014,10417752,10417753,10417754,10417755,10418063,10418065,10418067,9169173,9169174,9169175,9169176,9169177,9169178,9169234,10469503,8550084,8550085,8550086,8550087,10427661,10888705,10175057,10175058,10889589,10153837,10153838,10153839,10153840,10153841,10153842,10153843,10153844,10162105,10162106,10162107,10162108,10887098,10887099,10887100,10887101,10887102,10887103,10887104,10887105,10887106,10887107,10887108,10887109,10887110,10887111,10887112,10887113,10887114,10887115,10887116,10887117,10887118,10887119,10887120,10887121,10887122,10887123,10887124,10887125,10887126,10887127,10887128,10887129,10887130,10887131,10887132,10887133,10602172,10602179,10602689,10602708,10602709,10647588,10603683,10508326,10507809,10411235,10411236,10411237,10413979,10496728,10496729,10496730,10410221,10410224,10415121,10415122,10415123,10415124,10415125,10415126,10415127,10415128,10415129,10415130,10415131,10415132,10415133,10415134,10415135,10415136,10415137,10415138,10415139,10415140,10415141,10415142,10415143,10415144,10415145,10415146,10415147,10415148,10415149,10415150,10415151,10415152,10415153,10415154,10415155,10415156,10415157,10415158,10415159,10415160,10415161,10415162,10415163,10415164,10415165,10415166,10415167,10415168) 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'