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(7076128,10943628,8839040,8583090,8583091,8583092,8583096,8583097,8583105,8583106,3229130,3229131,3229285,8575133,8575146,8575147,8575148,8575149,8575150,8575151,8575152,8575153,8575154,8575165,8575166,8575167,8583487,8583488,8583489,8583521,8583522,10950747,10950748,8583656,8583657,8583665,8583666,8583681,7066266,8573309,8573310,8573311,8573312,8573316,8573335,8573336,8573337,8573994,8573995,8573996,10930095,7201200,7201201,10842809,7201354,7201366,7201368,7201377,7201453,7201624,7201730,7201761,7201762,7201861,10960336,7201901,7201902,7201905,7201906,7201959,7201974,7201977,7202133,7202165,7202168,7202171,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202285,7202347,7202439,5654649,5654657,5654658,5654660,5654661,7202585,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,3227094,3227207,10102163,10102164,8834762,8834763,8910444,8910445,8910446,8910447,8910448,8910449,8910450,8910451,8910452,8910600,8910601,8910602,8910603,7200901,8615017,7198684,7198688,7198695,7198696,7198697,7198698,7198700,7198701,7198702,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198720,7198721,7198722,7198723,7198726,7198728,7198729,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198751,7198759,7198760,7198762,7198763,7198769,7198772,7199130,7199480,10101564,10101565,10101566,7199739,7199740,7199741,7199742,7199743,11048460,11048461,11048462,7200091,7200111,7196333,7196539,8906891,7197602,8907591,8907592,8907593,8907596,8907601,8907602,8907612,8907613,8907616,8907618,8907619,8907622,8907623,8907624,8907628,8907637,8907640,8907641,8907644,8907645,8907649,8907650,8907654,8907658,8907662,7197851,8907665,8907668,8907670,8907673,8907674,8907682,8907685,8907686,8907691,8907694,8907695,8907699,8907703,8907704,8907708,10619864,10619865,10619866,8541668,8905221,10617324,10617326,10617343,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617453,10617454,10954113,10954114,10617573,8542165,8905844,10425387,10425388,10425389,10425390,10425392,10425393,10620200,10620201,10620202,10425551,10425552,10425553,10425554,10425555,10425556,10425575,10425577,10425579,10425580,10425581,10425582,10425583,10425585,10620297,10620298,10620301,10620302,10620303,10615338,10615339,10615340,10615341,10615342,10615343,10615344,10615363,10425911,10930631,10615710,10615726,10615728,10426338,10616016,10616044,10616045,8540589,8540591,8904210,8904222,8904224,8904226,8904232,8904234,8904236,8904242,8904254,8904260,8904265,8904266,8904267,8904269,8904271,8904272,8904273,8904277,8904278,8904280,8904282,8904284,8904285,8904288,8904289,8904290,8904292,8904297,8904299,8904300,8904302,8904329,8904330,8904332,8904333,8904334,8904337,8904339,8904341,8904344,8904346,8904348,8904351,8904354,8904358,8904364,8904370,8904375,8904382,8904390,8904403,8904405,8904420,8611319,10616644,8904798,10427106,10613971,10610984,10610985,10614048,10714024,10614260,10614261,10614262,10614263,10614264,6669818,6669823,6669828,6669913,6669917,10614376,10611377,10611381,10611393,10611396,10611406,10611407,10611408,10611426,10611432,10611457,10611462,10611464,10611469,10611498,10614501,10611521,10611526,10611539,10611544,10611551,10611555,10611563,10611578,10611583,10611586,10614593,10611611,10611640,10611643,10611658,10611660,10611856,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,8549450,10611983,10611995,10611996,10611997,10612086,10612191,10612192,10612194,10612201,10119814,10609285,10609287,10612294,10609313,10612381,10612916,7017914,7017915,10612931,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,10612961,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613025,10613157,10613192,10613235,10610479,10610480,10610481,10613513,10613514,10610666,10613732,10613733,10613750,10610850,10610901,10610947,9169305,9169306,9169307,9169308,9169310,10117516,10117517,7055541,7055546,9169453,9169472,9169473,9169956,9169957,9169958,9169959,9169960,9169961,9169962,9169963,9169964,10118214,10118342,10118364,10118365,10118366,10118367,10118368,10118369,10118370,10118371,10118372,10118373,10118374,10118375,10514037,10514038,10118440,10118441,10118442,10118443,10118444,10118449,8551565,9160319,9160334,9160335,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10419370,10415370,10415373,10415374,10415375,10415376,10416481,10419497,10419498,10419511,10419512,10419513,10419514,10419515,10419524,10419528,10419529,10419532,10419533,10419534,10419536,10415585,10415586,9168796,10416718,10416719,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10419166,10419167,10419168,10419169,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,10117478,10471175,8550097,10469949,10469950,9167533,10468323,10468324,10468325,10468326,10468327,10468328,10468329,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,9168121,10470721,10470722,10888524,10883559,10883560,10883561,10883562,10883568,10883569,10883570,10883571,10883572,10883585,10883586,10883587,10883588,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883598,10883622,10883623,10883624,10883625,10883626,10883627,10883628,10883629,10883630,10883631,10888637,10888638,10888639,10888640,10888641,10888642,10883659,10883660,10883661,10883664,10883665,10883668,10884041,10884042,10889052,10884068,10884483,10889585,10884653,10889707,10889718,10884788,10884793,10889997,10875001,10890006,10890007,10890008,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890161,10890162,10890165,10885165,10890166,10890167,10890169,10890170,10890171,10890173,10890174,10890175,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10627321,10153863,10888339,10883358,10883359,10888362,10883378,10888381,10888382,10883396,10883397,10883402,10883412,10883414,10883421,10883429,10886057,10886058,10886059,10886060,10886061,10886062,10886063,10886064,10886065,10162091,10162201,10162241,10162242,10162243,10162244,10162245,10162246,10162247,10162249,10626143,10626144,10876655,10626145,10187807,10626299,10626300,10626301,10167992,10877124,10887132,10887199,10887200,10887201,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887230,10887231,10887232,10882353,10882354,10882359,10643469,10643470,10643545,10643546,10643547,10643548,10643551,10644403,10644404,10590996,10521871,10521872,10521873,10544310,10498250,10498251,10498252,10498867,10496911,10496934,10496935,10496936,10496937,10496938,10496939,10496940,10496941,10496942,10496943,10496944,10496945,10496946,10496947,10496980,10496981,10496982,10496983,10496984,10496985,10496986,10496987,10496988,10496989,10496990,10496991,10496992,10496993,10478003,10478004,10478005,10478006,10478007,10478008,10478009,10478010,10478011,10478012,10478013,10478014,10478015,10478016,10478017,10478018,10478019,10478020,10478021,10478022,10478023,10478024,10478025,10478026,10478027,10478028,10478029,10478030,10478031,10478032,10497032,10497033,10478033,10497034,10497035,10497036,10497037,10497038,10497039,10497040,10497041,10497042,10497043,10497044,10497045,10497046,10497064) 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'