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(4970679,4970700,4970715,4970716,4970717,4970739,4970740,4970741,4970742,4970743,4970744,4968342,8067924,8067925,8067933,8067934,8067935,8067936,10939416,10939423,8065845,8065846,8065848,8065850,10942755,3656343,3656344,3656345,3656346,10623490,10622031,10622260,10622261,10622263,10622268,10622343,10622360,10622362,10622371,10622400,10622409,10622434,10622457,10622458,10620200,10620201,10620202,10610965,10610984,10610985,10614048,10614050,10611126,10611176,10614220,10611226,10614236,10611237,10611238,10611239,10611240,10611241,10611242,10611245,10614259,10614327,10614328,10614329,10614376,10614377,10614407,10614408,10614409,10614410,10614411,10614412,10614413,10614414,10614415,10614416,10614518,10614555,10614572,10614592,10614597,10614598,10614599,10614600,10614601,10614602,10614603,10614604,10614605,10614606,10614607,10614608,10614609,10614610,10614611,10614612,10614613,10614614,10614615,10614616,10614617,10614618,10614619,10614620,10614621,10614622,10614623,10614624,10614625,10614626,10611685,10611727,10611728,10611729,10611730,10611731,10611732,10611733,10611734,10611735,10611736,10611737,10611738,10611739,10611740,10611741,10611742,10611743,10611744,10611745,10611746,10611747,10611748,10611749,10611750,10611751,10611752,10611753,10611754,10611755,10611756,10611757,10611779,10611802,10611823,10611856,10611861,10611862,10611864,10611877,10611878,10609306,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609385,10609386,10609816,10609817,10609818,10609819,10609820,10609821,10609822,10609823,10609824,10609825,10609826,10609827,10609828,10609829,10609830,10609831,10609959,10610000,10610006,10610044,10610045,10610053,10610054,10610170,10610174,10610178,10610180,10610181,10610182,10610189,10610191,10610193,10610233,10610235,10610258,10610259,10610263,10610264,10610265,10610268,10610279,10610284,10610285,10610299,10610346,10610372,10610723,10610724,10610725,10610726,10610727,10610728,10610732,10610733,10610734,10610735,10610736,10610737,10610738,10610740,10610741,10610742,10610743,10610744,10610745,10610746,10610747,10610748,10610749,10610750,10610751,10610752,10610872,10610901,10610902,10610903,10610904,10610905,10610906,10610907,10610908,10610909,10610910,10610932,10610941,10610946,10415272,10415273,10415274,10415288,10415289,10415290,10415291,10419291,10415292,10415312,10415313,10415314,10415333,10415339,10415343,10415375,10415376,10415377,10415382,10415383,10415384,10415385,10415386,10415387,10415388,10415389,10415390,10415391,10415392,10415393,10415394,10419398,10419399,10419403,10419407,10419408,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10419446,10419447,10419448,10419449,10419450,10419451,10419452,10419453,10419454,10419455,10419456,10419457,10419472,10419474,10419475,10419476,10419477,10419478,10419479,10419481,10419482,10419483,10419484,10419486,10419488,10419490,10419492,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10415634,10419635,10415635,10419636,10419641,10419642,10419643,10419644,10419645,10419651,10419652,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,10415693,10415694,10415695,10415696,10415697,10415698,10415699,10415700,10415701,10415702,10415703,10415704,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10415715,10415716,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,10415726,10415727,10415728,10415729,10415730,10415731,10415732,10415733,10415734,10415735,10415736,10415737,10415738,10415739,10415740,10415741,10415742,10415743,10415744,10415745,10415746,10415747,10415748,10415749,10415750,10415751,10415752,10415753,10415754,10415755,10415756,10415757,10415758,10415759,10415760,10415761,10415762,10415763,10415764,10415765,10415766,10415767,10415768,10415769,10415770,10415771,10415772,10415773,10415774,10415775,10415776,10415777,10415778,10415779,10415780,10415781,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10415789,10415790,10415791,10415792,10415793,10415794,10415795,10415796,10415797,10419797,10415798,10415799,10415800,10415801,10415802,10415803,10415804,10415805,10415806,10415807,10415808,10415809,10415810,10415811,10415812,10415813,10415814,10415815,10415816,10415817,10415818,10415819,10415820,10415821,10415822,10415823,10415824,10415825,10415826,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415838,10415839,10415840,10415841,10415842,10415843,10415844,10415845,10415846,10415847,10415848,10415849,10415850,10415851,10415852,10415853,10415854,10415855,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10415867,10419867,10415868,10419868,10415869,10419869,10415870,10419870,10415871,10419871,10415872,10419872,10415873,10419873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10415887,10415888,10415889,10415890,10415891,10415892,10415893,10415894,10415895,10415896,10415897,10415898,10415899,10415900,10415901,10415902,10415903,10415904,10415905,10415906,10415907,10415908,10415909,10415910,10415911,10415912,10415913,10415914,10415915,10415916,10415917,10415918,10415919,10415920,10415921,10415922,10415923,10415924,10415925,10415926,10415927,10415928,10415929,10415930,10415931,10415932,10415933,10415934,10415935,10415936,10415937,10415938,10415939,10415940,10415941,10415942,10415943,10415944,10415945,10415946,10415947,10415948,10415949,10415950,10415951,10415952,10415953,10415954,10415955,10415956,10415957,10415958,10415959,10415960,10415961,10415962,10415963,10415964,10415965,10415966,10415967,10415968,10415969,10415970,10415971,10415972,10415973,10415974,10415975,10415976,10415977,10415978,10415979,10415980,10415981,10415982,10415983,10415984,10415985,10415986,10415987,10415988,10415989,10415990,10415991,10415992,10415993,10415994,10415995,10415996,10415997,10415998,10415999,10416000,10416001,10416002,10416003,10416004,10416005,10416006,10416007,10416008,10416009,10416010,10416011,10416012,10416013,10416014,10416015,10416016,10416017,10416018,10416019,10416020,10416021,10416022,10416023,10416024,10416025,10416026,10416027,10416028,10416029,10416030,10416031,10416032,10416033,10416034,10416035,10416036,10416037,10416038,10416039,10416040,10416041,10416042,10416043,10416044,10416045,10416046,10416047,10416048,10416049,10416050,10416051,10416052,10416053,10416054,10416055,10416056,10416057,10416058,10416059,10416060,10416061,10416062,10416063,10416064,10416065,10416066,10416067,10416068,10416069,10416070,10416071,10416072,10416073,10416074,10416075,10416076,10416077,10416078,10416079,10416080,10416081,10416082,10416083,10416084,10420084,10416085,10420085,10416086,10420086,10416087,10420087,10416088,10420088,10416089,10420089,10416090,10420090,10416091,10420091,10416092,10420092,10416093,10420093,10416094,10420094,10416095,10420095,10416096,10420096,10416097,10420097,10416098,10420098,10416099,10416100,10416101,10416102,10416103,10416104,10416105,10416106,10416107,10416108,10416109,10416110,10416111,10416112,10416113,10416114,10416115,10416116,10416117,10416118,10416119,10416120,10416121,10416122,10416123,10416124,10416125,10416126,10416127,10416128,10416129,10416130,10416131,10416132,10416133,10416134,10416135,10416136,10416137,10416138,10416139,10416140,10416141,10416142,10416143,10416144,10416145,10416146,10416147,10416148,10416149,10416150,10416151,10416152,10416153,10416154,10416155,10416156,10416157,10416158,10416159,10416160,10416161,10416162,10416163,10416164,10416165,10416166,10416167,10416168,10416169,10416170,10416171,10416172,10416173,10416174,10416175,10416176,10416177,10416178,10416179,10416180,10416181,10416182,10416183,10416184,10416185,10416186,10416187,10416188,10416189,10416190,10416191,10416192,10416193,10416194,10416195,10416196,10416197,10416198,10416199,10416200,10416201,10416202,10416203,10416204,10416205,10416206,10416207,10416208,10416209,10416210,10416211,10416212,10416213,10416214,10416215,10416216,10416217,10416218,10416219,10416220,10471096,10471097,10471098,10471099,10471100,10471101,10471102,10471103,10471165,10471173,10471174,10469876,10469877,10469878,10469879,10469880,10469881,10469882,10469883,10469884,10469885,10469886,10469887,10469888,10469889,10469890,10469891,10469892,10469893,10469894,10469895,10469896,10469897,10469898,10469899,10469900,10469901,10469902,10469903,10469904,10469905,10469906,10469907,10470206,10470207,10470208,10470209,10470210,10470211,10470212,10470213,10470214,10470215,10470216,10462287,10462288,10462289,10462290,10462291) 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'