SELECT w.`code`,w.title,w.group_title,w.skip_group,c.buy,c.sell,c.diff_buy,c.diff_sell,u.tstamp FROM `widget_goldprice` w left join comm_prices_daily c on w.code=c.comm_code and w.area=c.area_id and w.widget='simple' and w.enabled_giavang=1 join (SELECT bank_id vendor_id, MAX(`date`) `date`,max(tstamp) tstamp FROM updates u WHERE type_id=2 GROUP BY bank_id) u on c.vendor_id=u.vendor_id and c.`date`=u.`date` order by w.no asc

SELECT content json_txt FROM widget_content where `name`='kitco-live-gold-price' and `format`='json'

SELECT content FROM widget_content where `name`='kitco-historial-gold-price' and `format`='html'

SELECT `date`,fcode,buy,ROUND(diff_buy) diff_buy,sell,ROUND(diff_sell) diff_sell,tstamp FROM exrates2 where fcode='USD-TD' order by id desc limit 1

SELECT content json_txt,tstamp FROM widget_content where `name`='kitco-live-market-indices'

select id,update_no,date,tstamp from updates where bank_id=1 and type_id=1 order by id desc limit 1

SELECT x.id,x.fcode,f.alias,f.name,x.buy,x.buy_wired,x.sell,x.sell_wired,ROUND(x.diff_buy) diff_buy,ROUND(x.diff_buy_wired) diff_buy_wired,ROUND(x.diff_sell) diff_sell,ROUND(x.diff_sell_wired) diff_sell_wired from exrates x join fcodes f on x.fcode=f.code and f.display_order<2 where x.update_id=11548 order by f.display_order, f.id

SELECT `type`,MAX(NULLIF(term_1,0)) max_term_1,MAX(NULLIF(term_3,0)) max_term_3,MAX(NULLIF(term_6,0)) max_term_6,MAX(NULLIF(term_9,0)) max_term_9,MAX(NULLIF(term_12,0)) max_term_12,MIN(NULLIF(term_1,0)) min_term_1,MIN(NULLIF(term_3,0)) min_term_3,MIN(NULLIF(term_6,0)) min_term_6,MIN(NULLIF(term_9,0)) min_term_9,MIN(NULLIF(term_12,0)) min_term_12 from `saving_interest_rates` group by `type`