Forgotten your password? | Register Now
quick advanced pinpoint
cultural vacations
family holidays
historic holidays
luxury holidays
romantic getaways
boating & sailing holidays
clay shooting holidays
freshwater fishing holidays
game shooting holidays
golf holidays
scuba diving holidays
sea fishing holidays
skiing holidays
holidays in montenegro
rental apartments
long term short breaks
late deals
offers
6
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 = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [2] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [3] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [4] => SELECT 1 [5] => SELECT refnum FROM rental_properties p WHERE 1 [6] => 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 = 17 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [7] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 17 ) [8] => 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 = 17 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [9] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [10] => 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 = 17 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [11] => SELECT refnum FROM rental_properties p WHERE 1 [12] => 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 [13] => 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 [14] => SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [15] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY '1' [16] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 17 ) GROUP BY 'a' [17] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [18] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [19] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [20] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [21] => SELECT 1 [22] => SELECT refnum FROM rental_properties p WHERE 1 [23] => 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 '%#11#%') AND ( countryID = 17 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [24] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 17 ) [25] => 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 '%#11#%') AND ( countryID = 17 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [26] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [27] => 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 '%#11#%') AND ( countryID = 17 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [28] => SELECT refnum FROM rental_properties p WHERE 1 [29] => SELECT z.refnum as zoneid , z.lang1 as zone , c.refnum , c.lang1 FROM worldzones z , countries c WHERE c.refnum = '67' AND z.refnum = c.zoneID [30] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [31] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [32] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [33] => SELECT 1 [34] => SELECT refnum FROM rental_properties p WHERE 1 [35] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [36] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [37] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [38] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [39] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [40] => SELECT refnum FROM rental_properties p WHERE 1 [41] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [42] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [43] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [44] => SELECT 1 [45] => SELECT refnum FROM rental_properties p WHERE 1 [46] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [47] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [48] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [49] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [50] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [51] => SELECT refnum FROM rental_properties p WHERE 1 [52] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [53] => SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY bedrooms [54] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [55] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [56] => SELECT 1 [57] => SELECT refnum FROM rental_properties p WHERE 1 [58] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [59] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [60] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [61] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [62] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [63] => SELECT refnum FROM rental_properties p WHERE 1 [64] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [65] => 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 = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [66] => SELECT refnum FROM rental_properties p WHERE 1 [67] => 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 = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [68] => SELECT refnum FROM rental_properties p WHERE 1 [69] => 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 '%#11#%') GROUP BY zoneID) as p WHERE p.zoneID=z.refnum [70] => (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 '%#11#%') 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 ) [71] => (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 '%#11#%') 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) [72] => 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 '%#11#%') AND countryID IN (67) GROUP BY regionID) as p WHERE p.regionID = c.refnum [73] => 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 [74] => 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 [75] => SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [76] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY '1' [77] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [78] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [79] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [80] => SELECT 1 [81] => SELECT refnum FROM rental_properties p WHERE 1 [82] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [83] => SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [84] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [85] => SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [86] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [87] => SELECT refnum FROM rental_properties p WHERE 1 [88] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [89] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='8' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [90] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='8' [91] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='40' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [92] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40' [93] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='1' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [94] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='1' [95] => SELECT lang1 as region , refnum as pregionID FROM regions WHERE countryID = '67' ) [results:private] => Array ( [0] => Resource id #43 [1] => Resource id #44 [2] => Resource id #43 [3] => Resource id #44 [4] => Resource id #45 [5] => Resource id #46 [6] => Resource id #47 [7] => Resource id #48 [8] => Resource id #49 [9] => Resource id #50 [10] => Resource id #51 [11] => Resource id #46 [12] => Resource id #52 [13] => Resource id #53 [14] => Resource id #54 [15] => Resource id #55 [16] => Resource id #56 [17] => Resource id #57 [18] => Resource id #58 [19] => Resource id #57 [20] => Resource id #58 [21] => Resource id #45 [22] => Resource id #46 [23] => Resource id #59 [24] => Resource id #60 [25] => Resource id #61 [26] => Resource id #50 [27] => Resource id #62 [28] => Resource id #46 [29] => Resource id #63 [30] => Resource id #64 [31] => Resource id #57 [32] => Resource id #65 [33] => Resource id #45 [34] => Resource id #46 [35] => Resource id #66 [36] => Resource id #67 [37] => Resource id #68 [38] => Resource id #50 [39] => Resource id #69 [40] => Resource id #46 [41] => Resource id #64 [42] => Resource id #57 [43] => Resource id #65 [44] => Resource id #45 [45] => Resource id #46 [46] => Resource id #66 [47] => Resource id #67 [48] => Resource id #68 [49] => Resource id #50 [50] => Resource id #69 [51] => Resource id #46 [52] => Resource id #64 [53] => Resource id #72 [54] => Resource id #57 [55] => Resource id #65 [56] => Resource id #45 [57] => Resource id #46 [58] => Resource id #66 [59] => Resource id #67 [60] => Resource id #68 [61] => Resource id #50 [62] => Resource id #69 [63] => Resource id #46 [64] => Resource id #64 [65] => Resource id #84 [66] => Resource id #46 [67] => Resource id #84 [68] => Resource id #46 [69] => Resource id #98 [70] => Resource id #99 [71] => Resource id #100 [72] => Resource id #101 [73] => Resource id #52 [74] => Resource id #53 [75] => Resource id #54 [76] => Resource id #55 [77] => Resource id #64 [78] => Resource id #57 [79] => Resource id #65 [80] => Resource id #45 [81] => Resource id #46 [82] => Resource id #66 [83] => Resource id #67 [84] => Resource id #68 [85] => Resource id #50 [86] => Resource id #69 [87] => Resource id #46 [88] => Resource id #64 [89] => Resource id #104 [90] => Resource id #105 [91] => Resource id #106 [92] => Resource id #107 [93] => Resource id #108 [94] => Resource id #109 [95] => Resource id #110 ) [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 ) [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 = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [2] => 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' [3] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') GROUP BY 'a' [4] => villaway99db|SELECT 1 [5] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [6] => 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 = 17 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [7] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#1#%') AND ( countryID = 17 ) [8] => 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 = 17 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [9] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [10] => 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 = 17 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [11] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [12] => 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 [13] => 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 [14] => villaway99db|SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [15] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY '1' [16] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 17 ) GROUP BY 'a' [17] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [18] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [19] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [20] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 17 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [21] => villaway99db|SELECT 1 [22] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [23] => 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 '%#11#%') AND ( countryID = 17 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [24] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 17 ) [25] => 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 '%#11#%') AND ( countryID = 17 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [26] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [27] => 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 '%#11#%') AND ( countryID = 17 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [28] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [29] => villaway99db|SELECT z.refnum as zoneid , z.lang1 as zone , c.refnum , c.lang1 FROM worldzones z , countries c WHERE c.refnum = '67' AND z.refnum = c.zoneID [30] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [31] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [32] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [33] => villaway99db|SELECT 1 [34] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [35] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [36] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [37] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [38] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [39] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [40] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [41] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [42] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [43] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [44] => villaway99db|SELECT 1 [45] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [46] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [47] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [48] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [49] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [50] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [51] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [52] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [53] => villaway99db|SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY bedrooms [54] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [55] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [56] => villaway99db|SELECT 1 [57] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [58] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [59] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [60] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [61] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [62] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [63] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [64] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [65] => 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 = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [66] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [67] => 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 = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [68] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [69] => 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 '%#11#%') GROUP BY zoneID) as p WHERE p.zoneID=z.refnum [70] => 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 '%#11#%') 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 ) [71] => 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 '%#11#%') 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) [72] => 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 '%#11#%') AND countryID IN (67) GROUP BY regionID) as p WHERE p.regionID = c.refnum [73] => 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 [74] => 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 [75] => villaway99db|SELECT COUNT(p.refnum) AS num FROM rental_properties AS p WHERE p.pooltype != "" GROUP BY '1' [76] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY '1' [77] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [78] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [79] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 67 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a' [80] => villaway99db|SELECT 1 [81] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [82] => 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 '%#11#%') AND ( countryID = 67 )) p , COMMONholidayTypes ChT WHERE p.holidaytype LIKE CONCAT('%#' , ChT.refnum , '#%') GROUP BY ChT.refnum [83] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) [84] => 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 '%#11#%') AND ( countryID = 67 )) AS p JOIN COMMONlocationTypes ClT ON p.locationtype LIKE CONCAT('%#' , ClT.refnum , '#%') GROUP BY ClT.refnum [85] => villaway99db|SELECT COUNT(p.refnum) FROM rental_properties AS p WHERE 1 GROUP BY '1' [86] => 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 '%#11#%') AND ( countryID = 67 )) AS p , COMMONactivities Ca WHERE p.activities LIKE CONCAT('%#' , Ca.refnum , '#%') GROUP BY Ca.refnum [87] => villaway99db|SELECT refnum FROM rental_properties p WHERE 1 [88] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') AND ( countryID = 67 ) GROUP BY 'a' [89] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='8' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [90] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='8' [91] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='40' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [92] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40' [93] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='1' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' GROUP BY p.active [94] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='1' [95] => villaway99db|SELECT lang1 as region , refnum as pregionID FROM regions WHERE countryID = '67' ) [times:private] => Array ( [0] => 0.000364 [1] => 0.000147 [2] => 0.000013 [3] => 0.000014 [4] => 0.000281 [5] => 0.002441 [6] => 0.000279 [7] => 0.000159 [8] => 0.000176 [9] => 0.000152 [10] => 0.000186 [11] => 0.000031 [12] => 0.000296 [13] => 0.056525 [14] => 0.000231 [15] => 0.000165 [16] => 0.000194 [17] => 0.000163 [18] => 0.000152 [19] => 0.000049 [20] => 0.000047 [21] => 0.000048 [22] => 0.000047 [23] => 0.000228 [24] => 0.000168 [25] => 0.000186 [26] => 0.000061 [27] => 0.000219 [28] => 0.000075 [29] => 0.000282 [30] => 0.000233 [31] => 0.000072 [32] => 0.000178 [33] => 0.000072 [34] => 0.000067 [35] => 0.000246 [36] => 0.000154 [37] => 0.000161 [38] => 0.000084 [39] => 0.000197 [40] => 0.000105 [41] => 0.000082 [42] => 0.000099 [43] => 0.000099 [44] => 0.000090 [45] => 0.000087 [46] => 0.000093 [47] => 0.000092 [48] => 0.000094 [49] => 0.000097 [50] => 0.000100 [51] => 0.000107 [52] => 0.000101 [53] => 0.013555 [54] => 0.000136 [55] => 0.000108 [56] => 0.000112 [57] => 0.000108 [58] => 0.000110 [59] => 0.000114 [60] => 0.000115 [61] => 0.000125 [62] => 0.000120 [63] => 0.000130 [64] => 0.000130 [65] => 0.013269 [66] => 0.000155 [67] => 0.000146 [68] => 0.000144 [69] => 0.000259 [70] => 0.000199 [71] => 0.000175 [72] => 0.013457 [73] => 0.000176 [74] => 0.000156 [75] => 0.000150 [76] => 0.000160 [77] => 0.000164 [78] => 0.000158 [79] => 0.000167 [80] => 0.000176 [81] => 0.000159 [82] => 0.000172 [83] => 0.000173 [84] => 0.000169 [85] => 0.000177 [86] => 0.000181 [87] => 0.000189 [88] => 0.000179 [89] => 0.000309 [90] => 0.000154 [91] => 0.000230 [92] => 0.000141 [93] => 0.000206 [94] => 0.000138 [95] => 0.000197 ) [ftimes:private] => Array ( [0] => 0.000053 [1] => 0.000035 [2] => 0.000032 [3] => 0.000024 [4] => 0.000041 [5] => 0.000067 [6] => 0.000041 [7] => 0.000035 [8] => 0.000042 [9] => 0.000034 [10] => 0.000039 [11] => 0.000036 [12] => 0.000066 [13] => 0.000075 [14] => 0.000049 [15] => 0.000049 [16] => 0.000062 [17] => 0.000050 [18] => 0.000038 [19] => 0.000045 [20] => 0.000029 [21] => 0.000029 [22] => 0.000023 [23] => 0.000045 [24] => 0.000043 [25] => 0.000044 [26] => 0.000033 [27] => 0.000045 [28] => 0.000035 [29] => 0.000067 [30] => 0.000062 [31] => 0.000039 [32] => 0.000068 [33] => 0.000034 [34] => 0.000024 [35] => 0.000047 [36] => 0.000047 [37] => 0.000046 [38] => 0.000033 [39] => 0.000047 [40] => 0.000040 [41] => 0.000033 [42] => 0.000065 [43] => 0.000036 [44] => 0.000034 [45] => 0.000027 [46] => 0.000037 [47] => 0.000045 [48] => 0.000036 [49] => 0.000029 [50] => 0.000038 [51] => 0.000031 [52] => 0.000033 [53] => 0.000079 [54] => 0.000057 [55] => 0.000044 [56] => 0.000032 [57] => 0.000025 [58] => 0.000034 [59] => 0.000046 [60] => 0.000034 [61] => 0.000031 [62] => 0.000038 [63] => 0.000031 [64] => 0.000067 [65] => 0.000117 [66] => 0.000042 [67] => 0.000071 [68] => 0.000028 [69] => 0.000107 [70] => 0.000067 [71] => 0.000064 [72] => 0.000098 [73] => 0.000074 [74] => 0.000039 [75] => 0.000029 [76] => 0.000031 [77] => 0.000059 [78] => 0.000033 [79] => 0.000034 [80] => 0.000035 [81] => 0.000025 [82] => 0.000037 [83] => 0.000041 [84] => 0.000038 [85] => 0.000035 [86] => 0.000039 [87] => 0.000035 [88] => 0.000034 [89] => 0.000111 [90] => 0.000072 [91] => 0.000086 [92] => 0.000066 [93] => 0.000082 [94] => 0.000065 [95] => 0.000087 ) [stored:private] => Array ( [0] => queried [1] => queried [2] => stored [3] => stored [4] => queried [5] => queried [6] => queried [7] => queried [8] => queried [9] => queried [10] => queried [11] => stored [12] => queried [13] => queried [14] => queried [15] => queried [16] => queried [17] => queried [18] => queried [19] => stored [20] => stored [21] => stored [22] => stored [23] => queried [24] => queried [25] => queried [26] => stored [27] => queried [28] => stored [29] => queried [30] => queried [31] => stored [32] => queried [33] => stored [34] => stored [35] => queried [36] => queried [37] => queried [38] => stored [39] => queried [40] => stored [41] => stored [42] => stored [43] => stored [44] => stored [45] => stored [46] => stored [47] => stored [48] => stored [49] => stored [50] => stored [51] => stored [52] => stored [53] => queried [54] => stored [55] => stored [56] => stored [57] => stored [58] => stored [59] => stored [60] => stored [61] => stored [62] => stored [63] => stored [64] => stored [65] => queried [66] => stored [67] => stored [68] => stored [69] => queried [70] => queried [71] => queried [72] => queried [73] => stored [74] => stored [75] => stored [76] => stored [77] => stored [78] => stored [79] => stored [80] => stored [81] => stored [82] => stored [83] => stored [84] => stored [85] => stored [86] => stored [87] => stored [88] => stored [89] => queried [90] => queried [91] => queried [92] => queried [93] => queried [94] => queried [95] => queried ) [start:private] => 1280500210.93 [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='2636' AND p.subregionID = s.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') 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='2636' AND p.subregionID = s.refnum AND p.active=1 && p.propertytype LIKE '%#11#%' AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY p.active ) ) [2] => Array ( [file] => /home/villaway99/public_html/maps/country_flat/67.php [line] => 6 [function] => subregionAttributes [args] => Array ( [0] => 2636 [1] => [2] => 0 ) ) [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/67.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/montenegro/farmhouses_to_rent/index.php [line] => 1 [args] => Array ( [0] => /home/villaway99/public_html/code/search/cquick.php ) [function] => include ) )
