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(7067909,10276245,10276246,8911613,10276295,10276296,10276297,10276307,10276308,10276309,10276336,10276352,10276353,10276354,10276384,10276385,8595338,10103875,8559741,8559744,8559749,8559755,8559756,8559763,3899475,3899476,3899477,3899478,7068466,7068467,7068468,8618872,8618873,8618874,8618909,8618910,10198810,10198811,10198812,10198813,10198814,10198815,10198816,10198817,10198818,8619037,8619044,8619045,8619059,8619068,8619069,7068712,8560337,10277150,10277167,10277174,10277175,10844237,10277197,8836987,8836988,8836989,8837002,7074007,7074008,7074009,7074010,7074011,10251256,10251257,10251258,10251259,10251260,10251261,8837044,10251320,10277388,10277389,10277390,7074193,7074194,7074195,7074196,10277491,10277492,10277493,10277494,10277495,10277496,10277497,10199510,10199511,10277522,7074313,10277585,10277586,10277587,10277588,10277589,10277666,10251758,10251759,10251760,10251761,10437573,10212983,10212984,10212985,10212986,10212987,10212988,10212989,10212990,7200735,7200886,10275400,10275498,10275499,10275510,10275531,10275536,10275543,10275598,10275599,10275651,8617781,10275657,10275658,10275678,10275681,10275682,10275685,10275708,10275713,10275929,10275930,10275938,10275939,10275940,10275941,8559271,8559280,10843087,6000159,7071886,7071887,7071888,6000170,7071889,6000180,7198690,8908503,7198760,10840268,10840269,10840270,10840271,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625330,8625332,3926279,7064460,7064461,7064462,7072557,10234857,10101319,7072747,7072748,7072749,7072750,7072751,7072752,7072758,3926869,3236924,8565255,8565256,7073169,7073304,10261729,10932949,10932950,10932966,10274817,10274818,10274832,8910239,8910240,8910241,10102324,8617046,4968030,4968031,4968032,10235972,7073774,7073789,7073799,4938106,4938107,4938108,4938109,4938110,4938111,4938112,4938134,4938201,4938202,4938203,4938204,4938205,4938206,10942669,10942678,10942679,10942680,10942681,10942682,10942685,10942690,10839780,8908202,10839912,10839913,10100292,10100293,6000022,10837134,10837135,10837136,10837137,10837138,3922898,3922899,7069054,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072396,8072463,8072464,8072465,8072466,8072467,8072468,8613011,10245052,7157013,3924187,10258516,10258517,10258531,10258532,10258533,10258534,10258535,10258550,8554814,8555031,3234510,8073449,8073458,8907198,8073467,8073468,8073472,8073473,8073479,7070709,10618258,9217571,9217616,9217628,9217629,9217648,9217649,9217650,8633975,10619058,10619059,10619060,10619061,9218152,8611345,8611346,10619180,3232160,8577982,10204547,10204548,10204549,10204550,10204551,10204552,10204553,10204554,10204555,10204556,10204557,10204558,10204559,7155415,3232344,10922500,10922518,10922520,10922521,10922522,10922523,10847150,10228306,10847588,10460419,10460420,10460422,10460423,10228571,10228572,10228573,10228574,10228575,3230486,3230487,10189816,10189817,10189818,10189819,10189820,10189821,10189822,10189823,10189824,10189825,10189826,10189827,10189828,10189829,10189830,10189831,10189832,10189833,10189834,10189835,10189836,10189837,10189838,10189839,10189840,10189841,10189842,10189843,10189844,10189845,10189846,3230574,8632898,8632899,10190004,8620356,10615165,8620604,8620605,8838259,8570240,8570241,8630444,8570246,8630445,10200510,10845682,10845683,10845684,10845685,10845704,10845705,10845710,10930526,10930527,10930528,10200816,10620857,10620858,8838746,8838747,10279084,10253114,10253115,10253116,10253117,10253118,10253119,10253120,10253121,10253122,10279165,10279166,10279289,10846415,10846424,8583197,8583198,10240497,8575076,8621906,10279930,10279931,10922456,10922457,9173586,10614266,8568176,8568177,10714400,10714419,10714423,8864621,8864622,8864630,8864631,10122337,9174140,9174141,9174142,10614903,8864782,8861862,8542664,8542665,8542668,8542669,8542673,8851655,8851773,10120172,10120173,9212076,8566633,8852154,7058568,7058582,9196481,8852377,7026549,8852729,9173111,9205132,9205174,7055488,9177466,9177467,9177468,9177469,9177470,9177471,9161516,9161517,9161518,9161519,9161520,9161521,9161522,8849409,8849410,8849411,8849416,8849417,8849418,7055890,4974643,10517650,10517651,10517652,10517653,8849801,8849845,8849846,7023691,7056311,7023817,9912766,8552502,4973186,9160358,9160359,9160360,9192556,9192557,9168820,8848679,9208926,9208927,9208928,9208929,9208930,9208931,9208932,4974028,4974038,4974039,10122692,10122693,9190741,9198946,4971874,8916775,8916776,6667216,8855135,10469938,10469939,10469990,10469991,10469992,10469993,6667707,10123929,10123930,10123943,10123944,10123945,10123946,10123947,10123948,10123949,10116089,9191915,9208034,8917719,8917722,8917723,9208081,8917740,8917741,9192134,10468845,10468846,10468847,10468848,10468849,10468850,10468851,10888539,10903643,10893868,10893869,10893870,10908892,10909200,10909201,10909202,10909203,10909204,10629057,10629058,10629059,10629060,10629061,10629062,10629063,10629064,10629065,10629115,10629116,10629117,10629118,10629119,10629120,10629140,10629145,10629146,10629147,10629148,10629149,10629150,10629151,10629162,10629163,10155751,10155858,10885312,10907479,10907480,10892496,10892497,10627160,10158721,10158722,10158723,10158724,10158725,10158726,10158727,10158728,10158729,10158730,10158731,10158732,10168828,10168829,10168830,10168831,10907842,10907843,10168865,10173870,10164112,10888280,10893432,10893433,10885508,10171664,10171665,10630194,10630214,10176798,10176799,10171989,10171990,10171991,10171992,10905988,10171993,10905989,10171994,10905990,10905991,10905992,10905993,10896016,10896017,10896018,10896019,10896020,10896021,10896022,10896023,10896024,10896025,10896026,10896027,10896028,10896029,10172040,10162135,10187745,10876787,10876791,10876798,10877071,10877072,10877073,10877074,10877075,10877076,10877077,10877078,10877079,10877080,10877081,10877082,10907412,10907476,10907477,10907478,10652660,10652785,10646997,10599026,10599027,10599028,10599029,10599030,10599031,10599032,10599033,10599034,10599035,10599036,10599037,10599043,10599044,10599045,10584155,10584156,10584157,10584158,10584159,10584160,10653294,10653295,10653319,10644369,10644370,10644371,10644372,10644373,10644374,10644375,10644376,10644377,10644378,10587532,10587533,10587534,10587535,10587536,10587537,10587538,10587539,10644630,10647773,10650944,10566973,10654199,10654200,10654201,10654202,10654203,10654204,10648210,10648211,10604004,10604005,10604006,10604007,10604008,10604009,10604010,10604011,10604012,10567242,10651323,10651364,10645400,10645401,10645402,10645403,10645404,10645405,10567377,10567378,10567379,10567380,10567381,10567382,10567383,10651480,10651481,10588444,10588687,10645835,10645836,10645837,10645838,10645839,10648994,10648995,10529164,10529165,10529166,10529167,10529168,10529169,10529170,10529171,10529172,10529173,10529174,10529175,10529176,10529177,10529178,10529179,10529180,10529181,10529182,10529183,10529184,10529185,10529186,10529187,10529188,10529189,10529190,10529191,10529192,10529193,10529194,10529195,10529196,10529197,10529198,10529199,10529200,10529201,10529202,10519202,10529203,10519203,10529204,10519204,10529205,10519205,10529206,10519206,10529207,10519207,10529208,10519208,10529209,10519209,10529210,10519210,10529211,10519211,10529212,10519212,10529213,10519213,10529214,10519214,10519215,10529215,10519216,10529216,10519217,10529217,10519218,10529218,10519219,10529219,10519220,10529220,10519221,10529221,10519222,10529222,10519223,10529223,10519224,10529224,10529225,10519225,10519226,10529226,10529227,10519227,10529228,10529229,10529230,10529231,10529232,10529233,10529234,10529235,10529236,10529237,10529238,10529239,10529240,10529241,10529242,10529243,10529244,10529245,10529246,10529247,10529248,10529249,10529250,10529251,10541450,10541451,10541452,10541453,10541454,10541455,10541456,10541457,10529488,10529489,10529499,10545500,10545501,10529519,10529520,10529521,10529522,10529523,10529524,10529525,10529526,10545698,10545708,10545740,10545846,10545847,10545848,10545858,10545859,10544329,10544330,10544331,10544445,10522729,10526865,10526866,10526867,10526868,10526869,10526870,10526871,10526872,10526873,10526874,10526875,10526876,10526877,10526878,10526879,10526880,10528913,10528914,10520917,10527008,10551053,10551054,10551055,10551056,10551057,10551058,10551059,10551060,10423492,10423499,10423500,10498419,10505466,10505467,10505468,10505469,10498545,10498546,10498547,10423705,10423708,10509827,10478946,10478947,10478948,10479156,10479157,10479158,10479299,10479300,10479301,10411721,10413903,10413904,10413905,10413906,10407943,10407945,10414152,10414153,10414154,10414155,10414156,10414157,10414158,10414170,10414171,10414172,10496843,10414238,10414239,10414240,10414260,10481953,10481954,10412587,10412588,10412590,10412591,10476302) 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'