Forgotten your password? | Register Now
quick advanced pinpoint
cultural holidays
family holidays
historic holidays
luxury holidays
romantic holidays
boating & sailing holidays
clay shooting holidays
freshwater fishing holidays
game shooting holidays
golf holidays
scuba diving holidays
sea fishing holidays
skiing holidays
long term short breaks
late deals
offers
2
Array ( [0] => Array ( [file] => /home/villaway99/public_html/code/search/class/c_sql.php [line] => 157 [function] => db_query [class] => sql_logger [object] => sql_logger Object ( [queries:private] => Array ( [0] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [1] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [2] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [3] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [4] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [5] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [6] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [7] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [8] => SELECT 1 [9] => SELECT refnum FROM rental_properties p WHERE 1 [10] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [11] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) [12] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [13] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [14] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [15] => SELECT refnum FROM rental_properties p WHERE 1 [16] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [17] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [18] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [19] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [20] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [21] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [22] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [23] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [24] => SELECT 1 [25] => SELECT refnum FROM rental_properties p WHERE 1 [26] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [27] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) [28] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [29] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [30] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [31] => SELECT refnum FROM rental_properties p WHERE 1 [32] => SELECT z.refnum as zoneid , z.lang1 as zone , c.refnum , c.lang1 FROM worldzones z , countries c WHERE c.refnum = '91' AND z.refnum = c.zoneID [33] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) GROUP BY 'a' [34] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [35] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [36] => SELECT 1 [37] => SELECT refnum FROM rental_properties p WHERE 1 [38] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [39] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [40] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [41] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [42] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [43] => SELECT refnum FROM rental_properties p WHERE 1 [44] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [45] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [46] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [47] => SELECT 1 [48] => SELECT refnum FROM rental_properties p WHERE 1 [49] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [50] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [51] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [52] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [53] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [54] => SELECT refnum FROM rental_properties p WHERE 1 [55] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [56] => SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY bedrooms [57] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [58] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [59] => SELECT 1 [60] => SELECT refnum FROM rental_properties p WHERE 1 [61] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [62] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [63] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [64] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [65] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [66] => SELECT refnum FROM rental_properties p WHERE 1 [67] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [68] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [69] => SELECT refnum FROM rental_properties p WHERE 1 [70] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [71] => SELECT refnum FROM rental_properties p WHERE 1 [72] => SELECT z.refnum, z.lang1, p.num FROM worldzones as z, (SELECT zoneID, COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY zoneID) as p WHERE p.zoneID=z.refnum [73] => (SELECT countryID , lang1 , refnum , num FROM countries c , (SELECT countryID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND zoneID IN (1,2,3,4,5,6,7,8,9,10,11) GROUP BY countryID ORDER BY num DESC LIMIT 5) as p WHERE p.countryID = c.refnum ) [74] => (SELECT countryID , lang1 , refnum , num FROM countries c , (SELECT countryID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND zoneID IN (1,2,3,4,5,6,7,8,9,10,11) GROUP BY countryID) as p WHERE p.countryID = c.refnum ORDER BY lang1 ASC) [75] => SELECT regionID , refnum , lang1 , num FROM regions c , (SELECT regionID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND countryID IN (91) GROUP BY regionID) as p WHERE p.regionID = c.refnum [76] => SELECT Cf.refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONfeatures Cf WHERE p.features LIKE CONCAT('%#' , Cf.refnum , '#%') AND Cf.search=1 GROUP BY Cf.refnum UNION SELECT CONCAT('sf_', Cf.refnum) AS refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONpropertySuitableFor Cf WHERE p.suitablefor LIKE CONCAT('%#' , Cf.refnum , '#%') GROUP BY Cf.refnum UNION SELECT CONCAT('pt_', Cf.refnum) AS refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONpropertyTypes Cf WHERE p.propertytype LIKE CONCAT('%#' , Cf.refnum , '#%') GROUP BY Cf.refnum [77] => SELECT Cp.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.pooltype FROM rental_properties AS p WHERE 1 ) AS p JOIN COMMONpool Cp ON p.pooltype LIKE CONCAT('%#' , Cp.refnum , '#%') AND Cp.searchThis=1 GROUP BY Cp.refnum [78] => SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [79] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY '1' [80] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) GROUP BY 'a' [81] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [82] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [83] => SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [84] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [85] => SELECT 1 [86] => SELECT refnum FROM rental_properties p WHERE 1 [87] => SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [88] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [89] => SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [90] => SELECT refnum FROM rental_properties p WHERE 1 [91] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [92] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='1104' AND p.regionID = r.refnum && p.holidaytype LIKE '%#23#%' GROUP BY 'a' [93] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='1104' [94] => SELECT cHT.lang1 AS themename FROM COMMONholidayTypes AS cHT WHERE cHT.refnum = 23 [95] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='1105' AND p.regionID = r.refnum && p.holidaytype LIKE '%#23#%' GROUP BY 'a' [96] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='1105' [97] => SELECT cHT.lang1 AS themename FROM COMMONholidayTypes AS cHT WHERE cHT.refnum = 23 [98] => SELECT lang1 as region , refnum as pregionID FROM regions WHERE countryID = '91' ) [results:private] => Array ( [0] => Resource id #43 [1] => Resource id #44 [2] => Resource id #45 [3] => Resource id #46 [4] => Resource id #43 [5] => Resource id #44 [6] => Resource id #45 [7] => Resource id #46 [8] => Resource id #47 [9] => Resource id #48 [10] => Resource id #49 [11] => Resource id #50 [12] => Resource id #51 [13] => Resource id #52 [14] => Resource id #53 [15] => Resource id #48 [16] => Resource id #43 [17] => Resource id #44 [18] => Resource id #45 [19] => Resource id #46 [20] => Resource id #43 [21] => Resource id #44 [22] => Resource id #45 [23] => Resource id #46 [24] => Resource id #47 [25] => Resource id #48 [26] => Resource id #49 [27] => Resource id #54 [28] => Resource id #55 [29] => Resource id #52 [30] => Resource id #56 [31] => Resource id #48 [32] => Resource id #57 [33] => Resource id #58 [34] => Resource id #59 [35] => Resource id #60 [36] => Resource id #47 [37] => Resource id #48 [38] => Resource id #61 [39] => Resource id #62 [40] => Resource id #63 [41] => Resource id #52 [42] => Resource id #64 [43] => Resource id #48 [44] => Resource id #65 [45] => Resource id #59 [46] => Resource id #60 [47] => Resource id #47 [48] => Resource id #48 [49] => Resource id #61 [50] => Resource id #62 [51] => Resource id #63 [52] => Resource id #52 [53] => Resource id #64 [54] => Resource id #48 [55] => Resource id #65 [56] => Resource id #68 [57] => Resource id #59 [58] => Resource id #60 [59] => Resource id #47 [60] => Resource id #48 [61] => Resource id #61 [62] => Resource id #62 [63] => Resource id #63 [64] => Resource id #52 [65] => Resource id #64 [66] => Resource id #48 [67] => Resource id #65 [68] => Resource id #79 [69] => Resource id #48 [70] => Resource id #79 [71] => Resource id #48 [72] => Resource id #91 [73] => Resource id #92 [74] => Resource id #93 [75] => Resource id #94 [76] => Resource id #95 [77] => Resource id #96 [78] => Resource id #97 [79] => Resource id #98 [80] => Resource id #58 [81] => Resource id #59 [82] => Resource id #60 [83] => Resource id #61 [84] => Resource id #62 [85] => Resource id #47 [86] => Resource id #48 [87] => Resource id #63 [88] => Resource id #52 [89] => Resource id #64 [90] => Resource id #48 [91] => Resource id #65 [92] => Resource id #101 [93] => Resource id #102 [94] => Resource id #103 [95] => Resource id #104 [96] => Resource id #105 [97] => Resource id #103 [98] => Resource id #106 ) [dbname:private] => Array ( [0] => villaway99db [1] => villaway99db [2] => villaway99db [3] => villaway99db [4] => villaway99db [5] => villaway99db [6] => villaway99db [7] => villaway99db [8] => villaway99db [9] => villaway99db [10] => villaway99db [11] => villaway99db [12] => villaway99db [13] => villaway99db [14] => villaway99db [15] => villaway99db [16] => villaway99db [17] => villaway99db [18] => villaway99db [19] => villaway99db [20] => villaway99db [21] => villaway99db [22] => villaway99db [23] => villaway99db [24] => villaway99db [25] => villaway99db [26] => villaway99db [27] => villaway99db [28] => villaway99db [29] => villaway99db [30] => villaway99db [31] => villaway99db [32] => villaway99db [33] => villaway99db [34] => villaway99db [35] => villaway99db [36] => villaway99db [37] => villaway99db [38] => villaway99db [39] => villaway99db [40] => villaway99db [41] => villaway99db [42] => villaway99db [43] => villaway99db [44] => villaway99db [45] => villaway99db [46] => villaway99db [47] => villaway99db [48] => villaway99db [49] => villaway99db [50] => villaway99db [51] => villaway99db [52] => villaway99db [53] => villaway99db [54] => villaway99db [55] => villaway99db [56] => villaway99db [57] => villaway99db [58] => villaway99db [59] => villaway99db [60] => villaway99db [61] => villaway99db [62] => villaway99db [63] => villaway99db [64] => villaway99db [65] => villaway99db [66] => villaway99db [67] => villaway99db [68] => villaway99db [69] => villaway99db [70] => villaway99db [71] => villaway99db [72] => villaway99db [73] => villaway99db [74] => villaway99db [75] => villaway99db [76] => villaway99db [77] => villaway99db [78] => villaway99db [79] => villaway99db [80] => villaway99db [81] => villaway99db [82] => villaway99db [83] => villaway99db [84] => villaway99db [85] => villaway99db [86] => villaway99db [87] => villaway99db [88] => villaway99db [89] => villaway99db [90] => villaway99db [91] => villaway99db [92] => villaway99db [93] => villaway99db [94] => villaway99db [95] => villaway99db [96] => villaway99db [97] => villaway99db [98] => villaway99db ) [qdb:private] => Array ( [0] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [1] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [2] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [3] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [4] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [5] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [6] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [7] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [8] => villaway99db|SELECT 1 [9] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [10] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [11] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) [12] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [13] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [14] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#20#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [15] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [16] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [17] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [18] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [19] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [20] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [21] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 45 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [22] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( regionID = 842 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [23] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( subregionID = 1309 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [24] => villaway99db|SELECT 1 [25] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [26] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [27] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) [28] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [29] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [30] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( subregionID = 1309 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [31] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [32] => villaway99db|SELECT z.refnum as zoneid , z.lang1 as zone , c.refnum , c.lang1 FROM worldzones z , countries c WHERE c.refnum = '91' AND z.refnum = c.zoneID [33] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) GROUP BY 'a' [34] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [35] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [36] => villaway99db|SELECT 1 [37] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [38] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [39] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [40] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [41] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [42] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [43] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [44] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [45] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [46] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [47] => villaway99db|SELECT 1 [48] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [49] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [50] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [51] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [52] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [53] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [54] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [55] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [56] => villaway99db|SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY bedrooms [57] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [58] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [59] => villaway99db|SELECT 1 [60] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [61] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [62] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [63] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [64] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [65] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [66] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [67] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [68] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [69] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [70] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [71] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [72] => villaway99db|SELECT z.refnum, z.lang1, p.num FROM worldzones as z, (SELECT zoneID, COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY zoneID) as p WHERE p.zoneID=z.refnum [73] => villaway99db| (SELECT countryID , lang1 , refnum , num FROM countries c , (SELECT countryID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND zoneID IN (1,2,3,4,5,6,7,8,9,10,11) GROUP BY countryID ORDER BY num DESC LIMIT 5) as p WHERE p.countryID = c.refnum ) [74] => villaway99db| (SELECT countryID , lang1 , refnum , num FROM countries c , (SELECT countryID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND zoneID IN (1,2,3,4,5,6,7,8,9,10,11) GROUP BY countryID) as p WHERE p.countryID = c.refnum ORDER BY lang1 ASC) [75] => villaway99db|SELECT regionID , refnum , lang1 , num FROM regions c , (SELECT regionID , COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND countryID IN (91) GROUP BY regionID) as p WHERE p.regionID = c.refnum [76] => villaway99db|SELECT Cf.refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONfeatures Cf WHERE p.features LIKE CONCAT('%#' , Cf.refnum , '#%') AND Cf.search=1 GROUP BY Cf.refnum UNION SELECT CONCAT('sf_', Cf.refnum) AS refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONpropertySuitableFor Cf WHERE p.suitablefor LIKE CONCAT('%#' , Cf.refnum , '#%') GROUP BY Cf.refnum UNION SELECT CONCAT('pt_', Cf.refnum) AS refnum , COUNT(p.refnum) as num FROM rental_properties p , COMMONpropertyTypes Cf WHERE p.propertytype LIKE CONCAT('%#' , Cf.refnum , '#%') GROUP BY Cf.refnum [77] => villaway99db|SELECT Cp.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.pooltype FROM rental_properties AS p WHERE 1 ) AS p JOIN COMMONpool Cp ON p.pooltype LIKE CONCAT('%#' , Cp.refnum , '#%') AND Cp.searchThis=1 GROUP BY Cp.refnum [78] => villaway99db|SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [79] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY '1' [80] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) GROUP BY 'a' [81] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 9 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [82] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 91 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [83] => villaway99db|SELECT ChT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.holidaytype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [84] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) [85] => villaway99db|SELECT 1 [86] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [87] => villaway99db|SELECT ClT.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.locationtype FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [88] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [89] => villaway99db|SELECT Ca.refnum AS refnum, COUNT(p.refnum) AS num FROM(SELECT p.refnum , p.activities FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) ) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [90] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [91] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 91 ) AND (p.holidaytype LIKE ('%#23#%')) GROUP BY 'a' [92] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='1104' AND p.regionID = r.refnum && p.holidaytype LIKE '%#23#%' GROUP BY 'a' [93] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='1104' [94] => villaway99db|SELECT cHT.lang1 AS themename FROM COMMONholidayTypes AS cHT WHERE cHT.refnum = 23 [95] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='1105' AND p.regionID = r.refnum && p.holidaytype LIKE '%#23#%' GROUP BY 'a' [96] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='1105' [97] => villaway99db|SELECT cHT.lang1 AS themename FROM COMMONholidayTypes AS cHT WHERE cHT.refnum = 23 [98] => villaway99db|SELECT lang1 as region , refnum as pregionID FROM regions WHERE countryID = '91' ) [times:private] => Array ( [0] => 0.000336 [1] => 0.000150 [2] => 0.000125 [3] => 0.000114 [4] => 0.000015 [5] => 0.000017 [6] => 0.000026 [7] => 0.000020 [8] => 0.000268 [9] => 0.000147 [10] => 0.000168 [11] => 0.000136 [12] => 0.000170 [13] => 0.000149 [14] => 0.000160 [15] => 0.000039 [16] => 0.000043 [17] => 0.000048 [18] => 0.000040 [19] => 0.000042 [20] => 0.000045 [21] => 0.000046 [22] => 0.000046 [23] => 0.000048 [24] => 0.000051 [25] => 0.000050 [26] => 0.000054 [27] => 0.000254 [28] => 0.000171 [29] => 0.000062 [30] => 0.000203 [31] => 0.000069 [32] => 0.000763 [33] => 0.000765 [34] => 0.000658 [35] => 0.000633 [36] => 0.000084 [37] => 0.000085 [38] => 0.001281 [39] => 0.001546 [40] => 0.001339 [41] => 0.000093 [42] => 0.001466 [43] => 0.000094 [44] => 0.000960 [45] => 0.000097 [46] => 0.000090 [47] => 0.000092 [48] => 0.000090 [49] => 0.000094 [50] => 0.000095 [51] => 0.000101 [52] => 0.000106 [53] => 0.000104 [54] => 0.000109 [55] => 0.000102 [56] => 0.000951 [57] => 0.000120 [58] => 0.000121 [59] => 0.000117 [60] => 0.000112 [61] => 0.000126 [62] => 0.000118 [63] => 0.000123 [64] => 0.000131 [65] => 0.000129 [66] => 0.000132 [67] => 0.000126 [68] => 0.001296 [69] => 0.000171 [70] => 0.000149 [71] => 0.000137 [72] => 0.000245 [73] => 0.000167 [74] => 0.000147 [75] => 0.001347 [76] => 0.000483 [77] => 0.001424 [78] => 0.000457 [79] => 0.000167 [80] => 0.000185 [81] => 0.000173 [82] => 0.000164 [83] => 0.000200 [84] => 0.000186 [85] => 0.000190 [86] => 0.000194 [87] => 0.000187 [88] => 0.000186 [89] => 0.000199 [90] => 0.000213 [91] => 0.000188 [92] => 0.000953 [93] => 0.000612 [94] => 0.000236 [95] => 0.000790 [96] => 0.000580 [97] => 0.000220 [98] => 0.000272 ) [ftimes:private] => Array ( [0] => 0.000052 [1] => 0.000036 [2] => 0.000032 [3] => 0.000031 [4] => 0.000032 [5] => 0.000023 [6] => 0.000024 [7] => 0.000023 [8] => 0.000052 [9] => 0.000035 [10] => 0.000041 [11] => 0.000039 [12] => 0.000039 [13] => 0.000039 [14] => 0.000045 [15] => 0.000039 [16] => 0.000053 [17] => 0.000025 [18] => 0.000023 [19] => 0.000023 [20] => 0.000028 [21] => 0.000022 [22] => 0.000023 [23] => 0.000028 [24] => 0.000030 [25] => 0.000024 [26] => 0.000028 [27] => 0.000047 [28] => 0.000052 [29] => 0.000038 [30] => 0.000050 [31] => 0.000050 [32] => 0.000117 [33] => 0.000092 [34] => 0.000092 [35] => 0.000093 [36] => 0.000043 [37] => 0.000028 [38] => 0.000080 [39] => 0.000095 [40] => 0.000099 [41] => 0.000049 [42] => 0.000088 [43] => 0.000047 [44] => 0.000104 [45] => 0.000080 [46] => 0.000036 [47] => 0.000033 [48] => 0.000027 [49] => 0.000042 [50] => 0.000037 [51] => 0.000052 [52] => 0.000032 [53] => 0.000040 [54] => 0.000040 [55] => 0.000037 [56] => 0.000079 [57] => 0.000076 [58] => 0.000038 [59] => 0.000033 [60] => 0.000026 [61] => 0.000041 [62] => 0.000041 [63] => 0.000047 [64] => 0.000079 [65] => 0.000045 [66] => 0.000043 [67] => 0.000038 [68] => 0.000124 [69] => 0.000044 [70] => 0.000073 [71] => 0.000030 [72] => 0.000110 [73] => 0.000067 [74] => 0.000062 [75] => 0.000102 [76] => 0.000122 [77] => 0.000125 [78] => 0.000126 [79] => 0.000108 [80] => 0.000061 [81] => 0.000042 [82] => 0.000037 [83] => 0.000052 [84] => 0.000043 [85] => 0.000037 [86] => 0.000031 [87] => 0.000045 [88] => 0.000037 [89] => 0.000043 [90] => 0.000035 [91] => 0.000041 [92] => 0.000149 [93] => 0.000133 [94] => 0.000126 [95] => 0.000127 [96] => 0.000133 [97] => 0.000109 [98] => 0.000093 ) [stored:private] => Array ( [0] => queried [1] => queried [2] => queried [3] => queried [4] => stored [5] => stored [6] => stored [7] => stored [8] => queried [9] => queried [10] => queried [11] => queried [12] => queried [13] => queried [14] => queried [15] => stored [16] => stored [17] => stored [18] => stored [19] => stored [20] => stored [21] => stored [22] => stored [23] => stored [24] => stored [25] => stored [26] => stored [27] => queried [28] => queried [29] => stored [30] => queried [31] => stored [32] => queried [33] => queried [34] => queried [35] => queried [36] => stored [37] => stored [38] => queried [39] => queried [40] => queried [41] => stored [42] => queried [43] => stored [44] => queried [45] => stored [46] => stored [47] => stored [48] => stored [49] => stored [50] => stored [51] => stored [52] => stored [53] => stored [54] => stored [55] => stored [56] => queried [57] => stored [58] => stored [59] => stored [60] => stored [61] => stored [62] => stored [63] => stored [64] => stored [65] => stored [66] => stored [67] => stored [68] => queried [69] => stored [70] => stored [71] => stored [72] => queried [73] => queried [74] => queried [75] => queried [76] => queried [77] => queried [78] => queried [79] => queried [80] => stored [81] => stored [82] => stored [83] => stored [84] => stored [85] => stored [86] => stored [87] => stored [88] => stored [89] => stored [90] => stored [91] => stored [92] => queried [93] => queried [94] => queried [95] => queried [96] => queried [97] => stored [98] => queried ) [start:private] => 1338032653.286 [finish:private] => ) [type] => -> [args] => Array ( [0] => villaway99db [1] => SELECT COUNT(p.active) AS totnum , s.lang1 AS subregion FROM subregions AS s , properties AS p WHERE s.refnum='1104' AND p.subregionID = s.refnum AND p.active=1 && p.holidaytype LIKE '%#23#%' AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND (p.holidaytype LIKE ('%#23#%')) GROUP BY p.active [2] => ) ) [1] => Array ( [file] => /home/villaway99/public_html/code/general_includes/x_country_map.php [line] => 261 [function] => db_query [args] => Array ( [0] => villaway99db [1] => SELECT COUNT(p.active) AS totnum , s.lang1 AS subregion FROM subregions AS s , properties AS p WHERE s.refnum='1104' AND p.subregionID = s.refnum AND p.active=1 && p.holidaytype LIKE '%#23#%' AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND (p.holidaytype LIKE ('%#23#%')) GROUP BY p.active ) ) [2] => Array ( [file] => /home/villaway99/public_html/maps/country_flat/91.php [line] => 5 [function] => subregionAttributes [args] => Array ( [0] => 1104 [1] => [2] => 23 ) ) [3] => Array ( [file] => /home/villaway99/public_html/code/general_includes/x_country_map.php [line] => 316 [args] => Array ( [0] => /home/villaway99/public_html/maps/country_flat/91.php ) [function] => include ) [4] => Array ( [file] => /home/villaway99/public_html/code/search/ajax/searchbox.php [line] => 115 [args] => Array ( [0] => /home/villaway99/public_html/code/general_includes/x_country_map.php ) [function] => include ) [5] => Array ( [file] => /home/villaway99/public_html/code/search/cquick2.php [line] => 222 [args] => Array ( [0] => /home/villaway99/public_html/code/search/ajax/searchbox.php ) [function] => include_once ) [6] => Array ( [file] => /home/villaway99/public_html/code/search/cquick.php [line] => 2 [args] => Array ( [0] => /home/villaway99/public_html/code/search/cquick2.php ) [function] => require_once ) [7] => Array ( [file] => /home/villaway99/public_html/en/trinidad_and_tobago/boating_&_sailing_holidays/index.php [line] => 1 [args] => Array ( [0] => /home/villaway99/public_html/code/search/cquick.php ) [function] => include ) )
