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(11001534,11001535,8068881,8068882,8068883,8068884,7075953,7076113,7068155,7068156,7068238,7068272,11001983,11001984,7068359,11002063,11002064,11002065,10940180,11002271,11002272,11002273,11002274,11002306,11002307,11002485,11002486,10963498,11002639,11002640,11002641,11002653,11002654,11002655,11002656,11002657,11002658,11002659,7074039,7074087,7074088,8067213,7074166,7074167,7074168,7074169,7074186,11002934,11002935,8067325,10976973,10976974,10976975,10976976,10976977,10976978,10976979,4968634,11003046,11003047,11003048,8067695,10437621,10437622,10437623,11003383,11003393,7074740,7074741,7074742,7074743,7074744,7074745,7074746,7074747,7074748,7074749,7074750,7074751,7074752,7074753,7074754,10964438,7074755,7074756,7074757,10990472,10990473,10990474,10961529,7074894,7074895,8067907,7066977,10961675,10961676,7075007,10987883,10987884,10987885,10987886,10987893,10987894,10987895,10987896,10987897,10987898,10987899,10987900,10987901,10987969,10987970,10988256,10962330,10972733,10972739,10972740,10972823,10972958,10986091,7072508,7064547,7064548,7072582,7072623,7072678,7072723,10999409,7072821,8066001,10999643,10999644,10999645,10999646,10999647,10999648,10961322,10961323,8860930,10942854,10942855,10942856,10942857,10942858,10942859,10942860,10942861,10942862,10942863,10942864,10942865,10942866,10942867,10942868,10942869,10942870,10942871,10942872,10942873,10942874,10942875,10942876,10942877,10942878,10942879,10942880,10942881,10942882,10942883,10942884,10942885,10942886,10943076,10943077,10943078,10943079,10943080,10943081,10943082,10943083,8861297,8861331,10972112,8861332,8861333,8861334,10959117,10985277,10985302,10985303,10985390,10985391,10985392,10985393,7071716,10985403,10972408,10985494,10985495,10985496,7069251,10970023,10970039,10970040,10970041,10970042,10970043,10970044,10970045,10970046,10970194,10970427,10970428,10970429,10970430,10970431,10970432,10970433,3656464,3656485,10970593,10941679,10983759,10970764,10970765,10970766,10970787,10970788,10997011,10971102,10997103,10997121,10997122,10997123,10971177,10971219,10997227,10997228,10971293,8073513,10997450,10997451,10997454,10997455,10997456,10997457,10918548,10918554,10918555,10918556,10918557,10967620,10967621,10967622,10618088,10918673,10623343,10623437,10918981,10918982,10918983,10918984,10918985,10919031,10919032,10919327,10919328,10919329,10919330,10919356,10919357,10919358,10618953,10618954,10994603,10994604,10968661,10968662,10968663,10919669,10919670,10994699,10919671,10994700,10994701,10994702,10994703,10994719,10994720,10919695,10919696,10919697,10994768,10994769,10919869,10925170,10925171,10925172,10925173,10925174,10925175,10925176,10969313,10969314,10969315,10969316,10969317,10969408,10969409,10969410,10969411,10969412,10969413,10969414,10969415,10969416,10969417,10969418,10969419,10969420,10917567,10622094,10917788,10917789,10917790,10622441,10917990,10617498,10923023,10923024,10923025,10617515,10923026,10923027,10923028,10923029,10923030,10923031,10923032,10923033,10923034,10923035,10923036,10923037,10923038,10923039,10923040,10923041,10923042,10923043,10923044,10923045,10923046,10918047,10923047,10918048,10923048,10918049,10923049,10923050,10923051,10923052,10923053,10923054,10923055,10923056,10923057,10923058,10923059,10923060,10923061,10928061,10923062,10923063,10923064,10918064,10923065,10918065,10923066,10923067,10923068,10923069,10923070,10923071,10923072,10923073,10923074,10923075,10923076,10923077,10918187,10918188,10918206,10918207,10918208,10918209,10622751,10928279,10918387,10918388,10918389,10918390,10918391,10918406,10918407,10622904,10622910,10925496,10920784,10920785,10920786,10920794,10620341,10916236,10916237,10916238,10926308,10926309,10615848,10921428,10921787,10921788,10921789,10991960,10991961,10921968,10917262,10917263,10992302,10992303,10992304,10992305,10992306,10992307,10992308,10992309,10992310,10992311,10992312,9165545,10614465,7057633,10557580,10609929,10609945,7058700,7058701,8863136,7058955,7058956,7058957,7058958,7058959,7058960,7058961,7058962,7058963,7058964,7058965,7058966,7058967,7058968,7058969,7058970,7058971,7058972,7058973,7058974,7058975,7058976,7058977,7058978,7058979,7058980,7058981,7058982,7058983,7058984,7058985,7058986,7058987,7058988,7058989,7058990,7058991,7058992,7058993,7058994,7058995,7058996,7058997,7058998,7058999,7059000,7059001,7059002,7059003,7059004,7059005,7059006,7059007,7059008,7059009,7059010,7059011,7059012,7059013,7059014,7059015,7059016,7059017,7059018,7059019,7059020,7059021,7059022,7059023,9172857,7059024,7059025,7059026,7059027,7059028,7059029,7059030,7059031,7059032,7059033,7059034,7059035,7059036,7059037,7059038,7059039,7059040,7059041,7059042,7059043,7059044,7059045,7059046,7059047,7059048,7059049,7059050,7059051,7059052,7059053,7059054,7059055,9172890,7059056,7059057,7059058,7059059,7059060,9172913,7059362,7059363,7059364,7059365,7059366,7059367,7059368,7059369,7059370,7059371,7059372,7059373,7059374,7059375,7059376,7059377,7059378,7059379,7059380,7059381,7059382,7059383,7059384,7059385,7059386,7059387,7059388,7059389,7059390,7059391,7059392,7059393,7059394,7059395,7059396,7059397,7059398,7059399,7059400,7059401,7059402,7059403,7059404,7059405,7059406,4974512,9161673,10513778,10555850,10555851,10555852,10555853,10555854,10555855,10555856,10556073,10556074,10556075,10556076,10556077,10556078,10556084,10556085,10556239,4975288,9170639,10514662,10514663,10514664,10514665,10514666,10514667,10514668,10514669,10514670,10514671,10514672,10514788,10514789,10514790,10514791,10514792,10514793,10514828,7057254,10516955,9160305,9160315,10415239,10415240,9160330,10415306,10415307,4973426,4973427,4973430,4973431,4973433,8918262,10417134,10416170,10416171,8864829,9166855,10465710,10469844,6667269,6667270,6667271,6667272,6667273,6667274,6667275,9167307,9167308,9167309,9167310,10465916,10465917,10470017,10470018,10470019,8563380,10470131,10470404,10470522,10470525,6668175,10164590,10164591,10164645,10164646,10164647,10164648,10164649,10164650,10164799,10164994,10164995,10165245,10165268,10165758,10165759,10165760,10165761,10165762,10165763,10165764,10165765,10165766,10165767,10165768,10166125,10166126,10166149,10166196,10166197,10166198,10629685,10629735,10629941,10629942,10629943,10166476,10166477,10626988,10630077,10630103,10162194,10630672,10630673,10630674,10630675,10630676,10630677,10630678,10630679,10630680,10630681,10630682,10630683,10630684,10630685,10630686,10630687,10630688,10630689,10630690,10630691,10630692,10630693,10630694,10630695,10630696,10630697,10630698,10630699,10630700,10630701,10630702,10630703,10630704,10630705,10630706,10630707,10630708,10630709,10630710,10630711,10630712,10630713,10630714,10630715,10630716,10630717,10630718,10630719,10630720,10630721,10630722,10630723,10630724,10630725,10630726,10630727,10630728,10630729,10630730,10630731,10630732,10630733,10630734,10630735,10630736,10630737,10630738,10630739,10630740,10630741,10630742,10630743,10630744,10630745,10630746,10630747,10630748,10630749,10630750,10630751,10630752,10630753,10630754,10630755,10630756,10630757,10630758,10630759,10630760,10630761,10630762,10630763,10630764,10630765,10630766,10630767,10630768,10630769,10630770,10630771,10630772,10630773,10630774,10630775,10630776,10630777,10630778,10630779,10630780,10630781,10630782,10630783,10630784,10630785,10630786,10630787,10630788,10630789,10630790,10630791,10630792,10630793,10630794,10630795,10630796,10630797,10630798,10630799,10630800,10630801,10630802,10630803,10630804,10630805,10630806,10630807,10630808,10630809,10630810,10630811,10630812,10630813,10630814,10630815,10630816,10630817,10630818,10630819,10630820,10162546,10162572,10577232,10577233,10577234,10577237,10577285,10577286,10571498,10577580,10577581,10577582,10571668,10568711,10568712,10568713,10568714,10568715,10568741,10568742,10568743,10568744,10568745,10568746,10568747,10568748,10568749,10568750,10568751,10574826,10577939,10577940,10577941,10571953,10571954,10577957,10574997,10574998,10574999,10575000,10575001,10575002,10575003,10572014,10575225,10575226,10575227,10575228,10575229,10575230,10575231,10575232,10575233,10575234,10575235,10575236,10575253,10575254,10575255,10569368,10569369,10569370,10569371,10569372,10569373,10569374,10572375,10569375,10575471,10575472,10575473,10575474,10575475,10575483,10575599,10575600,10575601,10572709,10576003,10570156,10570157,10570158,10570159,10570160,10570763,10570764,10567913,10567914,10567915,10567916,10567917,10567918,10574080,10523161,10523162,10523163,10523164,10523165,10523166,10523167,10523168,10523169,10523170,10523171,10523172,10523173,10523174,10523175,10523176,10521213,10525563,10524906,10526912,10523041,10420544,10420545,10477484,10477491,10477492,10477526,10474278,10474681,10474682,10476839,10476840) 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'