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(10930387,10930447,11014966,10448362,8838986,10448382,10874048,10874049,11041541,11041542,11015563,11015564,11015565,11015566,10849606,8622187,8622188,8622189,11016190,11016191,8584191,8584192,11014508,10972624,10972625,10972627,10972633,10972637,10972639,10972641,10972642,10972643,10972645,10972646,10972647,10972648,10972649,10972659,10972667,10972668,10972683,8628590,8065976,7073028,10104564,4967996,8063977,3927440,10943133,10943248,10972397,10972399,10972402,10972403,10972404,10972406,10972407,10972408,10972409,10972411,10972412,10972413,10972414,10972415,10972416,10972418,10972419,10972420,10972421,10972423,10972425,10972426,10972427,10972428,10972429,10972430,10972431,10972435,10972442,10972447,10972450,10972451,10972452,10972453,10972454,10972457,10972458,10972459,10972460,10972461,10972462,10972463,10972464,10972465,10972466,10972467,10972468,10972469,10972470,10972471,10972472,10972473,10972474,10972475,10972476,10972477,10972478,10972479,10972481,10972484,3238220,10972487,10972489,10972491,10972492,10972493,10972494,10972495,10972496,10972497,10972498,10972499,10972500,10972501,10972502,10972503,10972507,10972508,10972516,10972517,10972520,10972529,10972531,10972537,10972543,10972551,10972552,10972553,10972554,10972556,10972557,10972559,10972560,10972561,10972563,10972573,10972576,10972577,10972579,10972580,10972584,10972592,10972601,10972603,10972604,10972605,10972606,10972607,10972608,10972609,10972610,10972619,10863761,3236374,3236375,3656886,11023002,7070657,3927128,11019650,11019651,11019697,11019698,8613139,7157492,10619300,10619301,10619302,10619303,10619304,10619305,10619328,7197598,10995155,3234909,10922481,11005668,11044702,11044703,10917715,10917716,10917717,10927890,10927891,10927892,10927893,10927894,10927895,10927896,11006168,10620344,11004034,10920901,10926051,10926052,10931015,10616223,10616227,10616240,10616242,10922464,8853825,9211343,9914116,9914117,6676121,6676122,9914124,6676124,6676125,6676126,9914127,9914128,6676127,9914131,6676132,9914134,9914135,6676135,9914136,6676136,6676139,9914143,9914144,9914145,9914149,9914156,9914157,9914166,9914167,9914171,9914179,9914180,9914822,8852581,8852582,8852585,8852586,7026496,7026497,7026498,7026499,7026500,7026501,7026502,7026503,7026504,10125559,9185455,9185456,9185457,9185458,9185459,9185460,9185461,9185462,9185463,9185464,10125852,10125853,10125854,10125855,10126077,7023742,7023743,7023744,7023745,7023746,7023747,7023748,7023749,7023750,7023751,7023752,7023753,7023755,7023766,10556395,10556396,10556402,10556403,8850647,8850648,8850654,8850671,9179194,9179197,10417225,4973183,4973184,4973188,6672789,6673143,9176941,9176945,9209032,6681349,10125354,8865164,8865165,8865166,8549918,10469401,6679399,6679517,8550491,8550492,6679548,6665648,6665649,6665650,6665651,6665652,6665653,6665654,6665655,6665664,6665665,6665666,6665667,6665668,6665669,6665670,6665671,10115644,8848067,10903490,10888710,10909133,10909134,10889179,10894755,10894761,10894763,10894764,10894766,10894769,10894771,10894772,10894773,10894774,10894775,10894779,10894781,10915233,10915234,10915235,10888301,10903450,10903451,10903452,10903453,10903454,10903455,10167020,10167021,10167026,10167029,10167031,10167033,10167037,10167040,10167041,10167042,10167043,10167044,10167045,10167046,10167048,10167049,10167050,10167054,10167055,10167056,10167060,10167066,10167067,10167068,10167069,10167089,10167091,10167095,10167099,10167110,10167114,10167115,10167117,10167122,10167123,10167124,10167125,10167126,10167127,10167128,10167129,10167147,10167149,10167159,10167163,10167175,10167178,10167190,10167199,10167203,10187730,10187732,10631259,10631260,10187979,10187980,10631797,10631798,10631799,10631800,10631801,10631802,10631803,10631804,10631805,10631806,10631807,10589646,10589647,10602722,10602734,10590577,10654322,10654323,10543165,10543166,10543167,10529793,10529794,10546451,10552881,10552885,10552895,10552896,10552897,10552898,10552899,10552900,10552911,10552917,10552919,10552920,10552921,10523038,10523039,10523040,10424641,10424642,10496463,10496464,10496465,10496466,10496467,10496468,10496469,10496470,10496471,10496472,10481636,10481637,10481638,10481878,10481879,10495147,10495148,10495149,10489350,10407176) 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'