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(10870226,10870227,10870303,10870304,10870363,10870530,11003090,11003091,11016113,11016114,11016115,11016116,11016117,11016118,8067436,11016170,11016171,11016172,11016173,11042203,11042204,8067518,11042325,11042326,11042327,11029396,11003451,11003452,11003453,11039839,11026871,11026872,11026873,11026888,11026889,11039889,11026890,11013891,10870042,10870043,10870044,10870045,10870051,10870124,3238420,3238421,3238422,3238423,3238424,3238425,3238426,11037703,11037704,11037705,11037706,10866357,11037791,11037792,11037865,11037866,11037867,11037868,10985959,11037965,10843076,10986045,11038046,10986073,11038124,11038195,11038297,8836245,10932185,10932186,10932187,10932188,10932189,10960649,11000103,11000104,11000105,11000106,11000217,10961221,11000233,11000234,11000235,8596204,11000251,11000252,11000402,10961466,11039538,11039578,11048925,3927492,3927576,3927577,8617244,8617251,10943185,11024252,11024253,11034653,11034654,11034669,11034752,11034753,3925466,3925475,11034835,11034925,11034926,11034927,11034928,10863546,11034948,11034989,11035208,11035211,11035212,11035213,11035214,11035215,11035234,11035261,11035262,11022445,11022446,10840711,10840732,10941706,10941707,10941708,3236647,3236648,11023239,11023240,11023241,3237135,7070735,7070736,3237176,3237177,11023615,3233439,3233445,11032762,11032763,11032764,3233910,3233928,3923935,7157260,7157261,11020591,10994647,11033698,11033699,11033700,11033701,11033702,11033703,11033939,11033940,11033941,11033942,11033943,11034148,11047276,11034375,11034546,10953706,11005715,11005716,11005717,10992722,8541599,10992792,10966800,10966801,10966802,10966817,10966818,10992932,10992933,10992934,10992935,10992936,10992937,10992938,10992939,11031953,11031954,11031955,11031956,11031957,11031958,11031959,11031960,11031961,10993042,10993099,10993100,10993101,8578677,8578763,8578764,8578765,8578766,10993292,10993306,10993307,10993334,11006457,10967568,11003640,11003816,10920747,10920748,8570206,11004041,10926014,10926015,11004266,11004267,10926157,11004513,11004514,10991520,10991521,10991522,10991523,10991524,10991525,10991526,10991527,10991528,10991529,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10991541,10991542,10991543,10991544,10991545,10991546,10965577,10965578,10965579,10965580,10965581,10965582,10965583,10965584,10965585,10965586,10965587,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,10921589,11004742,11004743,11030851,11030852,10926730,10966048,10966049,10966050,10966061,10966062,10966063,10966064,10966065,8577774,8577775,11031585,10992612,10992613,9189340,7019045,7019076,7027080,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10122077,10122078,9173978,10122191,10122192,10122234,10122235,10122236,10122281,10122335,9190187,7057501,7057502,7025295,7025354,7025564,7025771,7026136,7026692,7026771,7026882,10125608,8849433,9185633,9185634,9185635,9185636,9185637,9185638,9185639,9185640,9185713,7056101,7056115,7023638,9186326,9186431,7024122,7024138,9186520,7024201,9186607,9186608,9186866,10119369,7021966,6672555,9192349,9192350,9192351,9192352,9192353,9192354,9192355,9192356,9192357,9208739,9208773,10417079,7022878,10125429,10125430,7020268,9198998,7020726,6667151,10123364,9175510,9175539,9175585,9175586,9175629,6474288,7021760,10903576,10903577,10903578,10903579,10903580,10903581,10903587,10909020,10909021,10629030,10155849,10879869,10163529,10163530,10158719,10877722,10627343,10183980,10183981,10905816,10166967,10167645,10167646,10167702,10167703,10167704,10167705,10167706,10167919,10167920,10168085,10168089,10168090,10168091,10168092,10163238,10626824,10183407,10583665,10583666,10583878,10590930,10590931,10590932,10590933,10590934,10590935,10654048,10585536,10585537,10585538,10539144,10539145,10539146,10531381,10531382,10531383,10531538,10529877,10529878,10529879,10529880,10529881,10529882,10529883,10529884,10529885,10529886,10529887,10529888,10529889,10529890,10529891,10529892,10529893,10529894,10529895,10529896,10529897,10529898,10529899,10529900,10529901,10529902,10529903,10529904,10529905,10529906,10529907,10531933,10522011,10522012,10530070,10532080,10532179,10532181,10532182,10532183,10532184,10532185,10534186,10534187,10532328,10548329,10548330,10548331,10548332,10548333,10548334,10530708,10520740,10520741,10520742,10520813,10532957,10532958,10533081,10421967,10421968,10421969,10421973,10422004,10422035,10422036,10422060,10422061,10422116,10493072,10493084) 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'