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(8836219,8836224,8836228,8836231,8836244,8836248,8836253,7076308,7076323,7076328,7076330,7076331,7076332,7076334,7076335,7076337,7066821,10234491,10195885,10234895,10196292,10196293,7070824,10285067,10285068,7070855,7070857,10285181,10285182,10285183,10285184,10285259,10285260,10285261,10285280,10285281,10285282,10285285,10285286,10285287,10943366,10943380,10943399,10231067,10231068,10231087,10231143,10231243,10231254,10231255,10231256,10231257,10231258,10231259,10231260,10231261,10231262,10231263,10231264,10231265,10231266,10231267,10231275,10231276,10231313,10231335,10231336,10231337,10231338,10231339,10231364,10231365,10231366,10231367,10231368,10231369,10231370,10231371,10231372,10231373,10231374,10231375,10231376,10231377,10231378,10231381,10231420,10231421,10941710,10941804,10941807,10941818,10941843,10941850,10941851,10941852,10941853,10941896,10941901,10941904,10941906,10941910,10941943,10941944,10941947,10941989,10941994,10941996,10941999,10942001,10942007,10942009,10942010,10942013,10942014,10942015,10942017,10942019,10942024,7070780,7070792,7070795,7070822,10928558,10928575,10928580,10928588,10928589,10928599,10928615,10229197,10928673,10928677,10229262,10229263,10229264,10229265,10229266,10229268,10229269,10229270,10229271,10229272,10229273,10229274,10229275,10229276,10229277,10229278,10229279,10229280,10229281,10229282,10229318,10229322,10229323,10229453,10229454,10229455,10229456,10229458,10229459,10229460,10229490,10229491,10229493,10229495,10229666,10229667,10229752,10229753,10229754,10229755,10229756,10229757,10229758,10229785,10229844,10229845,10229846,10229854,10229855,10229875,10229876,10229877,10229878,10229879,10229884,10229885,10229886,10229887,10229898,10229899,10229902,10229903,10229904,10229905,10229906,10229907,10229908,10229909,10229910,10229922,10229923,10229924,10230016,10230023,10230024,10230025,10230026,10230027,10230028,10230029,10230032,10230033,10230034,10230035,10230036,10230041,10230042,10230043,10230044,10230059,10230064,10230065,10230066,10230067,10230116,10230117,10230210,10230335,10230336,10230390,10230442,10230443,10230444,10230445,10230446,10230447,10230448,10230449,10230450,10230451,10230458,10230487,10230488,10230489,10230490,10230491,10230492,10230493,10230494,10230559,10230565,10230566,10230567,10230568,10230569,10230609,10230634,10230642,10230645,10230646,10230647,10230653,10230654,10230655,10230656,10230657,10230658,10230703,10230704,10230738,10230739,10230740,10230741,10230742,10230743,10230744,10230745,10230746,10230747,10230748,10230814,10230815,10230831,10230832,10230833,10230834,10230835,10230836,10230837,10230838,10230839,10230840,10230841,10230842,10230843,10230873,10230881,10230947,10230948,10230964,10230990,10230991,10230992,10230993,10230994,10230995,10231001,10231004,10231014,10231015,10231022,10231023,10231024,10231025,10231026,10231027,10231028,10231029,10231036,10231037,10231042,10231043,10231054,10231055,10231056,10231057,10231058,10200519,10201221,10201225,10201226,10565186,7059728,9165725,9189744,9166007,7057490,9195971,9188217,9188221,9188479,9188487,9188493,9188513,9188531,9188532,9188533,9188568,9189018,10613737,9197138,9189239,9189252,9185536,10513400,9185634,9185635,9185646,9185654,9185681,9185682,9185687,9185688,9185697,9185698,9185699,9185712,9185768,9185770,9185792,9185794,10513627,9185955,9185956,9185979,9185988,9185989,9185992,9186000,9186001,9186002,9186004,9186005,9186009,10513823,10513824,9186024,9186025,9186043,9186061,9186072,9186080,9186092,9186097,9186103,9186104,9186105,9186106,9186108,9186112,9186114,9186154,9186156,9186179,9186186,9186191,9186200,9186242,9186243,9186244,9186245,9186246,9186324,9186325,9186369,9186383,9186384,9186385,9186406,9186409,9186410,9186411,9186412,9186413,9186430,9186449,9186456,9186457,9186458,9186459,9186509,9186519,9186522,9186523,9186529,9186567,9186568,9186569,9186570,9186632,9186638,9186639,9186659,9186660,9186671,9186689,9186690,9186691,9186693,9186694,9186695,9186698,9186699,9186700,9186705,9186710,9186731,9186741,9186748,9186822,9186823,9186836,9186837,9186838,9186839,9186840,9186843,9186845,9186846,9186847,9186848,9186862,9186863,9186872,9186875,9186888,7057468,9160358,9176389,9176390,9169172,9190649,9174750,9175010,9175011,9175012,6667150,6667153,9175449,8917292,9184260,10627663,10172101,10172104,10586578,10584181,10584182,10584183,10584228,10584237,10579475,10521184,10531230,10531231,10531232,10531233,10531234,10531235,10531236,10531237,10531238,10531239,10531240,10531241,10531242,10531243,10531244,10531245,10531246,10531247,10531248,10531249,10531250,10531251,10531252,10531253,10531254,10531255,10531256,10531257,10531258,10531259,10531260,10531261,10531262,10531263,10531264,10531265,10531266,10531267,10531268,10531269,10531270,10521282,10521283,10521284,10531512,10531513,10531539,10531540,10531658,10531659,10531755,10531792,10531806,10531807,10531808,10531809,10531810,10531811,10531812,10531813,10531814,10531823,10531836,10531837,10531838,10531839,10531840,10531843,10531844,10531845,10521875,10529878,10529879,10527881,10529901,10529902,10531907,10531908,10529909,10531909,10529910,10531910,10529911,10531911,10529912,10531912,10529913,10529914,10529923,10529924,10529925,10529926,10529927,10529928,10529929,10531934,10531935,10531936,10531937,10531938,10531939,10531940,10531941,10531942,10529948,10529949,10529950,10529951,10529952,10529953,10529959,10529985,10530038,10530039,10530040,10530041,10530042,10530043,10530044,10530045,10530046,10532054,10532055,10532056,10530065,10532081,10532082,10530082,10530083,10530084,10530085,10530086,10530089,10532115,10532116,10532118,10532119,10532120,10530120,10530121,10532122,10532123,10532124,10532125,10532126,10532127,10532128,10532129,10532132,10532133,10532134,10532135,10530135,10530136,10530153,10530155,10530156,10530164,10532167,10532171,10532172,10532173,10532174,10532175,10530176,10530177,10530178,10530179,10530180,10532181,10530181,10532182,10532183,10532184,10532185,10530195,10530196,10530197,10530198,10530199,10530201,10530202,10530245,10530246,10530247,10530248,10530249,10530250,10530251,10530252,10530253,10530254,10530255,10530256,10530257,10530258,10530259,10530260,10530261,10530262,10530263,10530264,10530265,10530266,10530267,10530269,10530270,10530279,10532280,10532281,10532282,10532283,10532284,10532285,10532286,10532287,10532288,10532289,10532290,10532291,10528306,10528307,10530310,10530311,10530312,10530313,10530314,10530315,10530316,10530317,10530394,10530402,10530403,10530404,10532413,10532414,10532415,10532416,10530456,10530457,10530458,10530459,10530460,10530461,10530462,10530463,10530464,10532479,10532480,10532481,10532482,10532483,10532484,10532485,10532486,10532487,10532488,10532489,10532490,10532491,10532492,10532493,10532494,10532495,10532496,10532497,10532498,10532499,10532500,10532501,10522512,10530524,10530525,10530526,10530527,10530548,10530549,10530550,10530551,10530552,10532559,10532565,10532566,10532567,10532568,10532569,10532570,10532571,10530585,10530586,10532605,10532606,10532607,10530607,10532608,10530608,10532609,10530609,10532610,10532611,10532612,10532613,10530613,10532614,10530614,10532615,10530615,10532616,10530616,10532617,10530617,10532618,10530618,10532619,10530619,10532620,10530620,10532621,10532622,10532623,10532624,10532625,10532626,10532628,10532629,10532630,10530633,10530634,10530635,10530636,10530637,10530638,10530639,10530640,10530641,10530642,10530643,10530657,10522670,10522671,10522672,10522674,10522675,10522676,10522677,10522678,10522679,10522680,10532690,10532691,10532692,10532693,10532694,10530709,10532713,10532714,10532715,10532716,10530718,10530719,10530720,10530721,10530722,10530723,10532729,10530744,10530749,10530754,10530783,10530784,10532791,10530791,10530792,10530793,10530799,10530800,10530801,10532813,10532814,10532815,10532840,10520852,10530865,10530866,10530867,10530875,10530876,10530877,10530878,10530879,10530880,10530881,10530882,10532897,10532898,10532904,10532905,10530905,10530906,10530907,10530908,10530909,10530910,10530922,10530923,10530924,10530925,10530926,10530927,10530928,10530929,10530930,10530931,10532954,10530964,10532966,10530981,10532990,10530990,10532991,10531001,10531002,10531003,10531004,10531010,10531011,10531012,10533014,10533015,10531015,10533016,10533017,10533018,10533019,10533020,10533021,10533022,10533023,10533024,10533025,10533026,10533027,10533028,10533029,10533030,10533031,10533032,10533033,10533034,10533035,10533036,10533037,10533038,10533039,10533040,10533041,10533042,10533043,10533044,10533045,10531047,10533058,10533059,10533060,10533061,10533062,10533063,10533064,10533065,10533066,10533067,10533068,10533069,10533070,10533071,10533073,10533074,10533075,10533076,10533077,10533078,10533079,10533080,10533082,10533093,10533095,10533096,10533111,10421971,10421972,10422003,10422034,10422049,10422096,10422115) 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'