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(10962506,7067830,8068867,7075887,7075888,7075904,7075905,7075931,7075986,10939718,10939719,10939720,10939721,10939726,10939727,10939728,10939729,10939732,7076045,7076046,7076047,7068053,7068074,10939810,10939811,10943622,7068119,7068120,10939860,10939861,10939879,4970500,4970501,10939880,4970502,10939881,7068176,10939904,10943701,4970552,4970560,7076336,7076337,7076338,7076339,7076340,4970677,7076352,4970700,4970738,7076407,7076408,4970756,8569505,10940246,8569507,10963309,10944166,10940374,8569647,10944225,4971091,7073821,7073823,7073844,7073851,4968188,7073853,7073855,7073861,7073863,7073864,7073865,7073868,7073877,7073878,7073880,7065881,7073882,7073884,7073885,7073888,7065891,7065892,7073892,7073893,7073896,7073915,7073922,7073943,7073944,7073950,7073955,7073957,7073969,7065989,4968489,4968490,4968492,4968494,7066160,7066179,7074222,7066284,7066285,7066286,7074313,7066329,7066330,8067425,8067437,8067439,8067446,8067462,7074493,7066525,4968861,7066526,4968863,7066527,4968866,7066534,4968888,10437547,10964414,10964455,10964456,4969199,10961580,10961586,10961590,7066978,7067003,10938814,10938815,4969493,7067207,10938951,7067257,7067258,7067259,7067260,7075261,7067261,7075262,7067262,7075263,7067263,7075264,7067264,7075265,7067265,7067266,7075266,7075267,7075268,7075279,10939028,10939081,10939082,10939118,10939122,10939146,10939149,7075497,10962197,7067531,7067533,10939253,7067614,7067615,7067616,7067617,7067646,10939374,10939444,10939445,7067742,7075753,7075754,7075755,10939470,7075756,7075757,8064891,10959561,6000169,6000258,6000259,10931551,7072163,7072166,7064235,10959921,10959922,10959946,10959950,10959952,10959985,10931740,10960005,7064355,7064385,10960078,10960079,7064398,10960105,7064507,7064516,7064521,7064531,8065618,7064555,7064556,10960307,10960308,10960341,8065728,10960348,10960351,10960357,8065765,8065803,10960476,10960477,10960478,10960479,10960480,10960481,10960482,10960483,10960484,8066048,10960773,10960777,10960782,7065154,7065156,7065174,7065218,7065287,7065288,7065293,7065294,10960988,7073304,10960989,10960990,10960991,10960992,10960993,10960994,10960995,10960996,10960997,10960998,10960999,10961000,7073317,10961001,7073318,10961022,7065396,7065397,4967746,7073425,7073441,7065445,7073449,7073451,7065561,4967941,7073615,7073616,4967994,7073675,7073676,10961364,7073681,7065691,7073693,7073695,7073703,7073707,7073710,7073713,7073714,7073716,7073732,7073734,7073738,7073740,7073748,7073749,7073751,10933193,7073757,7073761,7073762,7073764,7073770,7073774,7073789,7073799,7073810,7073812,7073813,7073814,10942585,10958571,10942628,10942629,10942641,10942642,10942644,10942650,8860839,10942660,10942661,10942679,10942680,10942681,10942685,7071124,7071133,7071216,8064324,8064374,8064394,8861264,8861383,10943196,8861390,8861392,10943226,10943227,7071579,7071585,8861540,8861541,8861542,10943376,10943380,10943381,10943382,10943383,10943391,10943399,10943400,10943401,10943411,8970238,10931211,8064841,10959465,8064857,10940685,10940689,3655811,3655812,7069195,7069196,10940970,3655963,3655964,3655968,3655989,10941019,3656002,3656003,3656005,3656007,3656008,3656009,3656010,3656011,3656012,3656013,3656014,3656015,3656017,3656021,10944842,10944848,10944850,10944851,3656033,3656037,3656040,3656041,3656043,3656044,3656050,10941111,10941116,3656096,3656100,3656101,3656112,3656117,3656118,3656119,3656126,3656127,3656128,3656130,3656131,3656133,3656134,3656137,3656139,3656140,3656144,3656157,3656159,3656164,3656173,3656174,3656176,7069679,10957390,10957391,10957392,10957393,10941440,10941441,10941442,7069728,10941444,7069730,7069731,10957423,7069757,7069758,10941479,10941480,10941481,10941482,8072644,10957476,8072649,8072654,8072659,8072664,8072669,8072674,8072679,8072684,8072689,8072694,8072699,8072704,8072709,8072714,8072719,8072724,8072729,8072734,8072739,8072744,8072749,8072754,8072759,8072764,8072769,8072774,10941635,8072779,8072784,10941649,8072789,3656644,3656657,3656684,8072954,7070102,7070103,8072962,7070117,7070118,7070119,7070120,7070129,7070130,7070131,3656844,7070204,7070205,7070211,3656905,3656906,3656907,7070270,7070271,10942031,10942032,10942056,10958028,10958053,10958055,10958059,10958061,10958062,10958063,10958067,10958069,10958073,10958076,10958077,10958078,10958079,8860320,7070478,7070511,7070517,7070587,10942412,10942509,10958481,10928508,10928509,10928510,10928511,10954627,10954628,10928602,10928604,10928605,10928606,10928607,10928608,10928609,10928615,10928620,10928621,10928622,10928631,10928632,10928633,10928646,10928649,10928652,10928653,10928654,10928655,10928656,10928657,10928658,10928659,10928660,10928661,10954699,10954700,10954702,10954703,10623198,10618229,10618294,10618297,10618298,10618300,10618301,10618316,10618327,10955010,10623524,10623587,10623679,10623822,10623828,10623829,10623830,10618855,10618856,10623888,10623902,10623905,10623912,10624051,10624083,10619183,10624230,10619460,10619461,10624515,10619586,10619588,10619892,10619894,10619903,10953571,10953574,10953575,10953579,10953580,10953582,10953583,10922596,10922597,10922598,10922599,10622132,10953880,10927958,10927959,10617470,10927980,10954024,10617532,10617533,10617534,10617535,10617536,10617537,10617538,10617539,10617540,10617541,10928083,10928095,10928096,10928102,10617679,10617681,10617687,10617698,10617699,10617700,10617702,10617703,10622706,10622708,10928228,10954265,10622741,10954295,10617806,10617807,10617808,10617809,10617810,10928320,10617811,10617813,10617814,10617816,10617817,10617818,10617819,10617820,10617821,10617850,10954433,10954434,10622921,10614967,10925528,10925529,10925538,10615061,10615065,8569949,10620122,8569978,10925699,10615205,10615231,8570165,8570166,8570212,8570213,8570215,8570219,8570223,8570226,10920907,10620424,8570260,8570263,10615435,8570266,8570269,10615494,8570331,8570340,10921030,10926094,10926129,10926141,10926142,10926143,10926144,10926145,10926173,10926178,8570501,8570502,10921185,10921189,10930525,10926253,10930633,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921426,10921452,10921453,10921454,10921456,10921457,10921458,10615956,10921482,10930799,10930811,10930812,10926702,10616198,10616199,10916829,10916830,10916838,10916844,10916845,10916848,10916851,10916862,10916863,10916864,10916865,10916871,10916872,10916873,10616364,10616365,10916878,10916883,10916884,10916885,10916889,10916890,10916900,10916904,10916905,10916908,10916909,10916910,10916911,10916912,10916913,10916915,10921964,10921994,10921995,10922079,10616579,10616688,10616797,10616821,10616832,10917388,10917389,10917390,10565129,10610994,10614013,10565171,10614125,10614200,10611279,10614283,10614340,10611344,10614357,10611377,10611378,10611408,10614443,10559603,10614503,10611662,10611700,10611804,10614849,10566061,10566062,10566098,10611965,10612009,10609107,10609162,10609187,10612219,10612251,10609270,10609306,10563457,10609307,10609323,10609324,10609325,10609326,10612346,10609358,10609359,10612381,10609385,10563541,10612404,10609502,10609503,10609504,10609614,10609710,10609749,10610001,10610002,10610003,10610004,10610005,10613036,10613073,10610075,10613114,10613115,10610431,10610450,10610456,10610622,10613649,10613764,10613765,10613779,10610843,10613920,10610930,10515139,10515140,10515141,10515142,10515143,10517272,10513386,10517402,10517658,10514028,10514029,10514030,10514031,10514032,10514033,10514034,10516069,10512145,10512146,10512586,10512587,10512605,10514644,10518771,10518772,10518773,10518774,10518775,10518777,10518778,10518780,10518781,10518782,10514827,10514890,10516931,10513051,10513052,10513053,10417265,10416289,10416290,10416291,10416302,10416406,10416453,10417475,10417476,10418507,10418556,10417765,10417766,10417767,10417768,10417769,10417770,10417771,10417772,10416861,10419882,10419883,10418905,10416940,10419951,10420024,10419039,10419089,10419139,10419140,10420147,10468911,10466997,10466998,10471006,10463025,10463026,10467031,10463035,10467038,10467039,10467040,10467041,10467042,10467075,10467118,10467124,10467131,10467133,10467136,10467137,10467139,10467143,10467146,10465148,10467156,10467158,10471249,10471250,10469292,10467353,10471373,10471386,10471387,10463394,10463395,10471401,10469431,10463431,10463434,10467440,10467458,10471460,10463556,10465569,10465627,10465628,10465631,10465633,10465653,10465656,10465728,10463739,10465769,10469913,10469917,10469937,10469948,10464066,10466127,10466309,10468348,10466378,10462386,10464429,10462439,10464528,10464529,10464587,10464699,10462723,10462725,10468767) 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'