South West of England Cottages with Hot Tubs

romantic: 
		pool: 
		wifi: 
		nearBeach: 
		allowsPets: 

region: England
county: Cornwall
sleeps: 
bedrooms: 

romantic: 

Local table: UKTravelFeeds.cottages

This is a countySearch

Main sql2: SELECT df.*, sup.shortDesc 
         FROM UKTravelFeeds.cottages df
         INNER JOIN miniSitesSupplemental.northcornwallcottageswithhottubs sup ON df.siteCode = sup.siteCode
         WHERE df.county = 'Cornwall' AND df.locationNew = "South West of England"

Pagination running in TEST MODE

baseURL: /

totalRows: 0

page: 1

numberOfPages: (totalRows / 15) = 0

Refine by counts

Counts SQL

SELECT SUM(wifi) AS wifiCount, SUM(nearPub) AS nearPubCount, SUM(fishing) AS fishingCount, SUM(pool) AS poolCount, SUM(golf) AS golfCount, SUM(allowsPets) AS allowsPetsCount, SUM(nearBeach) AS nearBeachCount, SUM(garden) AS gardenCount, SUM(openFire) AS openFireCount, SUM(romantic) AS romanticCount,
               SUM(CASE WHEN sleeps BETWEEN 2 AND 4 THEN 1 ELSE 0 END) AS sleeps2_4Count,
               SUM(CASE WHEN sleeps BETWEEN 5 AND 6 THEN 1 ELSE 0 END) AS sleeps5_6Count,
               SUM(CASE WHEN sleeps BETWEEN 7 AND 8 THEN 1 ELSE 0 END) AS sleeps7_8Count,
               SUM(CASE WHEN sleeps >= 9 THEN 1 ELSE 0 END) AS sleeps9Count
        FROM UKTravelFeeds.cottages
        WHERE county = 'Cornwall'
        AND siteCode IN (
            SELECT siteCode 
            FROM miniSitesSupplemental.northcornwallcottageswithhottubs
        )

counts array
Array
(
    [wifiCount] => 1
    [nearPubCount] => 0
    [fishingCount] => 1
    [poolCount] => 0
    [golfCount] => 0
    [allowsPetsCount] => 2
    [nearBeachCount] => 2
    [gardenCount] => 1
    [openFireCount] => 0
    [romanticCount] => 1
    [sleeps2_4Count] => 2
    [sleeps5_6Count] => 0
    [sleeps7_8Count] => 0
    [sleeps9Count] => 0
)

sortBy: bestMatch
orderBy:  ORDER BY county='Cornwall' DESC, siteName ASC

sql: SELECT df.*, sup.shortDesc 
         FROM UKTravelFeeds.cottages df
         INNER JOIN miniSitesSupplemental.northcornwallcottageswithhottubs sup ON df.siteCode = sup.siteCode
         WHERE df.county = 'Cornwall' AND df.locationNew = "South West of England"AND page != '.html' GROUP BY page   ORDER BY county='Cornwall' DESC, siteName ASC  LIMIT 0, 20