IB Trip to Thailand

SELECT broker FROM promo_bonus, data_broker WHERE judul_edit != '' and promo_bonus.broker_id = data_broker.id_data_broker and promo_bonus.jenis = 'broker-promotion-update' AND promo_bonus.end_date > '2024-05-04' AND data_broker.broker != 'Lirunex' and pakai ='yes' GROUP BY broker order by field (data_broker.broker, 'Exness', 'FBS', 'IC Markets', 'Octa', 'RoboForex', 'XM', 'HF Markets', 'Pepperstone', 'Admirals', 'AvaTrade', 'ThinkMarkets', 'LiteFinance', 'eToro', 'FXOpen', 'InstaForex', 'FP Markets', 'FXTM', 'Markets4you', 'FirewoodFX', 'Vantage Markets', 'FIBOGroup', 'BDSwiss', 'JustMarkets', 'Tickmill', 'FxPro', 'MTrading', 'Grand Capital', 'Blueberry Markets', 'Blaze Markets', 'easyMarkets', 'OANDA', 'Fxview', 'GOMarkets', 'Interactive Brokers', 'FXGT', 'Dukascopy', 'DeltaStock', 'Axi', 'Orbex', 'ADSS', 'TMGM', 'IG', 'XTB', 'FXCM', 'Windsor Brokers', 'AAAFx', 'Alpari', 'IronFX', 'ROinvesting', 'VARIANSE', 'BlackBull Markets', 'Fusion Markets', 'CFI Group', 'Anzo Capital', 'IFC Markets', 'Markets.com', 'Weltrade', 'HYCM', 'Key to Markets', 'Hantec Markets', 'NAGA', 'Swissquote', 'AAATrade', 'Swiss Markets', 'Eurotrader', 'JFD Bank', 'Land-FX', 'Advanced Markets', 'Capital.com', 'MultiBank', 'Forex.com', 'Absolute Markets', 'USGFX', 'Lirunex', 'VPFX', 'Trade360', 'Valutrades', 'Turnkey Forex', 'FXPRIMUS', 'AdroFx', 'Colmex Pro', 'ActivTrades', 'Blackwell Global', 'M4Markets', 'Axiance', 'Traders Trust', 'Plus500', 'Ingot Brokers', 'Libertex', 'Forex Optimum', 'FxNet', 'Eightcap', 'Equiti', 'Royal', 'AccentForex', 'ForexChief', 'XGLOBAL Markets', 'FX Giants', 'UFX', 'AAFX Trading', 'FxGrow', 'LegacyFx', 'JFD Brokers', 'Baxia Markets', 'Global Market Index', 'FXGM', 'Yadix', 'LMAX Global', 'Axiory', 'VT Markets', 'Skilling', 'Darwinex', 'One Financial Markets', 'OneTrade', 'Tifia', 'FXGlory', 'CMS Prime', 'One Global Market', 'ACY Securities', 'ForexVox', 'Capital Street FX', 'Trading 212', 'EverFX', 'AGEA', 'CLMarkets', 'Trade Nation', 'Fondex', 'AMarkets', 'FPG', 'Milton Markets', 'Axes', 'Dizicx', 'Global Prime', 'TriumphFX', 'Just2Trade', 'INFINOX', 'Equiti Global Markets', 'Fort Financial Services', 'FXPIG', 'ATFX', 'NSFX', 'SquaredFinancial', 'Xtrade', 'TradeCMX', 'Juno Markets', 'Synergy Markets', 'Price Markets', 'NordFX', 'FreshForex', 'ATC Brokers', 'LMFX', 'Fullerton Markets', 'Alvexo', 'Bulbrokers', 'FX Choice', 'AETOS', 'Invast Financial Services', 'PhillipCapital', 'GBE brokers', 'Crystal Ball Markets', 'LonghornFX', 'TrioMarkets', 'Fortrade', 'NatureForex', 'Olymp Trade', 'Milton Prime', 'Hirose Financial UK', 'CapitalCore', 'TenkoFX', 'PaxForex', 'Binary.com', 'Big Boss', 'Forex24', 'CMC Markets', 'TradeATF', 'Capital Index', 'Rockfort Markets', 'TFI Markets', 'GAINSY', 'Tradeo', 'TIOmarkets', 'Abshire-Smith', 'ForexTB', 'AMP Global', 'City Index', 'Circle Markets', 'Esperio', 'streamsfx', 'Hankotrade', 'Titan FX', 'SuperForex', 'XBTFX', 'XtreamForex', 'FXCL', 'IQ Option', 'TradeView Forex', 'Financial Spreads', 'CPT Markets', 'Forex.ee', 'Investous', 'ForexMart', 'LCG', 'DF Markets', 'ICM Capital', 'FCI Markets', 'CFDTimes', 'Profiforex', 'JCMFX', 'FXB Trading', 'ETO Markets', 'TegasFX', 'TurboForex', 'Saxo Bank', 'TradeFW', 'Solid ECN', 'GKFX', 'NPBFX', 'TOP1Markets', 'AZAforex', 'PFD', 'WesternFX', 'BMFN', 'AMEGA', 'eXcentral', 'Vinson Financials', 'CedarFX', 'Core Spreads', 'GANNMarkets', 'FXLinked', 'Sage FX', 'Number One Capital Markets', 'CIBFX', 'FX Sign', 'EuropeFX', 'FXFlat', 'XB Prime', 'Velocity Trade', 'Trading.com', 'FXOptimax', 'Investizo', 'Euro Pacific Bank', 'Coinexx', 'World Forex', 'Trade12', 'Streams', 'Finq', 'Trust Capital', 'Scandinavian Capital Markets', 'CryptoAltum', 'LQDFX', 'Purple Trading', 'FinPros', 'UBFX', 'Alfa Capital Markets', 'PU Prime', 'CM Trading', 'JAFX', 'OffersFX', 'EagleFX', 'iFOREX', 'EBH Forex', 'BelleoFX', 'Finotec', 'OpoFinance', 'CryptoRocket', 'Geratsu', 'FXDD', 'Wonderinterest', 'SimpleFX', '24option', 'TryMarkets', 'GCI', 'Trade Fintech', 'RockGlobal', 'HFTrading', 'Moneta Markets', 'Your FX Broker', 'FXPCM', 'Mitrade', 'Deriv', 'Headway', 'ITRADER', 'Gerchik & Co', 'Spread Co', 'Opoforex', 'Gulf Brokers', 'CryptoGT', 'Larson & Holz IT', 'CrescoFX', 'CMS Trader', 'CapitalBear', 'Trendex', 'Emd Forex', 'Ally Invest', 'LiquidityX', 'CapitalXP', 'ICM Brokers', 'FXGlobe', 'YCM-Invest', 'WSSolution', 'zForex', 'FinmaxFX', 'FX Trading Pro', 'Markets Invest', 'SmartFX', 'FXGate', 'RCPro', 'MaxiMarkets', 'Jetvix', 'PrimeXBT', 'ayondo', 'Evest', 'ForexCT', 'Evotrade', 'Renesource Capital', 'SFEX', 'Forexite', 'HFX Internasional Berjangka', 'Maxco', 'Invest100', 'Finex', 'Ubrokers', 'Finteria', 'Videforex', 'Evolve Markets', 'Markets Cube', 'Bolmax Management', 'TradeLTD', 'Strifor', 'Trade8', 'Trive', 'Questrade FX', 'Corner Trader', 'TMS Brokers', 'Golden Brokers', 'HMS Markets', 'Agrodana Futures', 'Pruton Capital', 'Monex Investindo Futures', 'FOREXimf', 'Trive Invest', 'Central Capital Futures', 'VAF', 'SIBFX', 'Arta Mas Futures', 'Mentari Online', 'JavaGM', 'Inter Pan', 'GAF' ) limit 20