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(8569558,7065943,7065968,7065981,7065982,7065983,7065984,7065985,7065986,7065987,7065988,7065989,7065990,7066008,7066125,7066144,7066145,7066146,7066165,7066166,7066167,7066168,7066169,7066170,7066171,7066237,7066238,7066239,7066267,8067903,8067938,8067939,10195119,10194276,10194866,8860427,8860428,8860429,8860430,8860431,8860433,8860434,10190123,10190299,10190300,10618320,10623502,8070774,8070775,10616984,10617016,10617048,10617049,10617050,10617058,10617059,10617060,10228256,10617210,10617211,10617212,10228772,10228773,10228774,10228775,10228776,10228777,10228778,10228791,10228792,10228793,10228794,10228883,10614970,8569936,10620119,10620120,10615249,10615250,10615251,10615252,10615253,10615254,10615255,10615256,10615257,10615258,10615259,10615372,10615376,10615411,10615496,10615497,10615498,10615534,10615536,10615538,10615540,10615547,10615598,10615600,10615602,10615608,10615611,10615612,10615613,10615616,10615617,10615619,10615634,10615637,10615644,10615650,10615651,10615655,10615657,10615664,10615669,10615680,10615882,10616023,10616196,10616197,10616198,10616199,10616200,10616201,10616202,10616203,10616204,10616205,10616206,10616207,10616208,10616209,10616210,10616211,10616212,10616213,10616214,10616215,10616216,10616217,10616218,10616219,10616220,10616221,10616222,10616223,10616224,10616225,10616226,10616227,10616228,10616229,10616230,10616231,10616232,10616233,10616234,10616235,10616236,10616237,10616238,10616239,10616240,10616241,10616242,10616243,10616244,10616245,10616246,10616247,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616257,10616258,10616259,10616260,10616261,10616262,10616263,10616264,10616265,10616266,10616267,10616268,10616269,10616270,10616271,10616272,10616273,10616274,10616275,10616276,10616277,10616278,10616279,10616280,10616281,10616282,10616283,10616284,10616285,10616286,10616287,10616288,10616289,10616290,10616291,10616292,10616293,10616294,10616295,10616296,10616297,10616298,10616299,10616300,10616301,10616302,10616303,10616304,10616305,10616306,10616307,10616308,10616309,10616310,10616311,10616312,10616313,10616314,10616315,10616316,10616317,10616318,10616319,10616320,10616321,10616322,10616323,10616324,10616325,10616326,10616327,10616328,10616329,10616330,10616331,10616332,10616333,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10616344,10616345,10616346,10616347,10616348,10616349,10616350,10616351,10616352,10616353,10616354,10616355,10616356,10188449,10616357,10616358,10616359,10616360,10616361,10616362,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10616387,10616388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10616421,10616422,10616423,10616424,10616425,10616426,10616427,10616428,10616429,10616430,10616431,10616432,10616433,10616434,10616435,10616436,10616437,10616438,10616439,10616440,10616441,10616442,10616443,10616444,10616445,10616446,10616447,10616448,10616449,10616450,10616451,10616452,10616453,10616454,10616455,10616456,10616457,10616458,10616459,10616460,10616461,10616462,10616463,10616464,10616465,10616466,10616467,10616468,10616469,10616470,10616471,10616472,10616473,10616474,10616475,10616476,10616477,10616478,10616479,10616480,10616481,10616482,10616483,10616484,10616485,10616486,10616487,10616488,10616489,10616490,10616491,10616492,10616493,10616494,10616495,10616496,10616497,10616498,10616499,10616500,10616501,10616502,10616503,10616504,10616505,10616506,10616507,10616508,10616509,10616510,10616511,10616512,10616513,10616514,10616515,10616516,10616517,10616518,10616519,10616520,10616521,10616522,10616523,10616524,10616525,10616526,10616527,10616528,10616529,10616530,10616531,10616532,10616533,10616534,10616535,10616536,10227656,10616648,10616649,10621651,10621657,10621672,10621673,10621682,10621687,10621705,10616735,10616888,10616955,10616960,10614022,10614023,10614047,10562227,10614088,9165541,10614212,10614220,10559631,10614502,10614508,10614540,10614541,10614542,10614543,10614544,10614545,10614546,10614547,10559766,10614661,10614696,10614702,10614711,10614713,10614714,10614735,10614736,10614828,10614829,10614830,10614831,10614832,10614833,10614834,10614835,10614836,10614837,10614838,10614839,10614840,10614841,10614842,10614843,10614844,10614845,10614846,10614847,10614848,10614849,10614850,10614851,10614852,10614853,10614854,10614922,10614925,10566080,10566081,10566082,10566083,10614957,10612039,10612041,10612042,10612045,10612051,10612059,10612060,10612079,10612171,10612172,10612173,10612174,10612175,10612176,10612177,10612178,10612179,10612180,10612181,10612182,10612183,10612184,10612185,10612186,10612187,10612188,10612264,10612320,10612321,10612480,8862508,8862509,8862529,8862530,8862558,8862572,8862573,10612746,10612747,10612750,10612752,10612754,10612783,10612785,10612786,10612788,10612790,10612791,10612792,10612793,10612794,10612796,10612884,10612916,10612933,10613024,10613025,10613026,10613328,10613329,10613330,10613331,10613332,10613333,10613334,10613335,10613336,10613337,10613338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10613527,10613654,10613732,10613733,10613743,10613744,10613781,10613782,10613783,9169299,9169300,7055467,7055468,9169316,9169318,9169319,7055536,7055537,9169371,9169372,7055538,9169373,7055539,9169374,7055540,7055541,9169375,7055542,7055543,7055544,7055545,7055546,7055547,7055548,9169383,9169385,9169453,7055671,7055672,7055673,7055674,9169522,9169523,10513342,10513343,9169536,9169537,9169567,9169748,9169749,9169750,9169901,9169902,9169903,9169939,9169940,9169941,9169996,10513988,10516171,10516172,10516173,10516174,10516175,10516176,10512852,9168299,9168300,9168301,9168302,9168303,9168304,9168305,9168306,9168307,9168308,9168309,9168310,9168311,10417271,10419332,10419371,10419372,10419377,10417429,10417430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,10417440,10417441,10417442,10418486,10417486,10417493,10419522,10419523,10416569,10416570,10416571,10416572,10416573,10416574,10416575,10416576,10416577,10416578,10416579,10416580,10416581,10416582,10416583,10416584,10416585,10416586,10416587,10416588,10416589,10416590,10416591,10416592,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,10416610,10416611,10416612,10416613,10416617,10416640,10416641,10416649,10416650,10416651,10416652,10416653,10416654,10416655,10416656,10416658,10416659,10416660,10416661,10416662,10416673,10416674,10418794,10419794,10418795,10419795,10419796,10418796,10419797,10418797,10419798,10418798,10419799,10418799,10419800,10418800,10419801,10418801,10418802,10418803,10418804,10418805,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,10419019,10418042,10470999,10471000,10471001,10471002,10471003,10471004,10471005,10471006,10471007,10471008,10471009,10471010,10471011,10471012,10471013,10471014,10471015,10471016,10471017,10471018,10471019,10471020,10471021,10471022,10471023,10471024,10471025,10471026,10471170,10469337,10469487,10469488,10469489,10469490,10469622,10469623,10469624,10469625,10469626,8916773,8916774,8916796,8916798,10469853,10469854,10469855,10469856,10469857,10469927,10469928,4972259,10467999,10468000,10468001,10468002,10468003,10468004,10468005,10468006,10468007,10468008,10468009,10468010,10468011,10468012,10468013,10470089,10470092,10470093,10470094,10470095,10470096,10468175,10468176,10468330,10468331,10468332,10468333,10468334,10468335,10468336,10468337,10468338,10468339,10468340,10468341,10468342,10468343,10468344,10468345,10468346,10468347,10468348,10468473,10468474,10468475,10468476,10468477,10468478,10468479,10468480,10468481,10468482,10468483,10468484,10468485,10468486,10468487,10468488,10468489,10468490,10468491,10468492,10468493,10468494,10468495,10468496,10468497,10470697,10632012,10632107,10632108,10627410,10627411,10627412,10627413,10627414,10627415,10627712,10522838,10474272,10474321,10476334,10476335,10476336,10476337,10474343,10474344,10474372,10474542) 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'