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(10198055,10198230,7201772,7201841,7076159,10843523,7202074,8572128,4970768,7202223,7202224,7202227,3899554,3899556,3899559,10843832,10843833,10843837,10843846,3899593,3899594,3899596,8569557,8572589,10238135,7065953,7065954,7066112,8572886,7066374,3227328,3227393,10225746,10225759,10225760,8573275,8573323,8910598,7200792,7200793,10223404,10223415,7067195,3238547,7075637,10103385,10249990,7201557,10195098,10195116,7198680,8908503,10234277,10234373,10234451,10234452,10234453,10221587,8564676,10931915,7064502,10931954,7199319,10234810,3236588,4967030,10932150,10932162,10841115,10196164,10196165,10196166,7199719,7199776,10196392,10196468,10196527,7200468,7200469,8907480,7197780,7197827,7197831,7197832,7197833,7197834,7197835,7197836,7197837,3235027,8907739,8907749,8907750,10246528,8861366,10195000,10257086,8905440,8905444,8905457,8905573,8905586,8905587,8905594,8905595,8905596,8905598,8905706,8905711,8905715,10257403,8542247,8542248,8542249,10940933,8612681,10944866,7196139,7196173,10941307,8613019,8613020,7196482,7196483,7196484,7196485,10283953,10283954,10837997,10838003,7196501,7196502,10232045,8906518,8860002,7197033,8860184,7197092,8906938,10838655,8860362,3234460,3234472,8860435,3234623,7197487,10190225,10618267,10618300,10618301,10618317,10255445,8576940,10848555,10255538,10203560,10203561,10203562,10255562,10255584,10255625,10255668,10433538,10255706,10426464,10190817,10190821,8904313,8070777,8540987,10256260,10256303,10256399,8904852,8904859,10282529,10282530,10282531,10282532,10256597,10282597,10256626,10282721,10282851,8905221,8905232,10624796,10624797,10624798,10624800,10624810,10256956,8905358,8622297,8622298,10617120,10617141,10617341,10617342,8609594,10927958,10927959,10432411,10432413,10928066,10254679,10617763,8576345,8576349,10847927,10847928,10847929,10280887,10847930,10280888,10847931,10847932,10280889,10847933,10280891,10847934,10280892,10847935,10280893,10847936,10280894,10189894,10189895,10189897,10189898,10189899,10189901,10189903,10189905,10847959,10622825,10254950,10848004,10848005,3230737,10848086,10848087,10848088,10615137,8573789,10615237,10615289,10615353,10615354,10615435,10615442,10615545,8570487,10615691,10615692,10845838,10615704,10845839,8621017,8574398,8574489,10620999,10616002,10846291,10188374,10188375,8583370,8575097,8583428,3229408,3229446,10616655,10431610,3229477,8583540,3229501,3229508,8583635,10431749,8575399,8583727,3229695,10614013,10614036,10614084,6669905,6669906,6669911,6669912,6669913,6669914,10714186,6669915,6669917,6669918,10614417,10614444,10614446,9197812,10614588,10614707,9214146,9166213,10611991,10611992,10611993,9211414,9211415,9211416,9211417,9211418,9187510,9187511,9187512,10612263,10612313,9211787,9211788,9211789,9211790,10612972,8862852,10613056,10613057,10613058,10613059,10613060,10613061,10613062,10613066,10613075,10613076,10613078,9212436,9212437,10613139,10613140,10613217,10120905,8863363,10564691,10564722,9173028,9197029,10564879,10564924,10613784,10613826,6673518,6673538,6673539,6673541,6673542,6673543,6673544,6673547,6673549,10117618,10117693,6673723,6673731,6673732,9161534,10125748,7055724,10117761,6673772,9209589,9169592,9169606,9169607,10511470,10511493,9161692,10511570,10511571,10511572,6673992,6673993,6673994,6673995,6673996,6673997,6673998,6673999,6674000,6674001,6674002,6674003,6674004,6674005,6674006,6674007,6674008,6674009,6674010,6674011,6674012,6674013,6674014,6674015,6674016,6674017,6674018,6674019,6674020,6674021,6674022,6674023,6674024,6674025,6674026,6674027,6674028,6674029,6674030,6674031,6674032,6674033,6674034,6674035,6674036,6674037,6674038,6674039,6674040,6674041,6674042,6674043,6674044,6674045,6674046,6674047,6674048,6674049,6674050,6674051,6674052,6674053,6674054,6674055,6674056,6674057,6674058,6674059,6674060,6674061,6674062,6674063,6674064,6674065,6674066,6674067,6674068,6674069,6674070,6674071,10511678,6674072,6674073,6674074,6674075,6674076,6674077,6674078,6674079,6674080,6674081,6674082,10517691,9209938,9209953,10511768,6674177,9169987,10511807,10511808,10511809,10511810,10511811,10511812,10511813,10511814,10511815,10511816,10511817,10511818,10511819,10511820,10511821,10511822,10511823,10511824,10511825,10511826,10511827,10511828,10511829,10511830,10512041,10512050,10512051,10512052,8551736,9170451,9170458,9178496,2809149,6674797,6674798,6674801,6674805,10514502,10514503,10514504,9170694,9210932,10512755,9179136,7057430,9168307,9160316,9160317,9160321,9160333,6672580,10417330,10417379,10417387,10419435,10419454,10417466,10417467,10417468,10417469,10417470,10417471,10417472,6672763,6672764,6672765,6672766,6672767,6672768,6672769,6672770,6672771,6672772,6672773,6672774,6672775,6672776,6672777,6672778,6672779,6672791,6672792,10416549,9168630,7054874,9168732,9168733,9168748,9168848,9168853,10419794,10417969,10418027,9169118,9169144,9169156,10117383,9169220,7055456,10468938,10468952,10468961,9190389,10471132,10471174,10471248,10467255,8865257,10122937,10467385,10467396,10469441,10123081,10467524,10467564,10467609,8550254,10469705,10469706,4972006,10469783,10469784,10469785,6667232,6667238,9167326,9167347,10467951,9167376,9167377,10463981,9207413,10115665,9207468,10468162,10123901,10123902,10123903,10123937,9167787,9167813,9167814,10468556,10468562,10116203,6668115,6668119,10116335,10116336,9184185,9184186,9168217,10468822,10888502,10164525,10883564,10883572,10883573,10883574,10883575,10883576,10883577,10883578,10883579,10883580,10883581,10883582,10883583,10883584,10883585,10883586,10883587,10883588,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883598,10883599,10883600,10883601,10883602,10883603,10888606,10888655,10888656,10883670,10883733,10883744,10888790,10883823,10169933,10889022,10628580,10884322,8594354,10884474,10884528,10884542,10155629,10884704,10175753,10175777,10156014,10156019,10875073,10885093,10890137,10890138,10880206,10885338,10885339,10158598,10158599,10158618,10173622,10632305,10627314,10627315,10882890,10945805,10945855,10627538,10945860,10159076,10888071,10888074,10888075,10888078,10888082,10883086,10888088,10888092,10888093,10888095,10888100,10888104,10888105,10888106,10888107,10888110,10888111,10888114,10888115,10888124,10888127,10888130,10888132,10888133,10888135,10888136,10888137,10888138,10888139,10627730,10883282,10627782,10627783,10627787,10627807,10627808,10627809,10627810,10627811,10627812,10627813,10627814,10627815,10627816,10627817,10627818,10627819,10627820,10888339,10184369,10184370,10883398,10627928,10627929,10627930,10888453,10888454,10888455,10885515,10885525,10630039,10630040,10630041,10630042,10630100,10885613,10885628,10885632,10161714,10885730,10948571,10166798,10171803,10161931,10885968,10161987,10161988,10167010,10162023,10886015,10886024,10886193,10886255,10886288,10886339,10886358,10886387,10886489,10886505,10949384,10876583,10876584,10876585,10876586,10886651,10886740,10886797,10886813,10886814,10886887,10886898,10887004,10887026,10887030,10887040,10882061,10882094,10882095,10877102,10887202,10887203,10887204,10887205,10887206,10887207,10887208,10887209,10887210,10887211,10887212,10887213,10887214,10887215,10887216,10887217,10887218,10887219,10887220,10887221,10887222,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887230,10887231,10887232,10887233,10887234,10887235,10887236,10887237,10163254,10163257,10163265,10882294,10882307,10626807,10589479,10646756,10643774,10643776,10589799,10589800,10589804,10589805,10589806,10589807,10589808,10589809,10589810,10589811,10589812,10589813,10589814,10589815,10589816,10589817,10589818,10589819,10589820,10589821,10589822,10589823,10589824,10589825,10589826,10646886,10589827,10589882,10589883,10589884,10589885,10587136,10587137,10587138,10590608,10644759,10578719,10644819,10590853,10645058,10645217,10645562,10645563,10600594,10600595,10591842,10600989,10600990,10533124,10527946,10540004,10544298,10544299,10544300,10544301,10544302,10544303,10544304,10544305,10544306,10544307,10544308,10544309,10544310,10544311,10544312,10544313,10526321,10526431,10526432,10526433,10526434,10526435,10526436,10526437,10526438,10526439,10526440,10526441,10526442,10526443,10526444,10526445,10526446,10526447,10526448,10526449,10526450,10526451,10526452,10526453,10526454,10526455,10526456,10526457,10526458,10526459,10526460,10526461,10526462,10526463,10522499,10522500,10424441,10424446,10498414,10498415,10422188,10490093,10481189,10490203,10490216,10481254,10473255,10481255,10486339,10486340,10488381,10490787,10488814,10488825,10479889,10490914,10471930,10492939,10492949,10487099,10472168,10472172,10472185,10476247,10474301,10476475,10489476,10489485,10482505,10482513,10476614,10472719,10474736) 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'