Live Streaming of Court Proceedings
# PRO 3.238.116.201 SELECT a.fil_no, DATE_FORMAT(a.orderdate, '%d-%m-%Y'), a.pdfname, a.type, (SELECT CONCAT( c.skey, ' ', SUBSTRING(a.fil_no, 6, 5), '/', SUBSTRING(a.fil_no, 11, 4) ) FROM casetype c WHERE c.casecode = SUBSTRING(a.fil_no, 4, 2)) AS caseno, a.subject , m.`pet_name`,m.`res_name`,a.branch FROM ordernet a LEFT JOIN main m ON m.`fil_no`=a.`fil_no` WHERE a.orderdate<=NOW() AND ((TYPE = 'J' OR TYPE = 'FO' )) AND a.ent_dt!='0000-00-00 00:00:00' ORDER BY a.orderdate DESC LIMIT 20
Responsive Video Grid