SELECT m.id as match_id, m.status as match_status, m.team1_fullname as team1_fullname,m.team2_fullname as team2_fullname,m.matchdesc as matchdesc,m.series_id as series_id,m.startdate as startdate,m.enddate as enddate,m.team1_shortname as team1_shortname,m.team2_shortname as team2_shortname,m.starttimeist as starttimeist,m.starttimegmt as starttimegmt,m.match_type as match_type,m.venue_city as venue_city,m.result as result,s.slug as slug,s.cc_series_name as cc_series_name,s.series_name as series_name FROM matches m, series s WHERE m.record_status=1 AND m.status =4 AND m.series_id = s.id AND m.enddate < CURDATE( ) AND m.result != '' ORDER BY m.enddate DESC LIMIT 0, 5 Live Cricket Score - Live Score Update, Live Match Score, CricketCountry.com
http://staging.cricketcountry.com/live-scores/mukesh