New DB<BR>SELECT top 40 * from ps_top_of_the_props WHERE [month]=DatePart(month, dateadd(month,-1, getdate())) AND [year]=DatePart(year, dateadd(year, 0, getdate()))  order by rank
				<!-- Richard Start here -->
				<TABLE cellSpacing=0 cellPadding=3 rules=none  align=center border=1>
				<tr><td valign='top' colspan="5" align="center">
				<p><strong>Overall Enquiry Volume for April 2012</strong></p></td>
				</tr>
				<tr><td>&nbsp;</td></tr>
					<tr> 
						<td width=52> <p><b>Rank</b></p></td>
						<td width=153> <p><b>Country</b></p></td>
						<td width=67> <p><b>Share</b></p></td>
						<td width=92> <p><b>Change</b></p></td>
						<td width=144> <p><b>Comment</b></p></td>
					</tr>
					
					<tr>
							  <td ><p>1</p></td>
							  <td ><p><a href="/property/Spain/">Spain</a></p></td>
							  <td ><p>17.44</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p>1 month in top spot</p></td>
					</tr>
					
					<tr>
							  <td ><p>1</p></td>
							  <td ><p><a href="/property/Spain/">Spain</a></p></td>
							  <td ><p>17.44</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p>1 month in top spot</p></td>
					</tr>
					
					<tr>
							  <td ><p>1</p></td>
							  <td ><p><a href="/property/Spain/">Spain</a></p></td>
							  <td ><p>17.44</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p>1 month in top spot</p></td>
					</tr>
					
					<tr>
							  <td ><p>1</p></td>
							  <td ><p><a href="/property/Spain/">Spain</a></p></td>
							  <td ><p>17.44</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p>1 month in top spot</p></td>
					</tr>
					
					<tr>
							  <td ><p>2</p></td>
							  <td ><p><a href="/property/USA/">USA</a></p></td>
							  <td ><p>10.16</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>2</p></td>
							  <td ><p><a href="/property/USA/">USA</a></p></td>
							  <td ><p>10.16</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>2</p></td>
							  <td ><p><a href="/property/USA/">USA</a></p></td>
							  <td ><p>10.16</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>2</p></td>
							  <td ><p><a href="/property/USA/">USA</a></p></td>
							  <td ><p>10.16</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>3</p></td>
							  <td ><p><a href="/property/France/">France</a></p></td>
							  <td ><p>9.43</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>3</p></td>
							  <td ><p><a href="/property/France/">France</a></p></td>
							  <td ><p>9.43</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>3</p></td>
							  <td ><p><a href="/property/France/">France</a></p></td>
							  <td ><p>9.43</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>3</p></td>
							  <td ><p><a href="/property/France/">France</a></p></td>
							  <td ><p>9.43</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>4</p></td>
							  <td ><p><a href="/property/Brazil/">Brazil</a></p></td>
							  <td ><p>7.51</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>4</p></td>
							  <td ><p><a href="/property/Brazil/">Brazil</a></p></td>
							  <td ><p>7.51</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>4</p></td>
							  <td ><p><a href="/property/Brazil/">Brazil</a></p></td>
							  <td ><p>7.51</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>4</p></td>
							  <td ><p><a href="/property/Brazil/">Brazil</a></p></td>
							  <td ><p>7.51</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>5</p></td>
							  <td ><p><a href="/property/Portugal/">Portugal</a></p></td>
							  <td ><p>5.16</p></td>
							  <td ><p>Down 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>5</p></td>
							  <td ><p><a href="/property/Portugal/">Portugal</a></p></td>
							  <td ><p>5.16</p></td>
							  <td ><p>Down 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>5</p></td>
							  <td ><p><a href="/property/Portugal/">Portugal</a></p></td>
							  <td ><p>5.16</p></td>
							  <td ><p>Down 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>5</p></td>
							  <td ><p><a href="/property/Portugal/">Portugal</a></p></td>
							  <td ><p>5.16</p></td>
							  <td ><p>Down 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>6</p></td>
							  <td ><p><a href="/property/Italy/">Italy</a></p></td>
							  <td ><p>3.68</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>6</p></td>
							  <td ><p><a href="/property/Italy/">Italy</a></p></td>
							  <td ><p>3.68</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>6</p></td>
							  <td ><p><a href="/property/Italy/">Italy</a></p></td>
							  <td ><p>3.68</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>6</p></td>
							  <td ><p><a href="/property/Italy/">Italy</a></p></td>
							  <td ><p>3.68</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>7</p></td>
							  <td ><p><a href="/property/Turkey/">Turkey</a></p></td>
							  <td ><p>2.63</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>7</p></td>
							  <td ><p><a href="/property/Turkey/">Turkey</a></p></td>
							  <td ><p>2.63</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>7</p></td>
							  <td ><p><a href="/property/Turkey/">Turkey</a></p></td>
							  <td ><p>2.63</p></td>
							  <td ><p>Down 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>7</p></td>
							  <td ><p><a href="/property/Turkey/">Turkey</a></p></td>
							  <td ><p>2.63</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>8</p></td>
							  <td ><p><a href="/property/Malta/">Malta</a></p></td>
							  <td ><p>2.59</p></td>
							  <td ><p>Up 4</p></td>
							  <td ><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td ><p>8</p></td>
							  <td ><p><a href="/property/Malta/">Malta</a></p></td>
							  <td ><p>2.59</p></td>
							  <td ><p>Up 4</p></td>
							  <td ><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td ><p>8</p></td>
							  <td ><p><a href="/property/Malta/">Malta</a></p></td>
							  <td ><p>2.59</p></td>
							  <td ><p>Up 3</p></td>
							  <td ><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td ><p>8</p></td>
							  <td ><p><a href="/property/Malta/">Malta</a></p></td>
							  <td ><p>2.59</p></td>
							  <td ><p>Up 4</p></td>
							  <td ><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td ><p>9</p></td>
							  <td ><p><a href="/property/Germany/">Germany</a></p></td>
							  <td ><p>2.46</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>9</p></td>
							  <td ><p><a href="/property/Germany/">Germany</a></p></td>
							  <td ><p>2.46</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>9</p></td>
							  <td ><p><a href="/property/Germany/">Germany</a></p></td>
							  <td ><p>2.46</p></td>
							  <td ><p>Non-mover</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td ><p>9</p></td>
							  <td ><p><a href="/property/Germany/">Germany</a></p></td>
							  <td ><p>2.46</p></td>
							  <td ><p>Up 1</p></td>
							  <td ><p></p></td>
					</tr>
					
					<tr>
							  <td  style="BORDER-BOTTOM: thin solid"><p>10</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p><a href="/property/Cape_Verde/">Cape Verde</a></p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>2.35</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>Up 3</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td  style="BORDER-BOTTOM: thin solid"><p>10</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p><a href="/property/Cape_Verde/">Cape Verde</a></p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>2.35</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>Up 3</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>New to top 10!</p></td>
					</tr>
					
					<tr>
							  <td  style="BORDER-BOTTOM: thin solid"><p>10</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p><a href="/property/Cape_Verde/">Cape Verde</a></p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>2.35</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>Up 2</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p></p></td>
					</tr>
					
					<tr>
							  <td  style="BORDER-BOTTOM: thin solid"><p>10</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p><a href="/property/Cape_Verde/">Cape Verde</a></p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>2.35</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>Up 3</p></td>
							  <td  style="BORDER-BOTTOM: thin solid"><p>New to top 10!</p></td>
					</tr>
							   
					</table>
					<!-- Richard end here -->
	            </td>
              </tr>
            </table>