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(10930103,10849607,8622250,8560943,8837691,8837921,8837922,10972504,10972505,10972506,10972524,10972525,10972533,10972534,10972535,10972536,10972537,10972538,10972539,10972540,10972550,10972555,10972569,10972570,10972577,10972581,10972582,10972591,10972600,10972601,10972606,10972607,10972608,10972609,10972610,10972611,10972612,10972613,10972614,10972615,10972616,10972617,10972618,10972619,10972620,10972621,10972622,10972623,10972624,10972625,10972626,10972627,10972628,10972629,10972630,10972631,10972632,10972633,10972634,10972635,10972636,10972637,10972638,10972639,10972640,10972641,10972642,10972643,10972644,10972645,10972646,10972647,10972648,10972649,10972650,10972651,10972652,10972653,10972654,10972655,10972656,10972657,10972658,10972659,10972660,10972661,10972662,10972663,10972664,10972665,10972666,10972667,10972668,10972669,10972670,10972671,10972672,10972673,10972674,10972675,10972676,10972677,10972678,10972679,10972680,10972681,10972682,10972684,7072651,10999609,10999610,10999611,8596110,11010547,10102251,8617229,8617230,10972399,10972401,10972403,10972419,10972421,10972424,10972428,10972429,10972430,10972431,10972432,10972433,10972434,10972435,10972436,10972437,10972438,10972439,10972440,10972441,10972442,10972443,10972444,10972445,10972446,10972447,10972448,10972449,10972455,10972456,8617611,8617613,10972495,10972497,10972498,10972499,10863760,7070083,10954924,8613140,8613141,8614215,8907528,8907529,10922481,11005668,10622409,10920607,10920633,10620345,10615356,10920901,10615451,3581957,3581959,10952452,10921517,10926721,10926722,10616224,10616232,10616237,10616238,10616239,8611319,10922464,6669982,9187578,10119837,10119838,10119839,10119840,10563586,9914116,9914117,9914118,9914120,9914121,9914122,6676121,9914123,6676122,6676123,9914124,9914125,6676124,6676125,9914126,9914127,6676127,9914129,6676130,9914131,9914132,6676131,9914133,9914134,6676133,6676134,9914135,9914136,6676135,6676136,9914137,9914138,6676137,6676138,6676139,6676140,9914141,9914143,9914144,9914145,9914146,9914147,9914148,9914149,9914150,9914151,9914152,9914153,9914154,9914155,9914158,9914159,9914160,9914161,9914162,9914163,9914164,9914165,9914166,9914168,9914169,9914170,9914171,9914172,9914173,9914174,9914175,9914176,9914177,9914178,9914179,9914180,9914181,9914182,9914183,9914184,9914185,9914186,9914187,9914188,9914189,9914190,10558541,8852584,8852588,8852589,8852964,9185462,9185463,9185465,8849510,10556395,10556396,10556397,10556398,10556399,10556400,10556401,8552297,9913247,9179195,9179196,10417224,4973183,4973184,6673143,9176942,9176943,9176946,9176950,9176951,9176952,8854238,9182933,9191161,8550492,8550493,8550495,10115642,10903490,10159513,10169595,10169596,10169894,10169895,10889208,10884488,10909699,10894750,10894753,10894754,10894755,10894756,10894761,10894762,10894763,10894767,10894768,10894769,10894770,10894771,10894775,10894777,10894778,10894779,10894780,10894781,10893379,10903451,10903452,10903453,10903454,10903455,10903456,10167015,10167016,10167017,10167018,10167019,10167021,10167022,10167031,10167032,10167033,10167034,10167035,10167036,10167037,10167041,10167043,10167045,10167049,10167057,10167058,10167063,10167064,10167065,10167070,10167071,10167072,10167073,10167074,10167075,10167080,10167082,10167085,10167086,10167087,10167088,10167089,10167091,10167092,10167093,10167095,10167102,10167104,10167109,10167117,10167120,10167121,10167122,10167124,10167125,10167126,10167127,10167128,10167129,10167130,10167131,10167132,10167133,10167134,10167135,10167136,10167137,10167138,10167139,10167140,10167141,10167142,10167143,10167144,10167146,10167148,10167149,10167150,10167151,10167152,10167154,10167155,10167156,10167157,10167158,10167160,10167161,10167162,10167164,10167165,10167166,10167167,10167169,10167170,10167172,10167173,10167174,10167176,10167179,10167181,10167182,10167183,10167185,10167186,10167187,10167188,10167189,10167193,10167195,10167197,10167199,10167201,10167203,10167204,10167206,10167207,10167209,10167213,10649436,10649437,10583711,10583712,10583713,10583714,10583715,10583716,10583717,10583718,10583719,10583720,10584734,10584735,10584736,10529435,10529794,10552885,10552886,10552887,10552888,10552889,10552890,10552891,10552892,10552893,10552894,10552911,10552912,10552913,10552914,10552915,10552916,10479994,10495076,10495078,10407171) 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'