Room Category		Garden Rooms				Superior Rooms				Junior Suites				Sultan Suites
		PPS	SGL	3rd		PPS	SGL	3rd		PPS	SGL	3rd		PPS	SGL	3rd
Oct 01, 2012 - Dec 21, 2012		145	203	113		175	238	136		225	265	168		385	425	328
Dec 22, 2012 - Jan 05, 2013		269	319	206		291	341	250		356	406	296		516	566	456
Jan 06, 2013 - Mar 31, 2013		156	206	126		188	238	151		238	288	191		398	448	351
Apr 01, 2013 - Jun 30, 2013		91	91	70		110	110	89		145	145	113		305	305	273
Jul 01, 2013 - Jul 22, 2013		143	193	110		174	224	139		224	274	179		384	434	339
Jul 23, 2013 - Aug 28, 2013		195	245	156		229	279	185		285	335	235		445	495	395
Aug 29, 2013 - Oct 31, 2013		164	214	129		198	248	154		254	304	204		414	464	364
Nov 01, 2013 - Dec 21, 2013		149	199	121		179	229	140		229	279	191		389	439	351

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND end_date>= ORDER BY start_date ASC' at line 1