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(8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630687,8630688,8630689,8630690,8630691,10962734,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630742,8630743,8630744,8630745,8630746,8630747,8630748,8630749,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630775,8630786,8630787,8630789,8630854,8630855,8630856,8630902,8630903,8630906,8630907,8630908,8630912,8631027,8631028,8631030,8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8631062,8631063,8631064,8631065,8631066,8631067,8631068,8631071,8631080,8631082,8631085,8631089,8631097,8631119,8631120,8631121,8631129,8631130,8631131,8631147,8631161,8631185,8631186,8631187,8631188,8631190,8631191,8631192,8631194,8631195,8631227,8631228,8631229,8631298,8631299,8631300,8631301,8631302,8631303,8631304,8631305,8631306,8631307,8631308,8631309,8631310,8631311,8631312,8631313,8631314,8631315,8631316,8631317,8631318,8631319,8631320,8631321,8631322,8631323,8631324,8631325,8631326,8631327,8631328,8631329,8631330,8631331,8631332,8631333,8631334,8631335,8631336,8631337,8631338,8631339,8631340,8631341,8631342,8631343,8631344,8631345,8631471,8631472,8631473,8631474,8631476,8631477,8631478,8631479,8631480,8631481,8631482,8631496,8631506,8631510,8631511,8631512,8631513,3229285,8631521,8631522,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631560,8631561,8631562,8631563,8631564,8631581,7065941,8631590,8631592,8631611,8631612,8631613,8631614,8631615,8631617,8631622,8631623,8631624,8631625,8631627,8631631,8631634,8631635,8631658,8631659,8631661,8631662,8631663,8631664,8631665,8631667,8631668,8631670,8631672,8631673,8631674,8631676,8631680,8631685,8631686,10950676,8631705,8631712,8631732,8631743,8631790,8631791,8631792,8631807,8631808,8631812,8631821,8631822,8631823,8631824,8631825,8631826,8631827,8631828,8631842,8631843,8631844,8631858,8631863,8631866,8631868,8631869,8631870,8631871,8631872,8631873,8631889,8631890,8631891,8631900,8632190,8632191,8632192,8632193,8632194,8632195,8632196,8632197,8632198,8632199,8632202,8632203,8632204,8632205,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,11042276,8632237,11042277,8632238,8632240,8632241,8632242,8632243,8632244,8632245,8632246,8632247,8632248,8632249,8632250,8632251,8632252,8632253,8632254,8632255,8632256,8632257,8632258,8632259,8632260,8632261,8632262,8632263,8632264,8632265,8632266,8632267,8632268,8632269,8632270,8632271,8632272,8632273,8632274,8632275,8632276,8632277,8632278,8632279,8632280,8632281,8632282,8632283,8632284,8632285,8632286,8632287,8632288,8632289,8632290,8632291,8632292,8632293,8632294,8632295,8632296,8632297,8632298,8632299,8632300,8632301,8632302,8632303,8632304,8632305,8632306,8632307,8632308,8632309,8632310,8632311,8632312,8632313,8632314,8632315,8632316,8632317,8632318,8632319,8632320,8632321,8632322,8632323,8632324,8632325,8632326,8632327,8632328,8632329,8632330,8632331,8632332,8632333,8632334,8632335,8632336,8632337,8632338,8632339,8632340,8632341,8632342,8632343,8632344,8632345,8632346,8632347,8632348,8632349,8632350,8632351,8632352,8632361,8632362,8632363,8632364,8632365,8632366,8632367,8632368,8632369,8632370,8632371,8632372,8632373,8632374,8632375,8632376,8632377,8632378,8632379,8632380,8632381,8632382,8632383,8632384,8632390,8632392,8632393,8632394,8632395,8632396,8632397,8632398,8632399,8632410,8632420,8632424,8632425,8632426,8632427,8632428,8632429,8632430,8632431,8632432,8632433,8632434,8632435,8632436,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,8632457,3230230,8632458,8632459,8632460,8632461,8632462,8632463,8632464,8632465,8632466,8632467,8632468,8632469,8632470,8632471,8632472,8632473,8632474,8632475,8632476,8632477,8632478,8632479,8632480,8632481,8632482,8632483,8632484,8632485,8632486,8632487,8632488,8632489,8632490,8632491,8632492,8632493,8632494,8632495,8632496,8632497,8632498,8632499,8632500,8632501,8632502,8632503,8632507,8632508,8632509,8632510,8632511,8632512,8632513,8632514,8632515,8632516,8632517,8632518,8632519,8632520,8632521,8632522,8632523,8632524,8632525,8632526,8632527,8632528,8632530,8632537,8632538,8632540,8632544,8632545,8632546,8632547,8632548,8632549,8632550,8632551,8632552,8632553,8632554,8632557,8632558,8632559,8632560,8632561,8632562,8632563,8632564,8632565,8632566,8632567,8632568,8632569,8632570,8632571,8632572,8632573,8632574,8632575,8629585,8629587,8629588,8629589,8629596,8629601,8629602,8629603,8629609,8629610,8629611,8629615,8629616,8629617,8629618,8629619,8629620,8629621,8629622,8629623,8629626,8629628,8629631,8629632,8629633,8629634,8629635,8629647,8067943,10962565,7201259,7201262,7201263,7201335,7201629,7201831,10960475,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,7202211,7202212,7202213,7202214,7202257,7202285,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202643,9794588,7202769,9794594,7200578,7200763,7200779,7200914,7201006,7201007,7201008,7198694,7198722,7198723,7198784,7199006,7199396,7199397,7199508,7199570,10101534,10618183,10618265,10618266,10618268,10618269,10618271,10618272,10618273,10618274,10618275,10618276,10618277,10618278,10618279,10618280,10618281,10618282,10618284,10618286,10618288,10618289,10618290,10618291,10618292,10618294,10618295,10618296,10618297,10618298,10618300,10618301,10618303,10618304,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618318,10618319,10618320,10618321,10618322,10618323,10618324,10618326,10838920,7197437,7197473,3234662,7197574,7197575,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,7197806,7197807,7197940,10619854,10619864,10619865,10619866,10619874,3232382,8905149,8905163,10617332,3232798,3232914,10617573,8905663,8905711,8612652,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10615363,10615439,10615711,10615820,8540599,10616553,8611391,10427112,10616955,10611037,10614064,10614085,10614086,6669907,10614376,10614552,10614553,10614554,10611856,10612916,10610005,10610046,10610054,10610095,10610096,10610097,9172535,9172537,9172538,10610233,10613306,10610337,10613369,10613393,10613421,10610429,10613431,10613432,10610474,10610479,10610480,10610481,10613525,10610568,6673527,6673528,6673529,6673530,6673531,6673532,10117529,6673563,9169428,10515316,7055824,7055836,9169822,9169864,6674285,10516136,10516137,10516138,10516139,9168403,6672657,6672658,6672724,6672725,6672726,6672730,6672733,6672903,6672904,10418708,10418709,10418710,6673143,6673144,6673146,6673147,10418048,8549463,8549957,10467883,9167988,10883530,10888566,10893758,10893759,10893760,10893979,10893980,10893981,10893982,10893983,10893984,10893985,10893986,10893987,10893988,10893989,10893990,10884420,10884421,10884652,10890165,10632106,10632107,10632109,10632110,10883067,10883136,10883138,10883140,10883141,10883142,10883143,10883393,10883401,10883402,10883458,10883459,10885751,10161842,10886061,10162279,10891301,10891302,10891303,10626145,10886878,10626724,10626725,10643489,10643490,10643504,10647394,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10420647,10420858,10420859,10420860,10420861,10420862,10420863,10420864,10420865,10420866,10420867,10420868,10420869,10420870,10420871,10420872,10420873,10420874,10420875,10420876,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420884,10420885,10420886) 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'