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(10988886,10940010,10940011,8569415,8569460,7068485,10459092,10459093,10459094,10459095,10459096,10459097,10459098,10459099,10459100,10459101,10459102,10459103,10459104,8569543,9215238,9215239,9215240,7068604,7068611,7068677,8569766,8569767,8569768,10871251,9216121,8632391,10987639,7075028,9214434,7067930,10842740,7201311,7201312,10842903,10842904,10842905,10842906,10842907,10842908,10842909,8618013,10843052,10843053,10931815,8628118,8628119,8628120,8628121,8628122,8628123,8628124,8628125,8628126,8628127,8628128,10986168,8628129,8628130,8628131,8628132,8628133,8628134,8628135,8628136,8628137,8628138,8628139,8628140,8628141,8628142,8628143,8628144,8835989,8628145,8835990,8628146,8835991,8628147,8835992,8628148,8628149,8628150,8628151,8628152,8628153,8628154,8628155,8628156,8628157,8628158,8628159,8628160,8628161,8628162,8628163,8628164,8628165,8628166,8836061,8836062,10986258,10986259,10986260,10986261,10986262,10986263,8836068,10986264,10986265,8836078,7201884,7064680,7064681,10843438,8628486,10986722,10986723,10986724,10986725,10986726,10986727,10102255,10102256,10102258,10984924,10984925,10102677,10842337,7200934,10102946,8624682,8624683,8624684,8624688,8624691,8624692,10940969,10940973,10941000,10941004,8908467,8908468,8908469,8908470,8908471,8908472,8908473,8908474,8908475,8908476,8908477,8908478,8908479,8908480,8908481,8908482,8908483,8908484,8908485,8908486,8908487,8908488,8908489,8908490,8908491,8908492,8908493,8908494,8908495,8908496,8908497,8908498,8908499,8908500,8908501,8556591,8615530,8615531,7069706,7069717,7069718,8625382,8625383,8625384,8625385,8625386,8625387,8625388,8625389,8625390,8625391,8625392,8625393,8625394,8625395,8625396,8625397,8625398,8625399,8625400,8625401,8625402,8625403,8625404,8625405,8625406,8625407,8625408,8625409,8625410,8625411,8625412,8625413,8625414,8625415,8625416,8625417,7069772,8625418,8616154,8616157,10101725,10623094,3923523,3923528,3923529,3923530,10618333,10838095,10623490,10623491,10623492,10623493,10623494,10623518,3924230,3924356,11008072,3925015,3925038,8614566,8614597,10839613,10839614,8611917,8612203,3232805,3232806,3232807,3232808,3232809,3232810,3232811,3232812,3232813,3232814,3232815,3232816,3232817,3232818,3233005,3233006,10622876,8569923,8569924,8569925,8569926,8569927,8569928,8569929,8569963,10615074,10615075,10615076,8570087,10615495,8633265,8633266,8633267,8633282,3582102,10620859,10620860,10620861,10616002,10616003,10616004,10616005,8540519,8540520,8540521,8540522,10616059,8611396,10616785,10616855,10616856,10616862,10616864,10616872,10616880,10616881,6665743,6665744,6665745,6665746,8853656,6666000,10614732,10614733,10614734,8542556,7058102,8851875,8851886,8851887,8851888,8851889,8851890,8851891,8851892,10610001,10610002,10610003,10610004,10610005,10610024,9172367,9172368,9172531,8852541,10610418,10121018,10121019,10121020,10121021,10121022,10121027,10121030,8567512,8567513,8567525,10613750,8863774,3654490,3654491,3654492,3654493,3654494,3654495,3654496,3654497,3654498,3654499,10117690,9161528,9177712,9169829,9169939,10118384,8850061,8850062,8850063,8850064,8850065,10118494,10118501,10118502,9912729,8850596,8850597,10118984,10119087,7057156,7057216,9168968,9168988,9168989,9185123,10122942,10122943,10122944,10122945,10122946,9198800,10123119,10123120,10123121,9182928,6667075,6667076,6667080,6667081,6667082,8916795,9183329,9183330,9183331,9183332,9191585,9191586,9191734,9191789,9191795,9191868,10116353,10116354,10893968,10171143,10171144,10171145,10627190,10153849,10173852,10627526,10900674,10900742,10161757,10161758,10161759,10900747,10161760,10900748,10900749,10161761,10161762,10161763,10900847,10625911,10167599,10167600,10167609,10167625,10631315,10590997,10590998,10590999,10591000,10591001,10591002,10591003,10591004,10591005,10527839,10527840,10527841,10527842,10527843,10527844,10527845,10527846,10527847,10526420,10526421,10526422,10526423,10526424,10526425,10526426,10526427,10526428,10526429,10526430,10546626,10546627,10546628,10546629,10546630,10524893,10544963,10544964,10544965,10544966,10544967,10544968,10544969,10544970,10544971,10482876,10482877,10482878,10482879,10482880,10482881,10482882,10482883,10482884,10482885,10482886,10482887,10482888,10482889,10482890,10482891,10482892,10482893,10482894,10482895,10482896,10482897,8562381,8562396,8562426,8562428,8562430,8562434,8562437,10408818,8562058,10482848,10482849,10482850,10482851,10482852,10482853,10482854,10482855,10482856,10482857,10482858,10482859,10482860,10482861,10482862,10482863,10482864,10482865,10482866,10482867,10482868,10482869,10482870,10482871,10482872,10482873,10482874,10482875) 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'