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(10943624,10943625,10943626,10943627,7076342,7076344,7076366,10989334,10963354,10963355,7068739,7068740,7068741,7068742,7068743,7068744,7068745,7068746,7068747,10963445,7068762,7068763,7068764,10940400,7068782,7068783,10940406,7068784,10940407,7068785,7068786,7068787,7068788,7068789,8569771,10940424,7068803,8569780,8569790,10940440,10940441,7068819,10940442,10940443,8569799,8569800,7068834,7068840,7068842,10940466,7068846,7068854,7068860,10940492,7068869,10940493,7068871,7068872,7068874,8569850,8569851,8569852,7068876,8569853,7068878,8569854,8569855,8569856,8569857,8569858,8569859,7068883,8569877,8569878,8569884,8569885,10940532,8569886,7068917,7068918,7068919,7068920,7068921,7068922,7068923,7068924,10976651,7074064,7074065,7074066,7074067,7074068,7074069,7074070,7074071,7074072,7074073,7074074,7074075,7074076,7074077,7074078,7074079,7074080,7074081,7074082,7074083,7074094,8067540,10977305,10977306,10977307,10977308,10977309,10977310,10977311,10977312,10977313,10977314,10977315,10977316,10977317,10977352,10977353,10977354,10977355,10977356,10977357,10977358,10977359,10977360,10977361,10977362,10977363,10977364,10977365,10977366,10977367,10977368,10977369,10977370,10977371,10977372,10977373,10977374,10977375,10977376,10977377,10977378,10977379,10977380,10977381,7074703,7074704,10977418,10977419,10977420,10977421,10977422,10977423,10977424,10977425,10977451,10977452,10977453,10977454,10977455,10977456,10977457,10977458,10977459,7074882,10977577,10977578,10977579,10977580,10977581,10977582,10977583,10977584,10977585,10977586,10977587,10977588,10977589,10977590,10977591,10977592,10977593,10977594,10977595,10977596,10977597,10977598,10977599,10977600,10977601,10977602,10977603,10977604,10977605,10977606,10977607,10977608,10977609,10977610,10977611,10977612,10977613,10977614,8067859,8067968,8067969,8067970,8067971,8067972,8067973,8067974,8067975,8067976,8067977,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068065,8068086,8068087,8068088,8068089,8068090,8068091,8068092,8068093,8068094,8068095,8068096,8068173,8068174,8068175,8068176,8068177,8068178,8068179,8068180,8068181,8068182,8068183,8068184,8068185,8068186,8068187,8068188,8068189,8068266,8068267,8068268,8068269,8068270,8068271,8068302,8068335,8068336,8068337,8068338,8068339,8068340,8068341,8068342,8068343,8068344,8068345,8068346,8068347,8068348,8068407,8068408,8068409,8068410,8068411,8068412,8068413,8068414,8068415,8068416,8068417,8068418,7067541,7067542,8068452,8068458,8068459,8068460,8068468,10962293,8068530,8068531,8068532,8068533,8068534,8068535,8068536,8068537,8068538,8068539,10988342,10988343,10988344,10988345,10988346,10988347,10988348,10988349,10988350,10988351,10988352,10988353,10988354,10988355,10988356,10988357,10988358,10988359,10988360,10988361,10988362,10988363,10988364,10988365,10988366,10988367,10988368,10988369,10988370,10988371,10988372,10988373,8068718,8068719,7075859,10972620,10972621,10972622,10972623,10972624,10972625,10972626,10972627,10972628,10972629,10972630,10972631,10972632,10972633,10972634,10972635,10972636,10972637,10972657,10972658,10972659,10972660,10972661,10972662,10972663,10972664,10972665,10972666,10972667,10972668,10972669,10972670,10972671,10972672,10972673,7072372,10973060,10973061,10973062,10973063,10973064,10973065,10973066,10973067,10973068,10973069,10973070,10973071,10973072,10973073,10973074,10973180,10973181,10932206,8066191,8066192,8066211,8066212,8066213,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,8066274,8066275,8066276,8066277,8066278,8066294,8066295,8066309,8066310,8066311,8066312,8066313,8066314,8066315,8066339,8066340,8066341,8066359,8066360,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066429,8066430,8066431,8066432,8066451,8066452,8066453,8066454,10932841,10932842,8066472,10932843,10932844,10932845,10932846,10932847,8066481,8066511,8066512,8066513,8066514,8066515,8066516,7073647,8066882,8066885,10942630,10971781,10971782,10971783,11049100,7071240,10972017,10972018,10972019,10972020,10972021,10972048,10972049,10972050,10972051,10972052,10972053,10972054,10972055,10972056,10972085,10972100,8064693,10972455,10972456,10972611,10972612,10972613,10972614,10972615,10972616,10972617,10972618,10972619,10940561,7068962,7068987,7068988,7068989,7068990,7068991,7069005,7069006,7069007,7069012,7069340,3656309,3656310,3656318,3656319,3656320,3656321,3656322,3656323,3656324,3656325,3656326,3656370,3656371,8072723,8072724,8072725,8072726,8072727,10941808,3656990,3656991,3656992,3656994,11048694,11048695,7070813,7070814,10984610,10980620,10980621,10980622,10980623,10980624,10980625,10980626,10980684,10980700,10980701,10618218,10618219,10618902,10618903,10619076,10925111,10925112,10925113,10925114,10925115,10925116,10925117,10925118,10925119,10925120,10925121,10925122,10925123,10621979,10621980,10617582,10622677,10622678,10622679,10622680,10622714,10622727,10620106,10920692,10920693,10920694,10920695,10920696,10920697,10920698,10920699,10920700,10920701,10920702,10920703,10920704,10920705,10920706,10920707,10920708,10920709,10920710,10920711,10920712,10920713,10920714,10920715,10920716,10920717,10920718,10920719,10920720,10920721,10920722,10920723,10920724,10920725,10920726,10920727,10920728,10920729,10920730,10920731,10920732,10920733,10920734,10920735,10920736,10920737,10620323,10620324,10620328,10620329,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620414,10930749,10930750,10930759,10615836,10621122,10621123,10621153,10621154,10621247,10621248,10621249,10621250,10621251,10621269,10621294,10621295,10621310,10621311,10621312,10621313,10621314,10621315,10616327,10621341,10621342,10621363,10621364,10621365,10621366,10621367,10621373,10621389,10616389,10621390,10616390,10621391,10616391,10621392,10616392,10621393,10621394,10621395,10621396,10621583,10621637,10621638,10621668,10621669,10621670,10621718,10621719,10621720,10621721,10922293,10922308,10922309,10614538,7057842,7057843,7057844,7057845,10613232,10613233,10613234,7058750,8863172,7058832,7058833,7058834,8863314,8863315,8863316,8863347,8863348,8863349,8863350,8863351,8863384,8863406,8863407,8863433,8863434,8863435,8863454,8863455,8863456,8863457,8863458,8863459,8863460,8863461,8863497,8863498,8863499,8863517,8863542,8863543,8863544,8863545,8863546,8863547,8863548,8863549,8863550,8863625,7056386,7056387,7056392,7056393,7056394,7056402,7056403,7056413,7056414,7056415,7056416,7056434,7056461,7056462,7056534,7056535,7056536,7056537,7056538,7056794,7056795,7056807,7056808,7056809,7056810,7056823,7056828,2809382,7057304,7057305,7057313,7057315,7057316,7057317,10415228,10415300,10415302,8918219,8918220,4973426,4973427,10416138,10416139,10416166,10416167,10466954,10463004,10463009,10463028,10463029,10467096,10467097,10467115,10467116,10467117,10467132,10467133,10467150,10463397,10463398,10467429,10467440,10471537,10471541,10463656,4971936,4971937,4971938,4971939,4971941,4971948,4971951,4971956,4971963,4971964,10465689,4971965,10465690,4971966,4971967,4971977,4971983,4971984,4971985,4971986,4971987,4971992,4971998,4971999,4972000,4972001,10463729,4972021,4972022,10463755,10463756,10463757,10465758,10465762,4972038,10465763,4972039,4972040,10465781,10465782,4972058,10465783,4972059,4972060,4972061,4972062,4972063,10463795,10463796,10463797,10463798,10463799,10465822,4972098,10465823,10465824,10465825,10465826,4972102,10465827,4972103,4972114,10465880,10465881,10465882,10465883,10465884,10465885,10463896,10463897,10463898,10463899,10463900,10463901,10463902,10463903,10463904,10465916,8917189,8917197,8917245,10466216,10466217,10466218,10466219,10466306,10466307,10466325,10466326,10466327,10466369,10466370,10466371,10466372,10466373,10462397,10462400,10462402,10462414,10462415,10466427,10466428,10466429,10466430,10466431,10462444,10462445,10462446,10462506,10462507,10462508,10462509,10462510,10462511,10462512,10462513,10462514,10462515,10462599,10462600,10462601,10462602,10462603,10462604,10462605,8917849,4973066,10466846,10629818,10629819,10629823,10629824,10629825,10629826,10629827,10625152,10625153,10630253,10630254,10630255,10626167,10626168,10626170,10626176,10626571,10626952,10521152,10520151,10522838,10523057,10421393,10421073,10421079,10421087,10421088,10421095,10421098,10421100,10421101,10473747,10473748,10473749,10473750,10473751,10473752,10473753,10473754,10473755,10473756,10473757,10473758,10473759,10473760,10473761,10473762,10473763,10473764,10473765,10473766,10473767,10473768,10473769,10473770,10473771,10473772,10473773,10473774) 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'