Holiday Barn Rentals in Italy
Italian Seduction
Charming and exciting Italy is one of those magical destinations where you feel your holiday starts the moment you arrive! It’s an exotic showcase of romance, culture, tranquil landscapes and cuisine that seduces all the senses.
Whatever your holiday requirements Italy has it all from revered Renaissance art to Roman ruins, stroll through medieval towns, walk the wonder of Venice’s canals or appreciate the spectacularly dramatic scenery of the Amalfi coastline.
Italy is famous for its historical attractions such as the Colosseum of Rome, the Leaning Tower of Pisa and the Greek temple of Neptune of Paestum as well as its famous people and romantic landscapes. The epitome of romance from the canals of Venice with its bridges and gondoliers to the magical Alps for skiing, Italy is a lover’s paradise. Enjoy your favourite pizza or pasta in the land of their origin accompanied by one of Italy’s fine wines. Home to inspirational artists such as Leonardo da Vinci, Raphael and Michelangelo, Italy’s eminence transcends the boundaries of its boarders famed for elegant taste, Ferrari, poets such as Dante, Petrarch and Ariosto and musical brilliance through Vivaldi, Corelli, Gioacchino Rossini and Giuseppe Verdi.
It’s the perfect combination of great food, exquisite wine and the perfect place to purchase that ‘little number’ that depicts true Italian style. Italy is perfection, it has it all from pasta, poets and painters to the pope - it really is la dolce vita. The timeless beauty of Italy and abundance of cultural and historical sites to explore will enthral making you crave to stay for a lifetime!
[more]If you are looking for glorious sunshine, stunning beaches or a family holiday in a villa with nightlife then Italy is the place to be! Renowned for its sultry and vibrant way of life Italy offers diversity in culture, language, attractions, history and architecture ensuring you will never be short of things to do.
Italy offers something special for everyone so if you're looking for more tranquil or secluded side of this magnificent country be sure to explore its breathtaking countryside, this is where you can go for days hearing only Italian and find remote villages that have stood the test of time. The mountain ranges offer a beauty unsurpassed while the superb beaches of the Amalfi coastline offer a fun-filled adventure.
Day times are filled with many sports from golf to water sports, excursions such as jeep safaris or day trips to historic places or for those who wish for a relaxing holiday, days by your private pool or find yourself a quiet spot on the beach and make the most of that summer holiday sun.
Featured Rental Barns in Italy
Rental Barn: 62898
Certaldo,
Pisa,
Tuscany
2 Bedroom
Sleeps 8
No Pricing Info Available
Rental Barn: 62899
Certaldo,
Pisa,
Tuscany
3 Bedroom
Sleeps 7
No Pricing Info Available
villaway99db
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 '%#11#%') GROUP BY 'a'
[1] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a'
[2] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') GROUP BY 'a'
[3] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') 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 '%#11#%') AND ( countryID = 37 )) 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 '%#11#%') AND ( countryID = 37 )
[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 '%#11#%') AND ( countryID = 37 )) 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 '%#11#%') AND ( countryID = 37 )) 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 '%#26#%') GROUP BY '1'
[16] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 37 ) GROUP BY 'a'
[17] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[18] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[19] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[20] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 37 )) 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 '%#26#%') AND ( countryID = 37 )
[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 '%#26#%') AND ( countryID = 37 )) 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 '%#26#%') AND ( countryID = 37 )) 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 = '24' 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 '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[31] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[32] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[42] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[43] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[53] => SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 24 ) GROUP BY bedrooms
[54] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[55] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) 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 = 24 )) 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 = 24 )) 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 '%#26#%') 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 '%#26#%') 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 '%#26#%') 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 '%#26#%') AND countryID IN (24) 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 '%#26#%') GROUP BY '1'
[77] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[78] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( zoneID = 5 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') GROUP BY 'a'
[79] => SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[89] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='16' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[90] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='16' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[91] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='2' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[92] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='2'
[93] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[94] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[95] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='45' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[96] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='45'
[97] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[98] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[99] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[100] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[101] => 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 '%#26#%' GROUP BY p.active
[102] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40'
[103] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='9' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[104] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='9'
[105] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='67' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[106] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='67'
[107] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='4' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[108] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='4'
[109] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='42' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[110] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='42'
[111] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='10' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[112] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='10'
[113] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='21' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[114] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='21'
[115] => 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 '%#26#%' GROUP BY p.active
[116] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='8'
[117] => 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 '%#26#%' GROUP BY p.active
[118] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40'
[119] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='37' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[120] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='37'
[121] => 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 '%#26#%' GROUP BY p.active
[122] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='1'
[123] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='17' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[124] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='17'
[125] => SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='20' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[126] => SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='20'
[127] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='272' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[128] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='272'
[129] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='273' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[130] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='273'
[131] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='929' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[132] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='929'
[133] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='930' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[134] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='930'
[135] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='931' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[136] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='931'
[137] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='934' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[138] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='934'
[139] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='941' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[140] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='941'
[141] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='933' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[142] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='933'
[143] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='932' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[144] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='932'
[145] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='937' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[146] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='937'
[147] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='945' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[148] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='945'
[149] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='940' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[150] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='940'
[151] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='944' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[152] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='935' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[153] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='935'
[154] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='946' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[155] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='946'
[156] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='936' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[157] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='936'
[158] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='943' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[159] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='943'
[160] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='939' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[161] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='939'
[162] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='942' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[163] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='942'
[164] => SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='938' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[165] => SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='938'
[166] => SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62898'
[167] => SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[168] => SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[169] => SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
[170] => SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62899'
[171] => SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[172] => SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[173] => SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
[174] => SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62905'
[175] => SELECT COUNT(refnum) as units FROM properties WHERE subUnitOf='62905'
[176] => SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[177] => SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[178] => SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
)
[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 #90
[66] => Resource id #46
[67] => Resource id #90
[68] => Resource id #46
[69] => Resource id #104
[70] => Resource id #105
[71] => Resource id #106
[72] => Resource id #107
[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 #110
[90] => Resource id #111
[91] => Resource id #112
[92] => Resource id #113
[93] => Resource id #114
[94] => Resource id #115
[95] => Resource id #116
[96] => Resource id #117
[97] => Resource id #118
[98] => Resource id #115
[99] => Resource id #119
[100] => Resource id #115
[101] => Resource id #120
[102] => Resource id #121
[103] => Resource id #122
[104] => Resource id #123
[105] => Resource id #124
[106] => Resource id #125
[107] => Resource id #126
[108] => Resource id #127
[109] => Resource id #128
[110] => Resource id #129
[111] => Resource id #130
[112] => Resource id #131
[113] => Resource id #132
[114] => Resource id #133
[115] => Resource id #134
[116] => Resource id #135
[117] => Resource id #136
[118] => Resource id #121
[119] => Resource id #137
[120] => Resource id #138
[121] => Resource id #139
[122] => Resource id #140
[123] => Resource id #141
[124] => Resource id #142
[125] => Resource id #143
[126] => Resource id #144
[127] => Resource id #145
[128] => Resource id #146
[129] => Resource id #147
[130] => Resource id #148
[131] => Resource id #149
[132] => Resource id #150
[133] => Resource id #151
[134] => Resource id #152
[135] => Resource id #153
[136] => Resource id #154
[137] => Resource id #155
[138] => Resource id #156
[139] => Resource id #157
[140] => Resource id #158
[141] => Resource id #159
[142] => Resource id #160
[143] => Resource id #161
[144] => Resource id #162
[145] => Resource id #163
[146] => Resource id #164
[147] => Resource id #165
[148] => Resource id #166
[149] => Resource id #167
[150] => Resource id #168
[151] => Resource id #169
[152] => Resource id #170
[153] => Resource id #171
[154] => Resource id #172
[155] => Resource id #173
[156] => Resource id #174
[157] => Resource id #175
[158] => Resource id #176
[159] => Resource id #177
[160] => Resource id #178
[161] => Resource id #179
[162] => Resource id #180
[163] => Resource id #181
[164] => Resource id #182
[165] => Resource id #183
[166] => Resource id #189
[167] => Resource id #190
[168] => Resource id #191
[169] => Resource id #192
[170] => Resource id #202
[171] => Resource id #190
[172] => Resource id #191
[173] => Resource id #192
[174] => Resource id #207
[175] => Resource id #208
[176] => Resource id #190
[177] => Resource id #191
[178] => Resource id #192
)
[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
[99] => villaway99db
[100] => villaway99db
[101] => villaway99db
[102] => villaway99db
[103] => villaway99db
[104] => villaway99db
[105] => villaway99db
[106] => villaway99db
[107] => villaway99db
[108] => villaway99db
[109] => villaway99db
[110] => villaway99db
[111] => villaway99db
[112] => villaway99db
[113] => villaway99db
[114] => villaway99db
[115] => villaway99db
[116] => villaway99db
[117] => villaway99db
[118] => villaway99db
[119] => villaway99db
[120] => villaway99db
[121] => villaway99db
[122] => villaway99db
[123] => villaway99db
[124] => villaway99db
[125] => villaway99db
[126] => villaway99db
[127] => villaway99db
[128] => villaway99db
[129] => villaway99db
[130] => villaway99db
[131] => villaway99db
[132] => villaway99db
[133] => villaway99db
[134] => villaway99db
[135] => villaway99db
[136] => villaway99db
[137] => villaway99db
[138] => villaway99db
[139] => villaway99db
[140] => villaway99db
[141] => villaway99db
[142] => villaway99db
[143] => villaway99db
[144] => villaway99db
[145] => villaway99db
[146] => villaway99db
[147] => villaway99db
[148] => villaway99db
[149] => villaway99db
[150] => villaway99db
[151] => villaway99db
[152] => villaway99db
[153] => villaway99db
[154] => villaway99db
[155] => villaway99db
[156] => villaway99db
[157] => villaway99db
[158] => villaway99db
[159] => villaway99db
[160] => villaway99db
[161] => villaway99db
[162] => villaway99db
[163] => villaway99db
[164] => villaway99db
[165] => villaway99db
[166] => villaway99db
[167] => villaway99db
[168] => villaway99db
[169] => villaway99db
[170] => villaway99db
[171] => villaway99db
[172] => villaway99db
[173] => villaway99db
[174] => villaway99db
[175] => villaway99db
[176] => villaway99db
[177] => villaway99db
[178] => 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 '%#11#%') GROUP BY 'a'
[1] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') 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 '%#11#%') GROUP BY 'a'
[3] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#11#%') 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 '%#11#%') AND ( countryID = 37 )) 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 '%#11#%') AND ( countryID = 37 )
[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 '%#11#%') AND ( countryID = 37 )) 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 '%#11#%') AND ( countryID = 37 )) 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 '%#26#%') GROUP BY '1'
[16] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 37 ) 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 '%#26#%') GROUP BY 'a'
[18] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') GROUP BY 'a'
[20] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 37 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 37 )) 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 '%#26#%') AND ( countryID = 37 )
[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 '%#26#%') AND ( countryID = 37 )) 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 '%#26#%') AND ( countryID = 37 )) 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 = '24' 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 '%#26#%') AND ( countryID = 24 ) 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 '%#26#%') GROUP BY 'a'
[32] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) 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 '%#26#%') GROUP BY 'a'
[43] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) GROUP BY 'a'
[53] => villaway99db|SELECT bedrooms FROM rental_properties p WHERE bedrooms > 0 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 24 ) 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 '%#26#%') GROUP BY 'a'
[55] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) 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 = 24 )) 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 = 24 )) 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 '%#26#%') 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 '%#26#%') 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 '%#26#%') 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 '%#26#%') AND countryID IN (24) 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 '%#26#%') GROUP BY '1'
[77] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE 1 AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') AND ( countryID = 24 ) 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 '%#26#%') GROUP BY 'a'
[79] => villaway99db|SELECT COUNT(refnum) as num FROM rental_properties p WHERE ( countryID = 24 )AND (p.bedrooms >= 0) AND (p.propertytype LIKE '%#26#%') 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )
[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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 )) 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 '%#26#%') AND ( countryID = 24 ) 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='16' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[90] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='16' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[91] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='2' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[92] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='2'
[93] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[94] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[95] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='45' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[96] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='45'
[97] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[98] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[99] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='43' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[100] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='43'
[101] => 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 '%#26#%' GROUP BY p.active
[102] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40'
[103] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='9' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[104] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='9'
[105] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='67' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[106] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='67'
[107] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='4' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[108] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='4'
[109] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='42' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[110] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='42'
[111] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='10' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[112] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='10'
[113] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='21' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[114] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='21'
[115] => 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 '%#26#%' GROUP BY p.active
[116] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='8'
[117] => 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 '%#26#%' GROUP BY p.active
[118] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='40'
[119] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='37' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[120] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='37'
[121] => 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 '%#26#%' GROUP BY p.active
[122] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='1'
[123] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='17' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[124] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='17'
[125] => villaway99db|SELECT COUNT(p.active) AS totnum , c.lang1 AS country FROM countries AS c , properties AS p WHERE c.refnum='20' AND p.countryID = c.refnum AND p.active=1 && p.propertytype LIKE '%#26#%' GROUP BY p.active
[126] => villaway99db|SELECT c.lang1 AS country FROM countries AS c WHERE c.refnum='20'
[127] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='272' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[128] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='272'
[129] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='273' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[130] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='273'
[131] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='929' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[132] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='929'
[133] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='930' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[134] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='930'
[135] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='931' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[136] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='931'
[137] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='934' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[138] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='934'
[139] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='941' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[140] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='941'
[141] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='933' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[142] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='933'
[143] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='932' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[144] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='932'
[145] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='937' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[146] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='937'
[147] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='945' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[148] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='945'
[149] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='940' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[150] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='940'
[151] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='944' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[152] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='935' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[153] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='935'
[154] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='946' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[155] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='946'
[156] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='936' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[157] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='936'
[158] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='943' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[159] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='943'
[160] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='939' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[161] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='939'
[162] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='942' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[163] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='942'
[164] => villaway99db|SELECT COUNT(p.refnum) AS totnum , r.lang1 AS region FROM regions AS r , rental_properties AS p WHERE r.refnum='938' AND p.regionID = r.refnum && p.propertytype LIKE '%#26#%' GROUP BY 'a'
[165] => villaway99db|SELECT r.lang1 AS region FROM regions AS r WHERE r.refnum='938'
[166] => villaway99db|SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62898'
[167] => villaway99db|SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[168] => villaway99db|SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[169] => villaway99db|SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
[170] => villaway99db|SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62899'
[171] => villaway99db|SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[172] => villaway99db|SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[173] => villaway99db|SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
[174] => villaway99db|SELECT bedrooms , propertytype, pooltype, holidaytype , resortID , isSuperUnit FROM rental_properties p WHERE p.refnum = '62905'
[175] => villaway99db|SELECT COUNT(refnum) as units FROM properties WHERE subUnitOf='62905'
[176] => villaway99db|SELECT lang1 , refnum FROM COMMONpropertyTypes WHERE refnum = '26'
[177] => villaway99db|SELECT lang1 , refnum FROM COMMONpool WHERE refnum IN (14,17,18,20)
[178] => villaway99db|SELECT l.lang1 as resort , s.lang1 as subregion , r.lang1 as region , c.lang1 as country FROM countries c , regions r , subregions s , resorts l WHERE c.refnum = l.countryID AND l.regionID = r.refnum AND l.subregionID = s.refnum AND l.refnum = '21726'
)
[times:private] => Array
(
[0] => 0.000362
[1] => 0.000148
[2] => 0.000012
[3] => 0.000014
[4] => 0.000293
[5] => 0.002384
[6] => 0.000285
[7] => 0.000147
[8] => 0.000168
[9] => 0.000151
[10] => 0.000179
[11] => 0.000030
[12] => 0.000297
[13] => 0.055572
[14] => 0.000209
[15] => 0.000160
[16] => 0.013204
[17] => 0.000234
[18] => 0.013040
[19] => 0.000049
[20] => 0.000046
[21] => 0.000049
[22] => 0.000049
[23] => 0.014177
[24] => 0.013512
[25] => 0.014204
[26] => 0.000068
[27] => 0.014519
[28] => 0.000077
[29] => 0.000661
[30] => 0.013600
[31] => 0.000079
[32] => 0.013473
[33] => 0.000080
[34] => 0.000068
[35] => 0.014716
[36] => 0.013290
[37] => 0.014826
[38] => 0.000099
[39] => 0.014960
[40] => 0.000097
[41] => 0.000091
[42] => 0.000102
[43] => 0.000087
[44] => 0.000099
[45] => 0.000087
[46] => 0.000091
[47] => 0.000099
[48] => 0.000096
[49] => 0.000098
[50] => 0.000099
[51] => 0.000114
[52] => 0.000100
[53] => 0.014154
[54] => 0.000123
[55] => 0.000108
[56] => 0.000110
[57] => 0.000116
[58] => 0.000120
[59] => 0.000113
[60] => 0.000115
[61] => 0.000119
[62] => 0.000119
[63] => 0.000139
[64] => 0.000123
[65] => 0.015418
[66] => 0.000158
[67] => 0.000134
[68] => 0.000133
[69] => 0.000260
[70] => 0.000175
[71] => 0.000180
[72] => 0.014349
[73] => 0.000188
[74] => 0.000163
[75] => 0.000154
[76] => 0.000153
[77] => 0.000171
[78] => 0.000165
[79] => 0.000158
[80] => 0.000177
[81] => 0.000170
[82] => 0.000163
[83] => 0.000165
[84] => 0.000166
[85] => 0.000176
[86] => 0.000183
[87] => 0.000189
[88] => 0.000183
[89] => 0.000795
[90] => 0.000219
[91] => 0.001588
[92] => 0.000219
[93] => 0.040816
[94] => 0.000620
[95] => 0.007987
[96] => 0.000238
[97] => 0.000223
[98] => 0.000193
[99] => 0.000215
[100] => 0.000206
[101] => 0.001029
[102] => 0.000226
[103] => 0.003240
[104] => 0.000227
[105] => 0.001352
[106] => 0.000233
[107] => 0.000225
[108] => 0.000143
[109] => 0.000927
[110] => 0.000231
[111] => 0.006954
[112] => 0.000234
[113] => 0.007341
[114] => 0.000245
[115] => 0.000981
[116] => 0.000460
[117] => 0.000238
[118] => 0.000228
[119] => 0.001689
[120] => 0.000253
[121] => 0.001078
[122] => 0.000245
[123] => 0.001127
[124] => 0.000227
[125] => 0.004985
[126] => 0.000233
[127] => 0.013179
[128] => 0.000224
[129] => 0.012858
[130] => 0.000235
[131] => 0.012850
[132] => 0.000224
[133] => 0.012842
[134] => 0.000689
[135] => 0.012904
[136] => 0.000234
[137] => 0.012884
[138] => 0.000225
[139] => 0.012834
[140] => 0.000233
[141] => 0.013205
[142] => 0.000226
[143] => 0.012835
[144] => 0.000224
[145] => 0.012833
[146] => 0.000230
[147] => 0.012849
[148] => 0.000232
[149] => 0.012827
[150] => 0.000248
[151] => 0.012871
[152] => 0.013062
[153] => 0.000233
[154] => 0.012862
[155] => 0.000417
[156] => 0.013156
[157] => 0.000768
[158] => 0.012946
[159] => 0.000675
[160] => 0.013121
[161] => 0.000230
[162] => 0.012934
[163] => 0.000419
[164] => 0.013059
[165] => 0.000241
[166] => 0.000838
[167] => 0.000241
[168] => 0.000166
[169] => 0.001121
[170] => 0.000634
[171] => 0.000326
[172] => 0.000313
[173] => 0.000308
[174] => 0.000617
[175] => 0.082722
[176] => 0.000337
[177] => 0.000307
[178] => 0.000317
)
[ftimes:private] => Array
(
[0] => 0.000053
[1] => 0.000032
[2] => 0.000031
[3] => 0.000023
[4] => 0.000044
[5] => 0.000066
[6] => 0.000046
[7] => 0.000033
[8] => 0.000043
[9] => 0.000035
[10] => 0.000042
[11] => 0.000035
[12] => 0.000065
[13] => 0.000076
[14] => 0.000049
[15] => 0.000040
[16] => 0.000091
[17] => 0.000051
[18] => 0.000079
[19] => 0.000048
[20] => 0.000029
[21] => 0.000030
[22] => 0.000024
[23] => 0.000073
[24] => 0.000085
[25] => 0.000085
[26] => 0.000040
[27] => 0.000077
[28] => 0.000045
[29] => 0.000072
[30] => 0.000085
[31] => 0.000047
[32] => 0.000108
[33] => 0.000040
[34] => 0.000025
[35] => 0.000077
[36] => 0.000094
[37] => 0.000101
[38] => 0.000046
[39] => 0.000084
[40] => 0.000045
[41] => 0.000035
[42] => 0.000063
[43] => 0.000048
[44] => 0.000032
[45] => 0.000023
[46] => 0.000035
[47] => 0.000038
[48] => 0.000035
[49] => 0.000029
[50] => 0.000039
[51] => 0.000033
[52] => 0.000037
[53] => 0.000080
[54] => 0.000067
[55] => 0.000036
[56] => 0.000031
[57] => 0.000025
[58] => 0.000036
[59] => 0.000039
[60] => 0.000035
[61] => 0.000030
[62] => 0.000047
[63] => 0.000033
[64] => 0.000080
[65] => 0.000117
[66] => 0.000040
[67] => 0.000069
[68] => 0.000027
[69] => 0.000114
[70] => 0.000067
[71] => 0.000067
[72] => 0.000111
[73] => 0.000070
[74] => 0.000038
[75] => 0.000030
[76] => 0.000030
[77] => 0.000047
[78] => 0.000033
[79] => 0.000034
[80] => 0.000032
[81] => 0.000025
[82] => 0.000037
[83] => 0.000046
[84] => 0.000119
[85] => 0.000036
[86] => 0.000041
[87] => 0.000037
[88] => 0.000035
[89] => 0.000123
[90] => 0.000294
[91] => 0.000110
[92] => 0.000099
[93] => 0.000131
[94] => 0.000127
[95] => 0.000133
[96] => 0.000107
[97] => 0.000322
[98] => 0.000071
[99] => 0.000295
[100] => 0.000069
[101] => 0.000110
[102] => 0.000110
[103] => 0.000131
[104] => 0.000118
[105] => 0.000151
[106] => 0.000113
[107] => 0.000107
[108] => 0.000077
[109] => 0.000143
[110] => 0.000114
[111] => 0.000137
[112] => 0.000131
[113] => 0.000152
[114] => 0.000128
[115] => 0.000138
[116] => 0.000136
[117] => 0.000363
[118] => 0.000090
[119] => 0.000122
[120] => 0.000129
[121] => 0.000156
[122] => 0.000127
[123] => 0.000141
[124] => 0.000129
[125] => 0.000151
[126] => 0.000142
[127] => 0.000159
[128] => 0.000250
[129] => 0.000140
[130] => 0.000136
[131] => 0.000145
[132] => 0.000136
[133] => 0.000147
[134] => 0.000161
[135] => 0.000159
[136] => 0.000148
[137] => 0.000148
[138] => 0.000147
[139] => 0.000150
[140] => 0.000140
[141] => 0.000166
[142] => 0.000142
[143] => 0.000154
[144] => 0.000152
[145] => 0.000156
[146] => 0.000145
[147] => 0.000173
[148] => 0.000146
[149] => 0.000168
[150] => 0.000157
[151] => 0.000159
[152] => 0.000174
[153] => 0.000151
[154] => 0.000160
[155] => 0.000162
[156] => 0.000170
[157] => 0.000172
[158] => 0.000179
[159] => 0.000174
[160] => 0.000191
[161] => 0.000167
[162] => 0.000168
[163] => 0.000167
[164] => 0.000188
[165] => 0.000161
[166] => 0.000193
[167] => 0.000143
[168] => 0.000131
[169] => 0.000145
[170] => 0.000184
[171] => 0.000135
[172] => 0.000088
[173] => 0.000081
[174] => 0.000179
[175] => 0.000211
[176] => 0.000164
[177] => 0.000092
[178] => 0.000084
)
[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] => requeried
[91] => queried
[92] => queried
[93] => queried
[94] => queried
[95] => queried
[96] => queried
[97] => requeried
[98] => stored
[99] => requeried
[100] => stored
[101] => queried
[102] => queried
[103] => queried
[104] => queried
[105] => queried
[106] => queried
[107] => queried
[108] => queried
[109] => queried
[110] => queried
[111] => queried
[112] => queried
[113] => queried
[114] => queried
[115] => queried
[116] => queried
[117] => requeried
[118] => stored
[119] => queried
[120] => queried
[121] => queried
[122] => queried
[123] => queried
[124] => queried
[125] => queried
[126] => queried
[127] => queried
[128] => queried
[129] => queried
[130] => queried
[131] => queried
[132] => queried
[133] => queried
[134] => queried
[135] => queried
[136] => queried
[137] => queried
[138] => queried
[139] => queried
[140] => queried
[141] => queried
[142] => queried
[143] => queried
[144] => queried
[145] => queried
[146] => queried
[147] => queried
[148] => queried
[149] => queried
[150] => queried
[151] => queried
[152] => queried
[153] => queried
[154] => queried
[155] => queried
[156] => queried
[157] => queried
[158] => queried
[159] => queried
[160] => queried
[161] => queried
[162] => queried
[163] => queried
[164] => queried
[165] => queried
[166] => queried
[167] => queried
[168] => queried
[169] => queried
[170] => queried
[171] => stored
[172] => stored
[173] => stored
[174] => queried
[175] => queried
[176] => stored
[177] => stored
[178] => stored
)
[start:private] => 1280499651.8212
[finish:private] =>
)
[type] => ->
[args] => Array
(
[0] => villaway99db
[1] => SELECT COUNT(refnum) as units FROM rental_properties WHERE subUnitOf='62905'
[2] =>
)
)
[1] => Array
(
[file] => /home/villaway99/public_html/code/search/class/c_search_display.php
[line] => 958
[function] => db_query
[args] => Array
(
[0] => villaway99db
[1] => SELECT COUNT(refnum) as units FROM rental_properties WHERE subUnitOf='62905'
)
)
[2] => Array
(
[file] => /home/villaway99/public_html/code/search/class/c_search_display.php
[line] => 248
[function] => standard
[class] => searchDisplay
[object] => searchDisplay Object
(
[total:protected] => 3
[subtotal:protected] =>
[constraints:protected] => AND refnum IN (62899,62905,62898)
[name:protected] => names Object
(
[countries:protected] => Array
(
[24] => Italy
)
[regions:protected] => Array
(
[944] => Tuscany
)
[subregions:protected] => Array
(
[2046] => Pisa
)
[activities:protected] => Array
(
[36] => Horse Riding
)
[holidaytypes:protected] => Array
(
)
[pools:protected] => Array
(
)
[features:protected] => Array
(
)
[propertytype:protected] => Array
(
[26] => Barn
)
[resorts] => Array
(
[21726] => Certaldo
)
)
[currencies:protected] => Array
(
[1] => £
[2] => €
[3] => $
)
[currency:protected] => 0
[currency_exchange:protected] => Array
(
[1] => Array
(
[2] => 1.1443
[3] => 1.67
)
[2] => Array
(
[1] => 0.8739
[3] => 1.4594
)
[3] => Array
(
[1] => 0.5988
[2] => 0.6852
)
)
[start:protected] => 0
[batch:protected] => 10
[view:protected] => 0
[order:protected] =>
[filter:protected] =>
[type:protected] => 0
[openplan:protected] => Array
(
[1] => N/A
[8] => Kitchen + Dining Room
[9] => Kitchen + Sitting/Day Room
[10] => Kitchen + Dining Room + Sitting/Day Room
[11] => Dining Room + Sitting/Day Room
)
[chovds:protected] => Array
(
)
[filtersArray:protected] => Array
(
[1] => 0
[2] => 0
[3] => 0
[5] => 0
)
[sess_lang:protected] => en
[language:protected] =>
[chosen:protected] => Array
(
)
[refer] =>
[langauge] => lang1
[tra] => Array
(
[holiday_property_shortlist] => Holiday Property Shortlist
[no_property_shortlist] => There are no properties currently in your shortlist
[current_search_results] => Current Search Results
[filtered_search_results] => Filtered Search Results
[no_search_results] => There are no properties which match your search criteria
[current_shortlist] => Current Shortlist
[shortlist_para1] => You can add properties from other search results into your shortlist, or remove properties to refine the list.
[shortlist_list1] => If you are a registered Villaway user, log on now and you can save your shortlist!
[save_shortlist] => Save Shortlist
[send_shortlist] => Send Shortlist To Friends
[search_results] => Current Search Results
[main_search_total] => Main Search Total |total|
[x_to_y_of_z_properties] => |start| to |to| of total |total| properties
[page] => page
[Price_Asc] => Price(Ascending)
[Price_Desc] => Price(Descending)
[Order_by] => Order by
[standard_view] => Standard View
[no_pictures] => No Pictures
[expanded_view] => Expanded View
[details] => Details
[all_properties] => All properties
[only_short] => Only Short Breaks
[only_late] => Only Late Deals
[only_flexible] => Only Flexible Change Over
[only_special] => Only Special Offers
[filter_by] => Filter By
[Show] => Show
[results_pp] => results per page
[Prices] => Show Prices As
[change_over_mismatch] => Change Over Day Mismatch
[prices_from] => Prices From
[no_prices] => No Pricing Info Available
[bedrooms] => Bedrooms
[w_ensuite] => with Ensuite
[bathrooms] => Bathrooms
[separate_toilets] => Separate Toilets
[dining_rooms] => Dining Rooms
[day_rooms] => Day Rooms
[games_rooms] => Games Rooms
[Pool] => Pool
[Theme] => Theme
[Activities] => Activities
[Property_Features] => Property Features
[Featured] => Featured
[Sleeps] => Sleeps
[Full_Desc] => Full Description of Property
[Picture_of] => Picture of Property
[Add_property] => Add Property |refnum| to Shortlist
[full_details] => Full Details
[remove_from] => Remove From Shortlist
[save_for] => Add to Shortlist
[property_ref] => Property Ref
[remove_from_shortlist] => Remove from shortlist
)
)
[type] => ->
[args] => Array
(
[0] => Array
(
[refnum] => 62905
[countryID] => 24
[zoneID] => 5
[regionID] => 944
[subregionID] => 2046
[resortID] => 21726
[pooltype] => #15#
[features] =>
[roombyroom] =>
[suitablefor] =>
[notAllowed] =>
[roombyroom2] =>
[activities] => #36#
[locationtype] => #
[locationtype2] => #
[holidaytype] => #
[lateDeals] => 0
[specialDeals] => 0
[sleeps] => 0
[distance6] => 0
[distance4] => 0
[distance3] => 0
[distance1] => 0
[distance5] => 0
[distance2] => 0
[shortBreakInfo] => 0
[longTermRentals] => 0
[longTermRentalPrice] => 0
[distanceairport] => 0.00
[distanceferryport] => 0.00
[distancemotorway] => 0.00
[bedrooms] => 14
[propertytype] => #26#
[propertyID] => 62905
[priceComp] => 0
[pricecurrency] => 0
[priceinfo] => 0
[changeoverFlex] => 2
[dateTermsAgreed] => 2
[isSuperUnit] => 1
[ownerID] => 33189
[payPerLead] => 0
[commission] => 9
[isLongTerm] => 0
[priceComp2] => 99999999999
)
[1] => 6
[2] => 7 Unit - 14 Bedroom Barn to Rent with a Pool in Certaldo-Italy
)
)
[3] => Array
(
[file] => /home/villaway99/public_html/code/search/cquick2.php
[line] => 252
[function] => display
[class] => searchDisplay
[object] => searchDisplay Object
(
[total:protected] => 3
[subtotal:protected] =>
[constraints:protected] => AND refnum IN (62899,62905,62898)
[name:protected] => names Object
(
[countries:protected] => Array
(
[24] => Italy
)
[regions:protected] => Array
(
[944] => Tuscany
)
[subregions:protected] => Array
(
[2046] => Pisa
)
[activities:protected] => Array
(
[36] => Horse Riding
)
[holidaytypes:protected] => Array
(
)
[pools:protected] => Array
(
)
[features:protected] => Array
(
)
[propertytype:protected] => Array
(
[26] => Barn
)
[resorts] => Array
(
[21726] => Certaldo
)
)
[currencies:protected] => Array
(
[1] => £
[2] => €
[3] => $
)
[currency:protected] => 0
[currency_exchange:protected] => Array
(
[1] => Array
(
[2] => 1.1443
[3] => 1.67
)
[2] => Array
(
[1] => 0.8739
[3] => 1.4594
)
[3] => Array
(
[1] => 0.5988
[2] => 0.6852
)
)
[start:protected] => 0
[batch:protected] => 10
[view:protected] => 0
[order:protected] =>
[filter:protected] =>
[type:protected] => 0
[openplan:protected] => Array
(
[1] => N/A
[8] => Kitchen + Dining Room
[9] => Kitchen + Sitting/Day Room
[10] => Kitchen + Dining Room + Sitting/Day Room
[11] => Dining Room + Sitting/Day Room
)
[chovds:protected] => Array
(
)
[filtersArray:protected] => Array
(
[1] => 0
[2] => 0
[3] => 0
[5] => 0
)
[sess_lang:protected] => en
[language:protected] =>
[chosen:protected] => Array
(
)
[refer] =>
[langauge] => lang1
[tra] => Array
(
[holiday_property_shortlist] => Holiday Property Shortlist
[no_property_shortlist] => There are no properties currently in your shortlist
[current_search_results] => Current Search Results
[filtered_search_results] => Filtered Search Results
[no_search_results] => There are no properties which match your search criteria
[current_shortlist] => Current Shortlist
[shortlist_para1] => You can add properties from other search results into your shortlist, or remove properties to refine the list.
[shortlist_list1] => If you are a registered Villaway user, log on now and you can save your shortlist!
[save_shortlist] => Save Shortlist
[send_shortlist] => Send Shortlist To Friends
[search_results] => Current Search Results
[main_search_total] => Main Search Total |total|
[x_to_y_of_z_properties] => |start| to |to| of total |total| properties
[page] => page
[Price_Asc] => Price(Ascending)
[Price_Desc] => Price(Descending)
[Order_by] => Order by
[standard_view] => Standard View
[no_pictures] => No Pictures
[expanded_view] => Expanded View
[details] => Details
[all_properties] => All properties
[only_short] => Only Short Breaks
[only_late] => Only Late Deals
[only_flexible] => Only Flexible Change Over
[only_special] => Only Special Offers
[filter_by] => Filter By
[Show] => Show
[results_pp] => results per page
[Prices] => Show Prices As
[change_over_mismatch] => Change Over Day Mismatch
[prices_from] => Prices From
[no_prices] => No Pricing Info Available
[bedrooms] => Bedrooms
[w_ensuite] => with Ensuite
[bathrooms] => Bathrooms
[separate_toilets] => Separate Toilets
[dining_rooms] => Dining Rooms
[day_rooms] => Day Rooms
[games_rooms] => Games Rooms
[Pool] => Pool
[Theme] => Theme
[Activities] => Activities
[Property_Features] => Property Features
[Featured] => Featured
[Sleeps] => Sleeps
[Full_Desc] => Full Description of Property
[Picture_of] => Picture of Property
[Add_property] => Add Property |refnum| to Shortlist
[full_details] => Full Details
[remove_from] => Remove From Shortlist
[save_for] => Add to Shortlist
[property_ref] => Property Ref
[remove_from_shortlist] => Remove from shortlist
)
)
[type] => ->
[args] => Array
(
[0] => 6
)
)
[4] => 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
)
[5] => Array
(
[file] => /home/villaway99/public_html/en/italy/barns_to_rent/index.php
[line] => 1
[args] => Array
(
[0] => /home/villaway99/public_html/code/search/cquick.php
)
[function] => include
)
)