WP_Cal_Demo # 2

gistfile1.php

<?php

// Get days with posts
  $dayswithposts = $wpdb->get_results("SELECT (FROM_UNIXTIME(`wp_postmeta`.`meta_value`,'%d')) as dom , 
    `wp_postmeta`.`post_id` , `wp_posts`.`guid` , `wp_posts`.`post_title` 
		FROM $wpdb->postmeta 
		LEFT JOIN  `wp_posts` ON  `wp_postmeta`.`post_id` =  `wp_posts`.`ID` 
		WHERE  `wp_postmeta`.`meta_key` =  'event_startdate'
		AND  `wp_posts`.`post_status` =  'publish'
		AND  `wp_postmeta`.`meta_value` >= UNIX_TIMESTAMP(  '{$thisyear}-{$thismonth}-01 00:00:00' ) 
		AND  `wp_postmeta`.`meta_value` <= UNIX_TIMESTAMP(  '{$thisyear}-{$thismonth}-{$last_day} 23:59:59' )", OBJECT);