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(7067938,10939617,7076041,10939677,10939694,10939700,10939733,10939734,10939736,10939772,10939796,10939822,7068213,10939848,7076239,10939906,10939907,10939908,10939909,7076287,7076292,7076294,7076296,7076297,4970520,4970521,7076353,7068403,10943842,4970685,4970731,4970732,4970734,4970738,8569563,8569564,8569565,10940293,8569647,4971081,4968339,10963826,10963832,10963837,10963842,10963847,10963865,7066265,4968622,4968624,4968625,8067523,10437560,8067757,10964582,7067102,7067134,10938792,10961933,7067267,7067425,7067444,7067445,7067765,7067766,7075771,7075773,7075779,7075783,10939467,10962575,7067893,7067894,7067896,7067900,7067902,7071983,7072074,7072151,7072152,7064168,10931548,7072259,10960066,10960067,7072467,8075288,10931961,10931962,10960308,10960336,10960354,8065730,8065731,8065732,10960475,8065791,8065807,7073317,10961020,7065352,7073403,10932790,10932796,10932805,10932827,7065557,10932959,10932960,10932966,10932967,10932968,7065750,4967985,7065873,10958628,10942598,10942666,10942671,10942692,10942693,7071093,10942734,10942735,10942737,10942745,10942793,7071274,10958963,10958979,10958980,10958987,10958988,10958989,7071309,10942992,10943018,10943026,10959092,10943045,10943048,10943248,10943256,6000112,6000113,10959561,10959565,10959568,7071911,10940578,10940580,3655603,3655604,10944518,10940783,10940969,10941161,10941163,7069602,10941226,10941477,7069926,10957648,10941589,10941688,10941691,10941700,10941701,10941703,10941717,10941718,10941726,10941754,10941756,10941758,10941759,10941760,10941764,10941768,10941778,10941779,10941781,10941839,10941849,10941929,10942106,10942123,7070567,10942205,10942210,10942213,10942218,10942219,10942228,10942229,10958353,10958381,10942325,10942343,10942346,10942367,7070757,7070761,10942390,10942395,10942435,11048721,10942448,10942455,10942477,10942489,10954694,10623092,10623093,10928652,10618182,10618183,10928700,10928701,10618196,10928735,10928736,10618294,10618295,10618296,10618297,10618298,10618299,10618300,10618301,10618302,10618303,10618304,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10618316,10618317,10618320,8070196,8070198,10623508,10623736,8070947,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10619351,10624414,10619833,10619834,10619887,10619892,10619893,10619894,10619896,10619899,10619901,10619902,10619906,10621982,10927576,10927577,10927578,10617123,10622154,10622269,10617409,10622428,10622430,10617434,10617435,10622441,10622508,10622523,10622533,10954313,10617793,10928326,10622828,10928353,10614984,8569935,10614986,10614987,8570016,10615075,10620084,10620085,10620086,10620087,10620088,10620089,10620090,10620091,10620092,10620093,10620094,8570093,8570099,8570114,8570120,10615179,10620183,8570134,10615229,10615248,10620310,10620311,10620312,10620313,10615329,10615330,10615471,10925981,10926087,10620711,10620712,10926285,10620796,10930733,10930734,10930777,10930851,10615933,10615950,10621038,10621041,10616058,10616059,10616076,10616077,10922251,10922252,10922253,10922254,10922255,10927261,10927262,10616790,10953508,10953511,10953512,10953513,10616911,10610967,10610984,10610985,10565155,10565158,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,8863914,10565266,10565267,10565268,10565269,10565270,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565278,10565279,10565280,10565281,10565282,10565283,10565284,10565285,10565286,10565287,10565288,10565289,10565296,10565299,10565300,10614186,10611197,10559384,10559385,10559386,10559392,10611365,10611376,10611377,10611378,10611380,10611383,10611392,10611398,10611404,10611408,10611416,10611428,10611432,10611440,10611441,10611443,10611451,10611452,10611459,10611461,10611464,10611467,10614475,10611482,10611483,10611485,10611492,10611493,10611496,10611498,10611500,10611505,10614518,10614519,10611520,10611522,10611526,10611527,10611530,10611538,10611539,10614547,10611549,10614552,10611552,10614553,10614554,10611555,10611564,10614565,10611569,10611573,10611577,10611579,10611580,10611582,10611586,10611587,10611589,10611590,10611612,10611613,10611640,10611643,10611649,10611659,10611660,10611665,10611666,10614725,10611833,10611834,10614857,10566061,10566062,10611916,10611934,10612013,10612050,10609155,10612201,10612268,10609285,10609287,10609307,10609309,10609313,10609379,10610005,10613017,10610056,10613057,10613058,10613066,10610075,10610095,10610096,10613096,10610097,10613114,10613115,10558300,10613191,10613192,10613342,10610347,10610352,10610353,10613406,10561563,10610429,10610449,10610473,10610474,10613501,10564666,10564669,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10610666,10613721,10610739,10610775,10610881,10565037,10565038,10565039,10565040,10515341,10515342,10515422,10513552,10513564,10513565,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10517809,10513915,10514028,10514029,10514030,10514031,10514032,10514033,10516069,10512171,10512172,10516931,10513077,10513078,10415251,10419306,10419349,10419350,10416405,10416431,10416432,10416435,10416443,10417445,10415575,10415576,10419673,10419674,10418676,10419676,10419679,10415679,10419680,10419683,10419684,10419685,10419686,10418689,10418691,10418692,10419693,10418701,10418702,10418703,10418704,10418707,10418710,10419712,10415729,10419734,10419737,10415737,10419743,10419744,10419745,10419746,10419747,10415794,10415795,10415796,10415797,10418820,10419828,10419829,10419830,10417830,10419831,10415836,10415837,10418841,10419841,10419842,10418842,10419843,10419844,10419845,10418845,10419846,10418846,10419847,10419848,10419849,10417849,10419850,10418855,10418856,10417866,10417883,10417901,10417919,10419996,10419998,10420001,10420002,10420003,10420005,10420007,10420010,10420012,10420013,10420017,10420018,10420043,10420060,10420087,10419110,10419113,10420118,10420147,10420152,10420169,10420170,10419188,10419189,10419191,10466955,10467005,10463005,10463011,10463013,10463025,10463026,10463035,10463042,10463043,10463046,10467099,10467105,10467106,10467107,10467108,10467109,10467110,10467111,10467112,10467113,10467114,10467115,10467116,10467117,10467118,10467119,10467120,10467121,10467122,10467123,10467124,10467125,10467126,10467127,10467128,10467129,10467130,10467131,10467132,10467133,10467134,10467135,10467136,10467137,10467138,10467139,10467140,10467141,10467142,10467143,10467144,10467145,10467146,10467147,10467148,10467149,10467150,10467151,10467152,10467153,10467154,10467155,10467156,10467157,10467158,10467159,10467160,10469379,10469380,10469381,10463392,10463393,10463394,10463395,10463396,10463397,10463398,10463399,10463400,10463401,10463402,10463403,10467408,10467409,10467428,10467429,10463429,10467430,10463430,10467431,10463431,10467432,10463432,10467433,10463433,10467434,10463434,10467435,10463435,10467436,10463436,10467437,10463437,10467438,10463438,10467439,10463439,10467440,10467441,10467442,10467443,10467444,10467449,10467456,10467457,10467458,10467459,10467460,10467461,10467472,10467473,10467474,10467475,10469618,10463657,10463658,10463660,10463675,10465688,10465695,10463736,10463739,10463740,10463744,10463753,10463764,10463767,10465769,10463770,10463773,10463776,10463777,10463778,10463779,10463784,10465785,10463788,10463790,10465791,10463792,10463793,10465797,10463798,10463799,10465802,10465803,10465804,10463805,10465805,10463806,10465808,10465809,10465810,10465811,10465812,10465813,10465825,10465826,10465827,10463830,10463833,10465850,10465851,10465853,10465858,10465859,10465860,10467865,10467866,10465869,10467876,10463876,10465881,10463898,10463899,10465900,10465902,10465907,10463907,10465915,10463927,10463930,10463931,8563359,8563360,10470089,10470090,10466208,10466212,10466213,10466215,10466222,10466230,10466231,10468234,10466243,10466309,10466312,10462316,10462317,10466326,10466332,10466333,10466343,10466344,10466346,10466348,10466351,10466352,10466353,10466361,10466362,10466373,10466378,10466390,10466397,10466398,10466405,10462408,10462412,10462413,10462414,10462425,10466430,10462430,10466431,10462431,10466434,10466435,10466437,10466438,10462439,10466441,10466443,10466447,10462452,10466458,10462460,10462461,10462482,10462483,10462498,10462499,10462500,10466501,10466502,10466503,10466504,10462515,10462517,10462523,10462524,10462525,10462526,10462530,10462531,10462537,10462539,10462546,10462586,10462616,10462620,10462625,10462628,10462629,10462723,10462725,10462728,10466847,10466849,10466852) 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'