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(10944056,10944057,10944058,10437233,8067983,8067984,8067985,8067986,8067987,8067988,8067989,8067990,4969562,8068349,8068350,8068351,8068352,8068353,8068354,8068355,8068356,8068357,8068358,8068359,8068360,8068420,8068421,8068422,8068423,8068424,8068425,8068426,8068427,8068428,8068453,8068454,10931736,10932306,10932518,10932519,10932520,10932521,10932522,10932523,10932524,10932525,10932526,10932527,10932773,4968074,4968075,4968076,4968077,4968078,10942547,10942548,10942549,10942550,10942551,10942730,10942731,10942732,10942733,10942734,10942735,10942736,10942737,10942738,10942739,10942740,10942741,10942742,10942743,10942744,10942745,10943062,10943063,10943064,10943065,10943066,10943067,10943068,10943069,10943070,10943071,10943072,10943073,10943074,10943314,10940533,10942027,10942286,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8073512,8073513,8073514,8073515,8073516,10623199,10623339,10623433,10623501,10925141,10925142,10925143,10925144,10925145,10925146,10925147,10925148,10925149,10925150,10925151,10925152,10925153,10925154,10925155,10925156,10925157,10925158,10925159,10925160,10925161,10925162,10925163,10925164,10925165,10925166,10925167,10922950,10922951,10922952,10922953,10622920,10620004,10620112,10620124,10620125,10920739,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,10920760,10920761,10920762,10920763,10920764,10920765,10920766,10920767,10920768,10920769,10920770,10920771,10920772,10920773,10920774,10920775,10920776,10920777,10920778,10920779,10920780,10920781,10920782,10920783,10920784,10920785,10920786,10920787,10920788,10920789,10920790,10920791,10920792,10920793,10920794,10920795,10920796,10920797,10920798,10920799,10920800,10920801,10920802,10920803,10920804,10920805,10920806,10920807,10920808,10920809,10920810,10920811,10920812,10920813,10920814,10920815,10920816,10920817,10920818,10920819,10920820,10920821,10920822,10920823,10920824,10920825,10920826,10920827,10920828,10920829,10920830,10920831,10920832,10920833,10920834,10920835,10920836,10920837,10920838,10920839,10920840,10920841,10920842,10920843,10920844,10920845,10920846,10920847,10920848,10920849,10920850,10920851,10920852,10920853,10920854,10920855,10920856,10920857,10920858,10920859,10920860,10920861,10920862,10920863,10920864,10920865,10920866,10920867,10920868,10920869,10920870,10920871,10920872,10920873,10920874,10920875,10920876,10920877,10920878,10920879,10920880,10920881,10920882,10920883,10920884,10920885,10920886,10920887,10920888,10920889,10920890,10920891,10920892,10920893,10920894,10920895,10920896,10920897,10920898,10920899,10920900,10920901,10920902,10920903,10920904,10920905,10920906,10920907,10920908,10920909,10920910,10920911,10920912,10920913,10920914,10920915,10920916,10920917,10920918,10920919,10920920,10920921,10920922,10920923,10920924,10920925,10920926,10920927,10920928,10920929,10920930,10920931,10920932,10920933,10920934,10920935,10920936,10920937,10920938,10920939,10920940,10920941,10920942,10920943,10920944,10920945,10920946,10920947,10920948,10920949,10920950,10920951,10920952,10920953,10920954,10920955,10920956,10920957,10920958,10920959,10920960,10920961,10920962,10920963,10920964,10920965,10920966,10920967,10920968,10920969,10920970,10920971,10920972,10920973,10920974,10920975,10920976,10920977,10920978,10920979,10920980,10920981,10920982,10920983,10920984,10920985,10920986,10920987,10920988,10920989,10920990,10920991,10920992,10920993,10920994,10920995,10920996,10920997,10920998,10920999,10921000,10921001,10921002,10921003,10921004,10921005,10921006,10921007,10921008,10921009,10921010,10921011,10921012,10921013,10921014,10921015,10921016,10921017,10921018,10921019,10921020,10921021,10921022,10921023,10921024,10921025,10921026,10921027,10921028,10921029,10921030,10921031,10921032,10921033,10921034,10921035,10921036,10921037,10921038,10921039,10921040,10921041,10921042,10921043,10921044,10921045,10921046,10921047,10921048,10921049,10921050,10921051,10921052,10921053,10921054,10921055,10921056,10921057,10921058,10921059,10921060,10921061,10921062,10921063,10921064,10921065,10921066,10921067,10921068,10921069,10921070,10921071,10921072,10921073,10921074,10921075,10921076,10921077,10921078,10921079,10921080,10921081,10921082,10921083,10921084,10921085,10921086,10921087,10921088,10921089,10921090,10921091,10921092,10921093,10921094,10921095,10921096,10921097,10921098,10921099,10921100,10921101,10921102,10921103,10921104,10921105,10921106,10921107,10921108,10921109,10921110,10921111,10921112,10921113,10921114,10921115,10921116,10921117,10921118,10921119,10921120,10921121,10921122,10921123,10921124,10921125,10921126,10921127,10921128,10921129,10921130,10921131,10921132,10921133,10921134,10921135,10921136,10921137,10921138,10921139,10921140,10921141,10921142,10921143,10921144,10921145,10921146,10921147,10921148,10921149,10921150,10921151,10921152,10921153,10921154,10921155,10921156,10921157,10921158,10921159,10921160,10921161,10921162,10921163,10921164,10921165,10921166,10921167,10921168,10921169,10921170,10921171,10921172,10921173,10921174,10921175,10921176,10921177,10921178,10921179,10921180,10921181,10921182,10921183,10921184,10921185,10921186,10921187,10921188,10921189,10921190,10921191,10921192,10921193,10921194,10921195,10921196,10921197,10921198,10921199,10921200,10921201,10921202,10921203,10921204,10921205,10921206,10921207,10921208,10921209,10921210,10921211,10921212,10921213,10921214,10921215,10921216,10921217,10921218,10921219,10921220,10921221,10921222,10921223,10921224,10921225,10921226,10921227,10921228,10921229,10921230,10921231,10921232,10921233,10921234,10921235,10921236,10921237,10921238,10921239,10921240,10921241,10921242,10921243,10921244,10921245,10921246,10921247,10921248,10921249,10921250,10921251,10921252,10921253,10921254,10921255,10921256,10921257,10921258,10921259,10921260,10921261,10921262,10921263,10921264,10921265,10921266,10921267,10921268,10921269,10921270,10921271,10921272,10921273,10921274,10921275,10921276,10921277,10921278,10921279,10921280,10921281,10921282,10921283,10921284,10921285,10921286,10921287,10921288,10921289,10921290,10921291,10921292,10921293,10921294,10921295,10921296,10921297,10921298,10921299,10921300,10921301,10921302,10921303,10921304,10921305,10921306,10921307,10921308,10921309,10921310,10921311,10921312,10921313,10921314,10921315,10921316,10921317,10921318,10921319,10921320,10921321,10921322,10921323,10921324,10921325,10921326,10921327,10921328,10921329,10921330,10921331,10921332,10921333,10921334,10921335,10921336,10921337,10921338,10921339,10921340,10921341,10921342,10921343,10921344,10921345,10921346,10921347,10921348,10921349,10921350,10921351,10921352,10921353,10921354,10921355,10921356,10921357,10921358,10921359,10921360,10921361,10921362,10921363,10921364,10921365,10921366,10921367,10921368,10921369,10921370,10921371,10921372,10921373,10921374,10921375,10921376,10921377,10921378,10921379,10921380,10921381,10921382,10921383,10921384,10921385,10921386,10921387,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921412,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10921426,10921427,10921428,10921429,10921430,10921431,10921432,10921433,10921434,10921435,10921436,10921437,10921438,10921439,10921440,10921441,10921442,10921443,10921444,10921445,10921446,10921447,10921448,10921449,10921450,10921451,10921452,10921453,10921454,10921455,10921456,10921457,10921458,10921459,10921460,10921461,10921462,10921463,10921464,10921465,10921466,10921467,10921468,10921469,10921470,10921471,10921472,10921473,10921474,10921475,10921476,10921477,10921478,10921479,10921480,10921481,10921482,10921483,10921484,10921485,10921486,10921487,10921488,10921489,10921490,10921491,10921492,10921493,10921494,10921495,10921496,10621162,10621163,10621164,10621165,10621343,10621344,10614048,10565334,10614735,10614736,10563160,10563161,10563162,10563163,10563164,10563165,10563166,10563167,10563168,10563169,10563170,10563171,10563172,10563173,10563174,10563175,10612577,10612918,10612919,10612920,10612946,10612947,10612948,10613080,10613208,10613573,10613696,10613722,10517272,10517273,10517274,10517275,10517276,10518585,10518586,10518587,10518588,10518589,10518590,10518591,10518592,10518593,10518594,10419373,10419527,10419528,10419529,10419530,10419531,10419718,10419719,10419720,10419721,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419735,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10420145) 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'