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(4970692,4970693,4970694,4970695,4970696,4970697,4970698,8569558,8583512,10950720,7066172,10863052,10863053,10863054,10863055,8067914,8067915,8573261,8629780,8629781,8629782,8629783,8629784,8629785,8573317,8629786,8629804,8629805,8629806,8629807,8629808,8630301,7201323,7201624,7201647,8595137,8595226,8595227,8595228,7201875,7201876,7201877,7201878,7201879,7201880,7201881,7201882,7201883,7201884,10960336,7202050,7202051,7202052,10859313,10859314,10859315,10859316,10859317,10859318,10859319,10859320,10859321,10859322,10859323,10859324,10859325,10859326,10859327,10859328,10859329,10859330,10859331,10859332,10859333,10859334,10859335,10859336,10859337,10859338,10859339,10859340,10859341,10859342,10859343,10859344,10859345,10859346,10859347,10859348,10859349,10859350,10859351,10859352,10859353,10859354,10859355,10859356,7202347,5654609,5654610,5654611,7200723,7200725,7200726,7200728,7200730,7200932,7200933,7198207,7198208,7198209,7198210,7198211,7198212,7198213,7198214,7198215,7198216,7198217,7198218,7198219,7198220,7198221,7198222,7198223,7198224,7198225,7198226,7198227,7198228,7198229,7198230,7198231,7198232,7198233,7198234,7198235,7198236,7198237,7198238,7198239,7198240,7198241,7198242,7198243,7198244,7198245,7198246,7198247,7198248,7198249,7198250,7198251,7198252,7198253,7198254,7198255,7198256,7198257,7198258,7198259,7198260,7198261,7198262,7198263,7198264,7198265,7198266,7198267,7198268,7198269,7198270,7198271,7198272,7198273,7198274,7198275,7198276,7198277,7198278,7198279,7198280,7198281,7198282,7198283,7198284,7198285,7198286,7198287,7198288,7198289,7198290,7198291,7198292,7198293,7198294,7198295,7198296,7198297,7198298,7198299,7198300,7198301,7198302,7198303,7198304,7198305,7198306,7198307,7198308,7198309,7198310,7198311,7198312,7198313,7198314,7198315,7198316,7198317,7198318,7198319,7198320,7198321,7198322,7198684,7199400,7199402,7199403,7199406,7199414,7199415,7199550,3923518,3923519,3923520,3923521,8554314,10838826,10838827,10838828,10838873,10838874,10617307,10617308,10617309,10617310,10617311,10617312,10617313,10617314,10617315,10617316,10617317,10617318,8905480,8905481,8905482,8905483,8905484,8905485,8905486,8905487,8905488,8905489,8905490,8905491,8905492,8905493,8905494,8905495,8905496,8905497,8905498,8905499,8905500,8905501,8905502,8905503,8905504,8905505,8905506,8905507,8905508,8905509,8905510,8905511,8905512,8905513,8905514,8905515,8905516,8905517,8905518,10615232,10615260,10615261,10615262,10615263,3231144,10615870,10426329,10426330,10426331,10426332,10426333,10426367,10426368,8611343,8611344,10616842,10616846,10616847,10616848,10714137,10714140,10614419,10614420,10614421,10614422,10614423,10611762,8549450,10609287,10612344,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612494,10612495,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612504,10612505,10612506,10612507,10612508,10612509,10612510,10612511,10612512,10612513,10612514,10612515,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612533,10612534,10612535,10612536,10612537,10612538,10612539,10612540,10612541,10612542,10612543,10612544,10612545,10612546,10612547,10612548,10612549,10612550,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612560,10612561,10612562,10612563,10612564,10612565,10612566,10612567,10612568,10612569,10612570,10612571,10612572,10612573,10612574,10612575,10612576,10612577,10612578,10612579,10612580,10612581,10612582,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612590,10612591,10612592,10612593,10612594,10612595,10612596,10612597,10612598,10612599,10612600,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10612611,10612612,10612613,10612614,10612615,10612616,10612617,10612618,10612619,10612620,10612621,10612622,10612623,10612624,10612625,10612626,10612627,10612628,10612629,10612630,10612631,10612632,10612633,10612634,10612635,10612636,10612637,10612638,10612639,10612640,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612649,10612650,10612651,10612652,10612653,10612654,10612655,10612656,10612657,10612658,10612659,10612660,10612661,10612662,10612663,10612664,10612665,8851827,10612666,8862525,8851828,10612667,8851829,10612668,8851830,10612669,8851831,10612670,8851832,10612671,8851833,10612672,8851834,10612673,8851835,10612674,8851836,10612675,8851837,10612676,8851838,10612677,8851839,10612678,8851840,10612679,8851841,10612680,8851842,10612681,8851843,10612682,8851844,10612683,8851845,10612684,8851846,10612685,8851847,10612686,8851848,10612687,8851849,10612688,8851850,10612689,8851851,10612690,8851852,10612691,8851853,10612692,8851854,10612693,8851855,10612694,8851856,10612695,8851857,10612696,8851858,10612697,8851859,10612698,8851860,10612699,8851861,10612700,8851862,10612701,8851863,10612702,8851864,10612703,8851865,10612704,8851866,10612705,10612706,10612707,10612708,10612709,10612710,10612711,10612712,10612713,10612714,10612715,10612716,10612717,10612718,10612719,10612720,10612721,10612722,8566631,8566632,10612945,10610298,10610318,10610319,9169454,9169455,9169463,10117997,10117998,10117999,10118000,10118001,10118002,10118003,10118004,10118005,10118006,10118007,6674108,6674109,10118339,10118340,10118341,10118342,9912366,9912367,9912368,9912369,9912370,9912371,9912372,9912373,9912374,9912375,9912376,9912377,9912378,9912379,9912380,9912381,9912382,9912383,9912384,9912385,9912386,9912387,9912388,9912389,9912390,9912391,9912392,9912393,9912394,9912395,9912396,9912397,9912398,9912399,9912400,9912401,9912402,9912807,9912808,9912971,9912979,9168674,9168675,9168676,9168677,9168678,9168679,9168680,9168681,9168682,9168683,9168684,9168685,9168686,9168687,9168688,9168689,9168690,10417645,6673475,6673476,6673477,6673478,6673479,6673480,6673481,6673482,6673483,6673484,6673485,6673486,6673487,6673488,6673489,8550042,8550043,8550044,10469929,10469930,976472,976489,976490,976491,10468688,10468689,10468690,10468691,10468692,10468693,10468694,10468695,10468696,10468697,10468698,10468699,10468700,10468701,10468702,10468703,10468704,10468705,10468706,10468707,10468708,10468709,10468710,10468711,10468712,10468713,10468714,10468715,10468716,10468717,10468718,10468719,10468720,10468721,10468722,10468723,10468724,10468725,10468726,10468727,10468728,10468729,10468730,10468731,10468732,10468733,10468734,10468735,10468736,10468737,10468738,10468739,10468740,10468741,10468742,10468743,10468744,10468745,10468746,10468747,10468748,10468749,10468750,10468751,10884574,10889701,10889702,10889703,10889704,10889705,10884709,10884710,10885018,10885230,10885231,10885232,10885233,10885234,10885235,10885236,10885237,10885238,10885239,10885240,10885241,10885242,10885243,10885244,10885245,10885246,10885247,10885248,10885249,10885250,10885251,10885252,10885253,10885254,10885255,10885256,10885257,10885258,10885259,10885260,10885261,10885262,10885263,10885264,10885265,10885266,10885267,10885268,10885269,10885270,10885271,10885272,10885273,10885274,10885275,10885276,10885277,10885278,10885279,10885280,10885281,10885282,10885283,10885284,10888310,10888311,10888312,10888313,10888314,10888315,10888316,10888317,10888318,10888319,10888320,10162003,10162004,10162005,10162006,10162007,10162008,10162009,10162010,10882354,10887361,10887362,10887363,10887364,10887365,10887366,10887367,10887368,10887369,10887370,10887371,10887372,10887373,10887374,10887375,10887376,10647503,10647504,10647505,10647597,10604692,10507732,10507733,10507734,10507735,10413744,10413745,10413746,10413747,10413748,10413749,10413750,10413751,10413752,10413753,10413754,10413755,10413756,10413757,10413758,10413759,10413760,10413761,10413762,10413763,10413764,10413765,10413766,10413767,10413768,10413769,10413770,10413771,10413772,10413773,10413774,10413775,10413776,10413777,10413778,10413779,10413780,10413781,10413782,10413783,10413784,10413785,10413786,10413787,10413788,10413789,10413790,10413791,10413792,10413793,10413794,10413795,10413796,10413797,10413798,10413799,10413800,10413801,10413802,10413803,10413804,10413805,10413806,10413807,10413808,10413809,10413810,10413811,10413812,10413813,10413814,10413815,10413816,10413817,10413818,10413819,10413820,10413821,10413822,10413823,10413824,10413825,10413826,10413827,10413828,10413829,10413830,10413831,10413832,10413833,10413834,10413835,10413836,10413837,10413838,10413839,10413840,10413841,10413842,10413843,10413844,10413845,10413846,10413847,10413848,10413849,10413850,10413851,10413852,10413853,10413854,10413855,10413856,10414007) 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'