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(4970666,4970667,4970668,4970669,4970700,4970701,4970703,4970719,4970720,4970721,4970722,4970723,4970724,4970746,4970757,4970769,4970773,8067904,8067905,8067921,8067922,8067923,8067927,10931620,10931897,10932570,10932571,10932572,10932573,10932711,10933036,10933039,10933045,10933046,10933047,10933053,10933054,10933055,10942643,8970213,8970214,8970225,10931197,10940580,10940583,10940584,10940585,10940618,10940619,10940655,10940657,10940658,10940659,10940660,10940665,10940667,10940668,10940669,10940672,10940675,10940677,10940681,10940782,10940926,10940936,10940983,10940984,10941001,10941008,10941010,10941019,10941020,10941021,10941022,10941035,10941358,10941359,10941361,10941362,10941366,10941368,10941377,10941379,10941387,10941393,10941395,10941413,10941414,10941419,10941421,10941440,10941441,10941444,10941467,10941469,10941470,10941471,10941575,10941576,10941577,10941602,10941606,10941607,10941638,10941641,10941643,10941644,10941729,10941732,10941733,10942022,8073547,10623061,10623064,10623065,10623069,10623098,10623235,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623505,10623508,10623510,10623511,10623512,10623515,10623524,10623525,10623526,10623529,10623544,10623545,10623546,10623550,10623554,10623555,10623556,10623558,10623559,10623560,10623561,10623562,10623563,10623564,10623587,10623588,10623589,10623590,10623632,10623633,10623634,10624898,10624901,10624902,10624904,10624905,10624906,10624907,10624910,10624911,10624912,10624913,10624914,10624919,10621966,10621971,10621972,10621975,10622155,10622156,10622157,10622169,10622170,10622171,10622172,10622185,10622188,10622197,10622199,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622363,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622536,10622772,10622927,10620164,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620207,10620208,10620213,10620214,10620232,10620253,10620254,10620255,10620256,10620257,10620258,10620259,10620267,10620283,10620284,10620285,10620327,10620441,10620442,10620443,10620444,10620465,10620467,10620483,10620537,10620538,10620540,10620563,10620585,10620591,10620592,10620593,10620594,10620595,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620620,10620621,10620622,10620623,10620628,10620708,10620742,10620747,10620764,10620855,10620856,10620933,10620934,10620935,10620936,10620964,10620981,10620982,10621103,10621229,10621649,10621751,10621957,10621959,10621960,10613962,10613963,10613964,10613965,10613966,10613967,10613968,10613969,10613970,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10613985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10613995,10613996,10613997,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,10614074,10614177,10614199,10614325,10614338,10614355,10614378,10614419,10614420,10614421,10614422,10614423,10614444,10614493,10614497,10614498,10614502,10614516,10614518,10614538,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10614558,10614571,10614588,10614592,10614593,10614619,10614632,10614726,10614727,10614728,10614729,10614730,10614731,10614749,10614864,10612051,10612052,10612053,10612060,10612127,10612128,10612129,10612130,10612131,10612168,10612169,10612170,10612206,10612228,10612290,10612313,10612343,10612344,10612381,10563556,10563557,10563558,10612480,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612809,10612811,10612812,10612813,10612815,10612816,10612817,10612883,10612907,10612910,10612911,10612912,10612913,10612914,10612945,10612973,10612979,10612980,10612981,10612982,10612983,10612984,10612985,10612986,10612987,10612988,10612989,10612990,10612991,10612992,10612993,10612994,10612995,10613022,10613023,10613027,10613174,10613260,10613261,10613262,10613263,10613264,10613265,10613266,10613267,10613268,10613269,10613270,10613271,10613272,10613273,10613274,10613275,10613276,10613277,10613278,10613279,10613280,10613281,10613282,10613283,10613284,10613285,10613286,10613287,10613288,10613289,10613290,10613291,10613292,10613315,10613350,10613356,10613357,10613359,10613381,10613387,10613390,10613393,10564549,10564550,10564551,10613403,10613420,10613421,10613430,10613431,10613432,10613433,10613524,10613525,10613563,10613564,10613636,10613637,10613639,10613640,10613641,10564838,10564839,10613693,10613743,10613746,10613757,10613795,10613796,10613797,10613798,10613799,10613800,10613801,10613802,10613803,10613804,10613805,10613806,10419252,10419253,10419254,10419266,10419267,10419268,10419269,10419270,10419271,10419272,10419273,10419274,10419275,10419276,10419277,10419278,10419279,10419280,10419281,10419282,10419283,10419284,10419285,10419287,10419288,10419292,10419293,10419294,10419295,10419296,10419299,10419407,10419408,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419511,10419512,10419513,10419514,10419516,10419517,10419518,10419519,10419520,10419524,10419525,10419526,10419527,10419536,10419537,10471134,10471135,10471136,10471167,10469900,10469957,10469958,10469959,10469960,10469961,10469962,10469963,10469964,10469965,10469966,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10469990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470001,10470002,10470003,10470004,10470005,10470006,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470015,10470016,10470017,10470018,10470019,10470020,10470021,10470022,10470023,10470024,10470025,10470026,10470027,10470028,10470029,10470030,10470031,10470032,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,10470087,10470088,10470695,10470724,10470735,10470736,10470737,10470738,10470739,10470740,10470741,10470742,10470743,10470744,10470745,10470746,10470747,10470748,10470749,10470750,10470751,10470752,10470753,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470762,10470763,10470764,10470765,10470766,10470767,10470768,10470769,10470770,10470771,10470772,10470773,10470774,10470775,10470776,10470777,10470778,10470779,10470780,10470781,10470782,10470783,10470784,10470785,10470786,10470787,10470788,10470789,10470790,10470791,10470792,10470793,10470794,10470795,10470796,10470797,10470798) 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'