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(8630478,8630479,8630480,8630483,8630484,8630485,8630486,8630487,8630488,8630489,8630490,8630496,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630528,8630529,8630530,8630531,8630532,8630533,8630534,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8630579,8630580,8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630698,8630699,8630700,8630701,8630702,8630703,8630718,8630719,8630720,8630744,8630747,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630757,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630798,8630804,8630807,8630810,8630811,8630812,8630838,8630839,8630843,8630847,8630852,8630853,8630854,8630855,8630856,8630858,8630859,8630860,8630861,8630862,8630886,8630892,8630896,8630897,8630899,8630900,8630902,8630903,8630906,8630907,8630908,8630958,8630959,8630960,8630963,8630964,8630965,8630966,8630967,8630970,8630971,8630972,8630973,8630974,8630976,8630977,8630987,8630988,8630989,8630990,8630991,8630993,8630996,8631001,8631002,8631003,8631007,8631013,8631030,8631042,8631046,8631047,8631048,8631049,8631050,8631051,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8631062,8631063,8631064,8631065,8631066,8631067,8631068,8631069,8631070,8631071,8631073,8631075,8631076,8631090,8631098,8631099,8631100,8631117,8631118,8631127,8631128,8631129,8631130,8631132,8631133,8631136,8631137,8631139,8631140,8631141,8631142,8631147,8631161,8631172,8631173,8631174,8631175,8631176,8631177,8631178,8631179,8631188,8631190,8631191,8631205,8631206,8631207,8631255,8631256,8631257,8631258,8631259,8631260,8631261,8631262,8631263,8631264,8631265,8631266,8631267,8631268,8631269,8631270,8631271,8631272,8631273,8631274,8631276,8631346,8631347,8631382,8631383,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,8631399,8631401,8631402,8631403,8631404,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631422,8631423,8631424,8631425,8631428,8631429,8631430,8631431,8631432,8631433,8631434,8631435,8631437,8631438,8631439,8631440,8631441,8631442,8631443,8631450,8631451,8631458,8631459,8631460,8631461,8631466,8631467,8631468,8631469,8631471,8631472,8631473,8631474,8631496,8631506,8631514,8631515,8631516,8631517,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631560,8631561,8631562,8631563,8631564,8631565,8631566,8631567,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631579,8631580,8631581,8631582,8631589,8631591,8631606,8631616,8631618,8631619,8631620,8631631,8631636,8631640,8631641,8631642,8631643,8631657,8631659,8631662,8631663,8631664,8631665,8631667,8631672,8631673,8631678,8583522,8631705,8631712,8631716,8631719,8631721,8631725,8631727,8631728,8631743,8631749,8631750,8631751,8631752,8631753,8631754,8631755,8631756,8631757,8631758,8631769,8631770,8631771,8631772,8631773,8631774,8631777,8631778,8631790,8631791,8631792,8631810,8631811,8631838,8631839,8631856,8631857,8631858,8631859,8631868,8631869,8631870,8631871,8631872,8631873,8631874,8631889,8631890,8631891,8631899,8632194,8632195,8632202,8632203,8632204,8632205,8632303,8632312,8632323,8632329,8632332,8632343,8632352,8632380,8632381,8632382,8632392,8632432,8632439,8632440,8632443,8632444,8632447,8632448,8632451,8632454,8632457,8632460,8629461,8629462,8629463,8629464,8629465,8629466,8629467,8629483,8629484,8629485,8629486,8629487,8629489,8629490,8629491,8629492,8629493,8629514,8629515,8629522,8629523,8629524,8629553,8629554,8629558,8629562,8629571,8067927,8629596,8629602,8629603,8067942,8629607,8629615,8629616,8629621,8629627,8629640,8629641,8629652,8629659,8629672,8629690,8629691,8629692,8629693,8629705,8629706,8629707,8629708,8629709,8629716,8629717,8629718,8629719,8629720,8629721,8629722,8629723,8629724,8629725,8629726,8629727,8629728,8629729,8629730,8629731,8629732,8629733,8629734,8629735,8629736,8629737,8629738,8629739,8629740,8629743,8629744,8629745,8629750,8629751,8629754,8629755,8629756,8629765,8629769,8629770,8629771,8629773,8629774,8629775,8629776,8629777,8629778,8629779,8629780,8629781,8629782,8629783,8629784,8629786,8629787,8629789,8629790,8629831,8629832,8629834,8629835,8629836,8629837,8629838,8629839,8629849,8629850,8629851,8629852,8629853,8629854,8629855,8629856,8629857,8629860,8629861,8629862,8629863,8629864,8629865,8629866,8629867,8629868,8629869,8629870,8629871,8629872,8629873,8629874,8629875,8629876,8629877,8629878,8629879,7201153,7201154,7201155,7201377,7201399,7201605,7201607,7201681,7201730,7201959,8065841,8065842,7202319,7202329,7202585,7202683,7202684,9794588,9794592,9794594,3237362,3237393,3237394,3237395,8616849,7200906,7200907,7200908,7198690,7198722,7198723,7198725,7198750,7198782,7198783,7199006,7199135,7197417,10619844,3232382,10617323,10617324,10622365,10622428,3232913,3232914,3232915,8905735,8905772,8905777,8905822,10615363,10615598,8540418,10426358,10426359,10426360,10426372,10616888,10613967,10613981,10613982,10613983,10613987,10613999,7059524,10614022,10614023,10614024,10614027,10614028,10614029,10614034,10614044,10614048,10614050,10614054,10614055,10614056,10614057,10614064,10614220,10614376,10614377,10614499,10614501,10614502,10611655,10611789,7057465,10612069,10609285,10609313,10612381,10609844,10609971,10613504,10613513,10613514,10613527,10613528,10613531,10613695,10613697,10613698,10613699,10613797,10613829,10613830,10613831,10613837,10613840,10613844,10613853,10613858,10613859,10613860,10613874,10613904,10613908,10613909,10613912,10613928,10613929,10613942,10613943,10117529,6673563,7055541,7055546,9169428,9169472,9169473,6673685,6673688,6673692,7055656,6673700,6673727,7055722,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015498,7015499,7015500,7015501,7015502,7015503,7015504,7015505,7015506,7015507,7015508,7015509,10118153,6674175,10118171,6674249,6674256,6674276,6674278,6674280,6674281,6672592,10419469,10416481,10419494,10419496,6672802,10417534,6672896,6672897,6672898,6672899,6672900,6672901,6673085,6673088,6673089,9169055,9169057,9169066,9169075,9169076,9169232,9169233,6670727,10469354,10469384,8550015,8550077,10115665,10888565,10888566,10888704,10889231,10884420,10884421,10889583,10889584,10889585,10889707,10889997,10885166,10890168,10880304,10880305,10887472,10627319,10883406,10885854,10885856,10886057,10886061,10886071,10886080,10886082,10162113,10886135,10886136,10886139,10886154,10886158,10886161,10886163,10886180,10886183,10886270,10886308,10886322,10886361,10886362,10886439,10886446,10886452,10886478,10886547,10886559,10886563,10886568,10886569,10886570,10886582,10886589,10886595,10886601,10886631,10886654,10886671,10886672,10886678,10886694,10886698,10886725,10886738,10886741,10886742,10886743,10886744,10886745,10886746,10886747,10886748,10886749,10886750,10886751,10886752,10886753,10886761,10886765,10886772,10886773,10886774,10886775,10886799,10886800,10886802,10626299,10626300,10626301,10886818,10886821,10886846,10886861,10886878,10886910,10167992,10887052,10887072,10887171,10626724,10626725,10887242,10887464,10887465,10647527,10647550,10647551,10647552,10647564,10647649,10647650,10579878,10579879,10498368,10498369,10498370,10408707) 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'