Technicals

select * from (SELECT 'streettalk' news_cat, sc_scid scid, autono, heading, summary, '' impact, category, '' exp_img_path, '' target, '' recprice, '' stock, '' call_date, ent_date, datediff(now(), ent_date) diff, '' cat, '' expiry_date FROM analysis WHERE category='Insider - Rumour Mills' and publish='Y' and ent_date > '2026-04-03' union select 'powercalls_res' news_cat, sc_scid scid, autono, heading, '' summary, expert impact, flag category, '1' exp_img_path, target1 target, stoploss1 recprice, '' stock, '' call_date, ent_date, datediff(now(), ent_date) diff, category cat, scrip_name expiry_date from research_trading_calls where ent_date > '2026-04-03' and (category is NULL or category!='Commodity') union select 'powercalls' news_cat, sc_scid scid, autono, heading, '' summary, expert impact, flag category, '' exp_img_path, target1 target, stoploss1 recprice, '' stock, '' call_date, ent_date, datediff(now(), ent_date) diff, '' cat, '' expiry_date from trading_calls where ent_date > '2026-04-03') as result order by ent_date