{if logged_in}

<title>Hotels Comparison Report</title>
<h1>PL vs HC Comparison of Properties</h1>


<h2>HOTEL PROPERTIES ONLY</h2>

	{exp:query sql="SELECT DISTINCT(pl.hotel_name), pl.city, pl.state, pl.hotelid_ppn as hotelid_pl, hc.HotelID as hotelid_hc, hc.HotelFileName as hotelurl_hc  FROM aff_pl_hotels pl JOIN aff_hc_hotels hc on pl.hotel_address = hc.HotelAddress WHERE pl.hotel_type='hotel' ORDER BY pl.city ASC LIMIT 1000 "}
		
		{if count==1}
			<p>**{total_results} Matching Hotels by Address**</p>
			
			<hr />
		
			<table width="100%" border="1" cellpadding="0" cellspacing="0">
				<tr style="font-weight:bold;font-size:120%;">
					<td width="30%">Hotel Name</td>
					<td width="30%" style="text-align:center;">Priceline ID</td>
					<td width="30%" style="text-align:center;">HotelsCombined ID</td>
				</tr>
		{/if}
				<tr>
					<td width="30%">{hotel_name}</td>
					<td width="30%" style="text-align:center;"><a href="http://book.guideofus.com/hotels/hotel/?refid=8187&hotel_id={hotelid_pl}" target="_blank">{hotelid_pl}</a></td>
					<td width="30%" style="text-align:center;">{if hotelurl_hc}<a href="http://hc.hawaii-guide.com/Hotel/{hotelurl_hc}.htm" target="_blank">{hotelid_hc}</a>{if:else}{hotelid_hc}{/if}</td>
				</tr>					



		
		{if count==total_results}
			</table>
			
			<hr />
			
			<p>**{total_results}**</p>
			
		{/if}
	
	{/exp:query}


<hr />
<hr />

<h2>ALL PROPERTIES</h2>

	{exp:query sql="SELECT DISTINCT(pl.hotel_name), pl.city, pl.state, pl.hotelid_ppn as hotelid_pl, hc.HotelID as hotelid_hc, hc.HotelFileName as hotelurl_hc FROM aff_pl_hotels pl JOIN aff_hc_hotels hc ON pl.hotel_address = hc.HotelAddress WHERE pl.hotel_type!='hotelz' ORDER BY pl.city ASC LIMIT 1000 "}
		
		{if count==1}
			<p>**{total_results} Matching Properties by Address**</p>
			
			<hr />
		
			<table width="100%" border="1" cellpadding="0" cellspacing="0">
				<tr style="font-weight:bold;font-size:120%;">
					<td width="30%">Property Name</td>
					<td width="30%" style="text-align:center;">Priceline ID</td>
					<td width="30%" style="text-align:center;">HotelsCombined ID</td>
				</tr>
		{/if}
				<tr>
					<td width="30%">{hotel_name}</td>
					<td width="30%" style="text-align:center;"><a href="http://book.guideofus.com/hotels/hotel/?refid=8187&hotel_id={hotelid_pl}" target="_blank">{hotelid_pl}</a></td>
					<td width="30%" style="text-align:center;">{if hotelurl_hc}<a href="http://hc.hawaii-guide.com/Hotel/{hotelurl_hc}.htm" target="_blank">{hotelid_hc}</a>{if:else}{hotelid_hc}{/if}</td>
				</tr>					



		
		{if count==total_results}
			</table>
			
			<hr />
			
			<p>**{total_results}**</p>
			
		{/if}
	
	{/exp:query}

<hr />
<hr />


{if:else}

<h2>Notice:</h2>
<p>Please make sure you login to the CMS before attempting to view this page...</p>

{/if}