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(7076018,11014768,7076128,10989002,10989003,10989004,11015081,8569729,11016291,11016400,11016418,11013620,11013621,11013622,11013623,11013624,11013625,11013626,11013627,11013628,11013629,11013630,11013631,11013632,11013633,11013634,11013635,11013636,11013761,7075254,7075255,7067398,7075741,10962450,10939425,8065083,11011882,7064399,10999132,7064463,7064464,10931820,10931834,10986229,10986772,11000200,10932963,10932979,10932980,10932981,10932982,10932985,10932986,10932987,4968033,4968034,11013571,11013572,11013573,11013615,11013616,11013617,11013618,11013619,7070941,11048967,11049136,10972058,10972437,10972438,10972439,10985443,10985444,10985445,10985459,10985460,10985461,10985462,10985463,10985464,10985465,10985466,10985467,10985468,10985469,6000122,11008672,11008673,10969733,10969734,10969735,7069326,3656054,3656060,3656090,3656091,3656116,10996264,11009362,10957394,10957395,10957396,10957397,3656638,11009964,11009965,11009966,11009971,11010060,7070527,7070531,7070533,7070535,10958290,7070857,10942537,10954715,10623058,10623061,10618267,10618268,10618269,10623522,10623523,10623807,10623808,10623809,10623810,10623811,10994934,10922501,11005718,11005719,11005720,11005721,11005722,11005723,11005724,11005725,11005726,10953952,10953953,10953954,10953955,10953956,10953957,11006415,11006482,11006483,11006484,11006485,8570036,10920637,10920638,10920639,10620208,10620323,10620324,10620328,10620329,8570401,11004119,11004255,10930529,11004256,11004257,11004258,11004259,11004260,11004261,11004262,11004263,11004264,11004265,11004266,11004267,11004268,11004269,11004270,11004271,11004272,11004273,11004274,11004275,11004276,11004277,11004278,11004279,11004280,11004281,11004282,11004283,11004284,11004285,11004286,11004287,11004288,11004289,11004290,11004291,11004292,11004293,11004294,11004295,11004296,11004297,11004298,11004299,11004300,11004301,11004302,11004303,11004304,11004305,11004306,11004307,11004308,11004309,11004310,11004311,11004312,10620654,11004313,11004314,11004315,11004316,11004317,11004318,11004319,11004320,11004321,11004322,11004323,11004324,11004325,11004326,11004327,11004328,11004329,11004330,11004331,11004332,11004333,11004334,11004335,11004336,11004337,11004338,11004339,11004340,11004341,11004342,11004343,11004344,11004345,11004346,11004347,11004348,11004349,11004350,11004351,11004352,11004353,11004354,11004355,11004356,11004357,11004358,11004359,11004360,11004361,11004362,11004363,11004364,11004365,11004366,11004367,11004368,11004369,11004370,11004371,11004372,11004373,11004374,11004375,11004376,11004377,11004378,11004379,11004380,11004381,11004382,11004383,11004384,11004385,11004386,11004387,11004388,11004389,11004390,11004391,11004392,11004393,11004394,11004395,11004396,11004397,11004398,11004399,11004400,11004401,11004402,11004403,11004404,11004405,11004406,11004407,11004408,11004409,11004410,11004411,11004412,11004413,11004414,11004415,11004416,11004417,11004418,11004419,11004420,11004421,11004422,11004423,11004424,11004425,11004426,11004427,11004428,11004429,11004430,11004431,11004432,11004433,11004434,11004435,11004436,11004437,11004438,11004439,11004440,11004441,11004442,11004443,11004444,11004445,11004446,11004447,11004448,11004449,11004450,11004451,11004452,11004453,11004454,11004455,11004456,11004457,11004458,11004459,11004460,11004461,11004462,11004463,11004464,11004465,10615897,10615898,10991661,10991662,10616086,10991779,10991780,10991781,10926721,11005134,11005135,11005136,11005137,11005138,11005139,11005140,11005141,11005142,11005143,11005144,11005145,11005146,11005147,11005148,11005149,11005150,11005151,11005152,11005153,11005154,11005155,11005156,11005157,11005158,11005159,11005160,11005161,11005162,11005163,11005164,11005165,11005166,11005167,11005168,11005169,11005170,11005171,11005172,11005173,11005174,11005175,11005176,11005177,11005178,11005179,11005180,11005181,11005182,11005183,11005184,11005185,11005186,11005187,11005188,11005189,11005190,11005191,11005192,11005193,11005194,11005195,11005196,11005197,11005198,11005199,11005200,11005201,11005202,11005203,11005204,11005205,11005206,11005207,11005208,11005209,11005210,11005211,11005212,11005213,11005214,11005215,11005216,11005217,11005218,11005219,11005220,11005221,11005222,11005223,11005224,11005225,11005226,11005227,11005228,11005229,11005230,11005231,11005232,11005233,11005234,11005235,11005236,11005237,11005238,11005239,11005240,11005241,11005242,11005243,11005244,11005245,11005246,11005247,11005248,11005249,11005250,11005251,11005252,11005253,11005254,11005255,11005256,11005257,11005258,11005259,11005260,11005261,11005262,11005263,11005264,11005265,11005266,11005267,11005268,11005269,11005270,11005271,11005272,11005273,11005274,11005275,11005276,11005277,11005278,11005279,11005280,11005281,11005282,11005283,11005284,11005285,11005286,11005287,11005288,11005289,11005290,11005291,11005292,11005293,11005294,11005295,11005296,11005297,11005298,11005299,11005300,11005301,11005302,11005303,11005304,11005305,11005306,11005307,11005308,11005309,11005310,11005311,11005312,11005313,11005314,11005315,11005316,11005317,11005318,11005319,11005320,11005321,11005322,11005323,11005324,11005325,11005326,11005327,11005328,11005329,11005330,11005331,11005332,11005333,11005334,11005335,11005336,11005337,11005338,11005339,11005340,11005341,11005342,11005343,11005344,11005345,11005346,11005347,11005348,11005349,11005350,11005351,11005352,11005353,11005354,11005355,11005356,11005357,11005358,11005359,11005360,11005361,11005362,11005363,11005364,11005365,11005366,11005367,11005368,11005369,11005370,11005371,11005372,11005373,11005374,11005375,11005376,11005377,11005378,11005379,11005380,11005381,11005382,11005383,11005384,11005385,11005386,11005387,11005388,11005389,11005390,11005391,11005392,11005393,11005394,11005395,11005396,11005397,11005398,11005399,11005400,11005401,11005402,11005403,11005404,11005405,11005406,11005407,11005408,11005409,11005410,11005411,11005412,11005413,11005414,11005415,11005416,11005417,11005418,11005419,11005420,11005421,11005422,11005423,11005424,11005425,11005426,11005427,11005428,11005429,11005430,11005431,11005432,11005433,11005434,11005435,11005436,11005437,11005438,11005439,11005440,11005441,11005442,11005443,11005444,11005445,11005446,11005447,11005448,11005449,11005450,11005451,11005452,11005453,11005454,11005455,11005456,11005457,11005458,11005459,11005460,11005461,11005462,11005463,11005464,11005465,11005466,11005467,11005468,11005469,11005470,11005471,11005472,11005473,11005474,11005475,11005476,11005477,11005478,11005479,11005480,11005481,11005482,11005483,11005484,11005485,11005486,11005487,11005488,11005489,11005490,11005491,11005492,11005493,11005494,11005495,10953514,10565331,10565332,10565333,10614190,8864179,10614343,10614749,6666233,10612337,9171699,10563696,10563697,10563714,10563715,10563716,10563717,10563718,10563719,10609623,10609625,10609626,10609630,10563789,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563805,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563847,10563848,10563849,10609708,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563947,10563948,10563949,10563950,10563951,10563952,10563953,10563954,10563970,10563971,10563972,10563973,10563974,10563988,10563989,10564124,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564143,10564144,10564145,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10613127,9172541,10564414,9164780,9164781,9164782,9164783,10610686,9161524,9161526,4974626,4974751,9162452,9162453,9162534,9162536,9162537,10514385,10514541,10514742,7057427,10417310,10417311,10415420,10415509,9168715,10416801,10416802,10416822,10416823,9161112,9177158,9177159,9177160,9177187,9177188,9177189,9177212,9177213,9177214,10464911,10464912,10464913,10465128,6667166,9175541,9167872,8917576,6667989,9168152,10468773,10468774,10468775,9168247,9160269,9160270,10159528,10628093,10628094,10628095,10628096,10628097,10628098,10628099,10628100,10628101,10628102,10628103,10628373,10165349,10165350,10629141,10155860,10155864,10165915,10171126,10171127,10168833,10168834,10168868,10168936,10168937,10168938,10168996,10168997,10168998,10169138,10169139,10169140,10169141,10169142,10169143,10169144,10169145,10169146,10169147,10169148,10169149,10169150,10169151,10169152,10169153,10169154,10169155,10169156,10169157,10169158,10169159,10627740,10169368,10169369,10169370,10169371,10169372,10169373,10169452,10169453,10169454,10169455,10169456,10169457,10169458,10630101,10625816,10625818,10625819,10625820,10625822,10625825,10625826,10625827,10162787,10162788,10162851,10567711,10568007,10568008,10568020,10423537,10423753,10420849,10421875,10421974,10423217,10478540,10478541,10478542) 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'