SELECT p.*, CAST(pm1.meta_value AS DATETIME) as first_date 
        FROM wp_posts AS p
		INNER JOIN wp_postmeta AS pm on (p.ID = pm.post_id AND pm.meta_key = 'rodlaver_banner_desk') 
		LEFT JOIN wp_postmeta AS pm1 on (p.ID = pm1.post_id AND pm1.meta_key = 'first_date') 
		p.ID IN
			SELECT pm2.post_id FROM wp_postmeta pm2 WHERE pm2.meta_key = 'last_date'
			AND CAST(pm2.meta_value AS DATETIME) > '2014-09-22 22:06:44'
        AND p.post_status = 'publish' 
		AND p.post_type = 'mopt_event'
		ORDER BY first_date ASC
		LIMIT 0, 4
miley596x340v2 MariahWeb03 Guy Sebastian SiteBanner


Jun 10 2014

Laura Pausini show postponed

Please note that this event, which was originally scheduled for this Friday 12th June, has been postponed until Friday 13 February 2015. There is also a change of venue for the event. Laura Pausini will now be at Margaret Court Arena rather than Rod Laver Arena. Patrons that have already purchased into this event will […]


Jun 10 2014

New roof on Margaret Court Arena will ‘weatherproof’ the Australian Open

The addition of Margaret Court Arena (MCA) as a third retractable-roof stadium at Melbourne Park will officially “weatherproof” the Australian Open, according to Tennis Australia CEO Craig Tiley. “Plans for Australian Open 2015 are well underway and we look forward to unveiling the new MCA, which promises to be one of the finest tennis stadiums […]


SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) WHERE 1=1  AND wp_posts.post_type = 'mopt_event' AND ((wp_posts.post_status = 'publish')) AND (wp_postmeta.meta_key = 'first_date'
AND  (mt1.meta_key = 'rodlaver' AND CAST(mt1.meta_value AS CHAR) = 'yes')
AND  (mt2.meta_key = 'last_date' AND CAST(mt2.meta_value AS DATETIME) > '2014-09-22 22:06:44') ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value ASC LIMIT 0, 6


1 2 3 4
Sep 25 2014

The Grand Final Footy Show

Once again The Footy Show returns to Rod Laver Arena for the Grand Final edition.

Oct 09 2014

Thomas 'Mukanya' Mapfumo & The Blacks Unlimited

The 'Lion of Zimbabwe' will perform a fusion of traditional Shona music at Melbourne Park Function Centre live this October.

Oct 10 2014

Miley Cyrus

World renowned entertainer with record breaking success in film, television and music.

Nov 05 2014

The Rolling Stones

Promoter Frontier Touring’s Michael Gudinski; 'this tour will be talked about for decades to come'.

Nov 07 2014

Mariah Carey

The best-selling female artist of all time, MARIAH CAREY, brings “The Elusive Chanteuse Show” world tour to Rod Laver Arena this November.

Nov 14 2014

Hilltop Hoods

Hilltop Hoods have announced their largest domestic tour to date – the Cosby Sweater Tour.

1 2 3 4