| 0.0002 | INSERT INTO sessions (session_id, ip_address, user_agent, last_activity, aff_id, template, sitename, referer) VALUES ('484a0d66ba7e4e786888d3c198b364a3', '38.107.191.109', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1268896442, '2', 'oceanblue_dec', 'TravelAffiliatePro', '') |
| 0.0016 | SELECT `propertycode`, `name`
FROM (`hotels`)
WHERE `active` = 1
AND `citycode` = 'bud'
ORDER BY `name` |
| 0.0005 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'XN02854' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUDAI' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BXBUDAF' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUDAH' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IP43777' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='LXBUDAN' |
| 0.0003 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'LXBUDAN' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17126' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TY0170' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HARIUS' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='PKBUDAR' |
| 0.0003 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'PKBUDAR' |
| 0.0004 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0487' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='ACGLOR' |
| 0.0005 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'ACGLOR' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0852' |
| 0.0003 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0852' |
| 0.0004 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0471' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0471' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0483' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0483' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0323' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0681' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0492' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0492' |
| 0.0003 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0484' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0484' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0701' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0701' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0748' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0748' |
| 0.0003 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='ONBUDAT' |
| 0.0003 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'ONBUDAT' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='HAATRIU' |
| 0.0004 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'HAATRIU' |
| 0.0004 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0724' |
| 0.0005 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0724' |
| 0.0002 | UPDATE hotels set availabilitypoll = availabilitypoll+1 , availablectr = availablectr+1 where 1 And propertycode='AC0108' |
| 0.0003 | SELECT `bookingcode`, `roomdesc`
FROM (`hotelrooms`)
WHERE `propertycode` = 'AC0108' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'LM33035' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89311' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89301' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89700' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89309' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EPZARA' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YHBUDBC' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BXBUDKR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BXBUDMS' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89303' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89308' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW89310' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0457' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UI14570' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ONBUDCI' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'LEPLVAX' |
| 0.0004 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ONBUDCH' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'XW13717' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WYCOHR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVBUDGR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WWBUDTH' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVBUDTH' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVBUDAT' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV24441' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVBUDGE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV21644' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV73280' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDRE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BXQGYFM' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'FS61179' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TY01121' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUD18' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUD19' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXSOBHK' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HL05815' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HL05836' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI2631' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17120' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ONBUDBE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD7' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD5' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV16797' |
| 0.0004 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TV40015' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV24185' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17118' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IRBUD24' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'XW18321' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHQGY1' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDKO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YH09042' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD22' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17117' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDHO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17127' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVQPJPL' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV17105' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17121' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD11' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17119' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDQU' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVQGYRB' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDSI' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVBUDSA' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD13' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUD10' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDGR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDAQ' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDFL' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDFO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDFR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDHE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDPA' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDPN' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDPE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDRP' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUDGO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTIBAER' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTIBBUD' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMREMK' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTLGBUD' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTIBVOL' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ICBUDHB' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HAJAGEL' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'LM89302' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YHBUDKD' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'KIBUD01' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TY1123' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'DSBUDLA' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MDBUD10' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YHBUDLG' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WV0818' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IRMARCO' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MCBUDHU' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MCBUDER' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRBUA' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTHUTAV' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRDUN' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRKRA' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRMTP' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRMUS' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTMRBUD' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'LW9504' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'NSBUDCI' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD23' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTNVRAK' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTNVBUD' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTNDBUD' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTNVQZD' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUDOH' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YHBUDPH' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'XLBUDQC' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RD114' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RABUDNR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RA15888' |
| 0.0001 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RACAQU' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IR2038' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'QRQGYRB' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YHBUD2' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RTBUDBU' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EPSOHO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'LE39382' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IHBUD17' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXBUDSS' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ17122' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'GT41562' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'GW5927' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HAWIEN' |
| 0.0013 | INSERT INTO `hotelsearchresult` (`request`, `response`, `hotellist`) VALUES ('N;', 'a:102:{i:0;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"ACGLOR\\\";s:12:\\\"propertyname\\\";s:20:\\\"Atel Gloria Budapest\\\";s:7:\\\"maxrate\\\";s:5:\\\"69.73\\\";s:7:\\\"minrate\\\";s:5:\\\"47.85\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:1;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0108\\\";s:12:\\\"propertyname\\\";s:11:\\\"Bara Junior\\\";s:7:\\\"maxrate\\\";s:5:\\\"62.89\\\";s:7:\\\"minrate\\\";s:5:\\\"49.22\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:2;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0471\\\";s:12:\\\"propertyname\\\";s:12:\\\"Atel Kristal\\\";s:7:\\\"maxrate\\\";s:5:\\\"50.58\\\";s:7:\\\"minrate\\\";s:5:\\\"50.58\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:3;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0484\\\";s:12:\\\"propertyname\\\";s:11:\\\"Atel Szonyi\\\";s:7:\\\"maxrate\\\";s:5:\\\"61.53\\\";s:7:\\\"minrate\\\";s:5:\\\"53.32\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:4;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0724\\\";s:12:\\\"propertyname\\\";s:10:\\\"Bara Hotel\\\";s:7:\\\"maxrate\\\";s:5:\\\"76.57\\\";s:7:\\\"minrate\\\";s:5:\\\"57.42\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:5;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"ONBUDAT\\\";s:12:\\\"propertyname\\\";s:11:\\\"Atlas Hotel\\\";s:7:\\\"maxrate\\\";s:6:\\\"125.79\\\";s:7:\\\"minrate\\\";s:5:\\\"60.15\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:6;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0492\\\";s:12:\\\"propertyname\\\";s:15:\\\"Atel Star Hotel\\\";s:7:\\\"maxrate\\\";s:6:\\\"106.64\\\";s:7:\\\"minrate\\\";s:5:\\\"60.16\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:7;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"PKBUDAR\\\";s:12:\\\"propertyname\\\";s:17:\\\"Art Otel Budapest\\\";s:7:\\\"maxrate\\\";s:6:\\\"169.54\\\";s:7:\\\"minrate\\\";s:5:\\\"60.84\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:8;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0748\\\";s:12:\\\"propertyname\\\";s:22:\\\"Atel Tisza Sport Hotel\\\";s:7:\\\"maxrate\\\";s:5:\\\"71.10\\\";s:7:\\\"minrate\\\";s:5:\\\"65.63\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:9;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0483\\\";s:12:\\\"propertyname\\\";s:10:\\\"Atel Matus\\\";s:7:\\\"maxrate\\\";s:6:\\\"108.01\\\";s:7:\\\"minrate\\\";s:5:\\\"66.99\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:10;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0701\\\";s:12:\\\"propertyname\\\";s:10:\\\"Atel Tisza\\\";s:7:\\\"maxrate\\\";s:5:\\\"92.97\\\";s:7:\\\"minrate\\\";s:5:\\\"77.93\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:11;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0852\\\";s:12:\\\"propertyname\\\";s:27:\\\"Atel Holiday Beach Budapest\\\";s:7:\\\"maxrate\\\";s:5:\\\"87.50\\\";s:7:\\\"minrate\\\";s:5:\\\"87.50\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:12;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"LXBUDAN\\\";s:12:\\\"propertyname\\\";s:14:\\\"Andrassy Hotel\\\";s:7:\\\"maxrate\\\";s:6:\\\"313.10\\\";s:7:\\\"minrate\\\";s:5:\\\"94.33\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:13;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"HAATRIU\\\";s:12:\\\"propertyname\\\";s:12:\\\"Atrium Hotel\\\";s:7:\\\"maxrate\\\";s:6:\\\"254.31\\\";s:7:\\\"minrate\\\";s:6:\\\"108.01\\\";s:8:\\\"ratetype\\\";s:13:\\\"Starting Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:14;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"HL05836\\\";s:12:\\\"propertyname\\\";s:23:\\\"Hilton Budapest Westend\\\";s:7:\\\"minrate\\\";s:5:\\\"28.99\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:15;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMRDUN\\\";s:12:\\\"propertyname\\\";s:23:\\\"Mercure Budapest Duna 3\\\";s:7:\\\"minrate\\\";s:5:\\\"44.44\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:16;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTIBVOL\\\";s:12:\\\"propertyname\\\";s:21:\\\"Ibis Budapest Vaci Ut\\\";s:7:\\\"minrate\\\";s:5:\\\"45.39\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:17;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMRMTP\\\";s:12:\\\"propertyname\\\";s:27:\\\"Mercure Budapest Metropol 4\\\";s:7:\\\"minrate\\\";s:5:\\\"52.01\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:18;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTIBAER\\\";s:12:\\\"propertyname\\\";s:18:\\\"Ibis Budapest Aero\\\";s:7:\\\"minrate\\\";s:5:\\\"53.79\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:19;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV16797\\\";s:12:\\\"propertyname\\\";s:14:\\\"Hotel Budapest\\\";s:7:\\\"minrate\\\";s:5:\\\"55.00\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:20;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMREMK\\\";s:12:\\\"propertyname\\\";s:18:\\\"Ibis Budapest Emke\\\";s:7:\\\"minrate\\\";s:5:\\\"56.74\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:21;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTLGBUD\\\";s:12:\\\"propertyname\\\";s:27:\\\"Ibis Budapest Heroes Square\\\";s:7:\\\"minrate\\\";s:5:\\\"57.68\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:22;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV24441\\\";s:12:\\\"propertyname\\\";s:23:\\\"Danubius Hotel Flamenco\\\";s:7:\\\"minrate\\\";s:5:\\\"57.98\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:23;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"ONBUDCH\\\";s:12:\\\"propertyname\\\";s:15:\\\"City Hotel Ring\\\";s:7:\\\"minrate\\\";s:5:\\\"58.28\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:24;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV24185\\\";s:12:\\\"propertyname\\\";s:14:\\\"Hotel Erzsebet\\\";s:7:\\\"minrate\\\";s:5:\\\"59.46\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:25;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"LM33035\\\";s:12:\\\"propertyname\\\";s:12:\\\"Baross Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"60.52\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:26;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMRKRA\\\";s:12:\\\"propertyname\\\";s:25:\\\"Mercure Budapest Korona 4\\\";s:7:\\\"minrate\\\";s:5:\\\"61.46\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:27;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMRMUS\\\";s:12:\\\"propertyname\\\";s:25:\\\"Mercure Budapest Museum 4\\\";s:7:\\\"minrate\\\";s:5:\\\"61.46\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:28;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTIBBUD\\\";s:12:\\\"propertyname\\\";s:21:\\\"Ibis Budapest Centrum\\\";s:7:\\\"minrate\\\";s:5:\\\"62.41\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:29;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDHO\\\";s:12:\\\"propertyname\\\";s:14:\\\"Hotel Oriental\\\";s:7:\\\"minrate\\\";s:5:\\\"62.89\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:30;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BXBUDKR\\\";s:12:\\\"propertyname\\\";s:29:\\\"Budapest Karoly Central Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"65.56\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:31;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTMRBUA\\\";s:12:\\\"propertyname\\\";s:23:\\\"Mercure Budapest Buda 4\\\";s:7:\\\"minrate\\\";s:5:\\\"65.75\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:32;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WVQGYRB\\\";s:12:\\\"propertyname\\\";s:10:\\\"Hotel Raba\\\";s:7:\\\"minrate\\\";s:5:\\\"66.89\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:33;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0681\\\";s:12:\\\"propertyname\\\";s:14:\\\"Atel Radio Inn\\\";s:7:\\\"maxrate\\\";N;s:7:\\\"minrate\\\";s:5:\\\"67.24\\\";s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:34;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"TY1123\\\";s:12:\\\"propertyname\\\";s:11:\\\"Kings Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"67.24\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:35;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"ONBUDCI\\\";s:12:\\\"propertyname\\\";s:17:\\\"City Hotel Matyas\\\";s:7:\\\"minrate\\\";s:5:\\\"67.24\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:36;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"IHQGY1\\\";s:12:\\\"propertyname\\\";s:14:\\\"Hotel Kalvaria\\\";s:7:\\\"minrate\\\";s:5:\\\"68.61\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:37;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDQU\\\";s:12:\\\"propertyname\\\";s:16:\\\"Hotel Queen Mary\\\";s:7:\\\"minrate\\\";s:5:\\\"68.73\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:38;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTNVRAK\\\";s:12:\\\"propertyname\\\";s:24:\\\"Novotel Budapest Centrum\\\";s:7:\\\"minrate\\\";s:5:\\\"69.03\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:39;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTHUTAV\\\";s:12:\\\"propertyname\\\";s:28:\\\"Mercure Budapest City Center\\\";s:7:\\\"minrate\\\";s:5:\\\"70.92\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:40;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"GT41562\\\";s:12:\\\"propertyname\\\";s:29:\\\"Tulip Inn Budapest Millennium\\\";s:7:\\\"minrate\\\";s:5:\\\"71.73\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:41;a:6:{s:12:\\\"propertycode\\\";s:5:\\\"RD114\\\";s:12:\\\"propertyname\\\";s:23:\\\"Radisson Sas Beke Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"73.97\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:42;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BXBUDMS\\\";s:12:\\\"propertyname\\\";s:23:\\\"Budapest Museam Central\\\";s:7:\\\"minrate\\\";s:5:\\\"74.39\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:43;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTNVBUD\\\";s:12:\\\"propertyname\\\";s:25:\\\"Novotel Budapest Congress\\\";s:7:\\\"minrate\\\";s:5:\\\"74.70\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:44;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"TY01121\\\";s:12:\\\"propertyname\\\";s:17:\\\"Golden Park Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"77.70\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:45;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"YXBUD19\\\";s:12:\\\"propertyname\\\";s:14:\\\"Goldhotel Pest\\\";s:7:\\\"minrate\\\";s:5:\\\"78.61\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:46;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WVBUDAT\\\";s:12:\\\"propertyname\\\";s:22:\\\"Danubius Hotel Astoria\\\";s:7:\\\"minrate\\\";s:5:\\\"80.27\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:47;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89301\\\";s:12:\\\"propertyname\\\";s:27:\\\"Best Western Hotel Hungaria\\\";s:7:\\\"minrate\\\";s:5:\\\"82.93\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:48;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"HI2631\\\";s:12:\\\"propertyname\\\";s:19:\\\"Holiday Inn Budaors\\\";s:7:\\\"minrate\\\";s:5:\\\"83.68\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:49;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"IHBUD7\\\";s:12:\\\"propertyname\\\";s:13:\\\"Hotel Benczur\\\";s:7:\\\"minrate\\\";s:5:\\\"84.33\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:50;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WVBUDGE\\\";s:12:\\\"propertyname\\\";s:22:\\\"Danubius Hotel Gellert\\\";s:7:\\\"minrate\\\";s:5:\\\"84.47\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:51;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUD22\\\";s:12:\\\"propertyname\\\";s:12:\\\"Hotel Molnar\\\";s:7:\\\"minrate\\\";s:5:\\\"84.58\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:52;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"UI14570\\\";s:12:\\\"propertyname\\\";s:22:\\\"Carlton Hotel Budapest\\\";s:7:\\\"minrate\\\";s:5:\\\"85.73\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:53;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"IHBUD5\\\";s:12:\\\"propertyname\\\";s:12:\\\"Hotel Bobbio\\\";s:7:\\\"minrate\\\";s:5:\\\"85.76\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:54;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"MCBUDER\\\";s:12:\\\"propertyname\\\";s:29:\\\"Marriott Exec Apts Millennium\\\";s:7:\\\"minrate\\\";s:5:\\\"87.00\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:55;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RABUDNR\\\";s:12:\\\"propertyname\\\";s:15:\\\"Ramada Budapest\\\";s:7:\\\"minrate\\\";s:5:\\\"87.64\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:56;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"YXBUD18\\\";s:12:\\\"propertyname\\\";s:14:\\\"Goldhotel Buda\\\";s:7:\\\"minrate\\\";s:5:\\\"87.70\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:57;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"DSBUDLA\\\";s:12:\\\"propertyname\\\";s:10:\\\"Lanchid 19\\\";s:7:\\\"minrate\\\";s:5:\\\"88.16\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:58;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"RACAQU\\\";s:12:\\\"propertyname\\\";s:21:\\\"Ramada Plaza Budapest\\\";s:7:\\\"minrate\\\";s:5:\\\"88.91\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:59;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTBUDBU\\\";s:12:\\\"propertyname\\\";s:16:\\\"Sofitel Budapest\\\";s:7:\\\"minrate\\\";s:5:\\\"89.52\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:60;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTNDBUD\\\";s:12:\\\"propertyname\\\";s:23:\\\"Novotel Budapest Danube\\\";s:7:\\\"minrate\\\";s:5:\\\"89.77\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:61;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"XW18321\\\";s:12:\\\"propertyname\\\";s:13:\\\"Hotel Isabell\\\";s:7:\\\"minrate\\\";s:5:\\\"91.09\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:62;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BXQGYFM\\\";s:12:\\\"propertyname\\\";s:13:\\\"Famulus Hotel\\\";s:7:\\\"minrate\\\";s:5:\\\"92.36\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:63;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89700\\\";s:12:\\\"propertyname\\\";s:25:\\\"Best Western Hotel Reduta\\\";s:7:\\\"minrate\\\";s:5:\\\"94.88\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:64;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"QRQGYRB\\\";s:12:\\\"propertyname\\\";s:27:\\\"Romantik Hotel Schweizerhof\\\";s:7:\\\"minrate\\\";s:5:\\\"97.13\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:65;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WVBUDGR\\\";s:12:\\\"propertyname\\\";s:30:\\\"Danubius Grand Hotel Margitszi\\\";s:7:\\\"minrate\\\";s:5:\\\"98.11\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:66;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV21644\\\";s:12:\\\"propertyname\\\";s:17:\\\"Dhsr Margitsziget\\\";s:7:\\\"minrate\\\";s:5:\\\"98.11\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:67;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RTNVQZD\\\";s:12:\\\"propertyname\\\";s:22:\\\"Novotel Szekesfehervar\\\";s:7:\\\"minrate\\\";s:5:\\\"98.63\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:68;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89308\\\";s:12:\\\"propertyname\\\";s:14:\\\"Bw Hotel Orion\\\";s:7:\\\"minrate\\\";s:6:\\\"101.61\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:69;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0487\\\";s:12:\\\"propertyname\\\";s:9:\\\"Atel Anna\\\";s:7:\\\"maxrate\\\";N;s:7:\\\"minrate\\\";s:6:\\\"101.65\\\";s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:70;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"ONBUDBE\\\";s:12:\\\"propertyname\\\";s:15:\\\"Hotel Belvedere\\\";s:7:\\\"minrate\\\";s:6:\\\"104.60\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:71;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDSI\\\";s:12:\\\"propertyname\\\";s:11:\\\"Hotel Sissi\\\";s:7:\\\"minrate\\\";s:6:\\\"104.60\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:72;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"WV0818\\\";s:12:\\\"propertyname\\\";s:27:\\\"Mamaison Residence Izabella\\\";s:7:\\\"minrate\\\";s:6:\\\"105.54\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:73;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89309\\\";s:12:\\\"propertyname\\\";s:18:\\\"Best Western Janus\\\";s:7:\\\"minrate\\\";s:6:\\\"105.77\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:74;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDPN\\\";s:12:\\\"propertyname\\\";s:23:\\\"Hunguest Hotel Panorama\\\";s:7:\\\"minrate\\\";s:6:\\\"107.59\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:75;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WVQPJPL\\\";s:12:\\\"propertyname\\\";s:15:\\\"Hotel Palatinus\\\";s:7:\\\"minrate\\\";s:6:\\\"110.00\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:76;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89303\\\";s:12:\\\"propertyname\\\";s:12:\\\"Bw Hotel Art\\\";s:7:\\\"minrate\\\";s:6:\\\"112.82\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:77;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"EPSOHO\\\";s:12:\\\"propertyname\\\";s:10:\\\"Soho Hotel\\\";s:7:\\\"minrate\\\";s:6:\\\"119.54\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:78;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"ICBUDHB\\\";s:12:\\\"propertyname\\\";s:25:\\\"Intercontinental Budapest\\\";s:7:\\\"minrate\\\";s:6:\\\"122.53\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:79;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"MCBUDHU\\\";s:12:\\\"propertyname\\\";s:17:\\\"Marriott Budapest\\\";s:7:\\\"minrate\\\";s:6:\\\"125.52\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:80;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDKO\\\";s:12:\\\"propertyname\\\";s:12:\\\"Hotel Korona\\\";s:7:\\\"minrate\\\";s:6:\\\"127.02\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:81;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"YXBUD10\\\";s:12:\\\"propertyname\\\";s:14:\\\"Hotel Victoria\\\";s:7:\\\"minrate\\\";s:6:\\\"127.84\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:82;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV17105\\\";s:12:\\\"propertyname\\\";s:19:\\\"Hotel Palazzo Zichy\\\";s:7:\\\"minrate\\\";s:6:\\\"132.30\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:83;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"MDBUD10\\\";s:12:\\\"propertyname\\\";s:20:\\\"Le Meridien Budapest\\\";s:7:\\\"minrate\\\";s:6:\\\"132.99\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:84;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89310\\\";s:12:\\\"propertyname\\\";s:26:\\\"Bw Premier Hotel Parlament\\\";s:7:\\\"minrate\\\";s:6:\\\"132.99\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:85;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"AC0457\\\";s:12:\\\"propertyname\\\";s:5:\\\"Carat\\\";s:7:\\\"minrate\\\";s:6:\\\"132.99\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:86;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"BW89311\\\";s:12:\\\"propertyname\\\";s:27:\\\"Best Western Hotel Aquarell\\\";s:7:\\\"minrate\\\";s:6:\\\"140.47\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:87;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"LM89302\\\";s:12:\\\"propertyname\\\";s:19:\\\"K And K Hotel Opera\\\";s:7:\\\"minrate\\\";s:6:\\\"144.95\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:88;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"RA15888\\\";s:12:\\\"propertyname\\\";s:32:\\\"Ramada Hotel Resort Lake Balaton\\\";s:7:\\\"minrate\\\";s:6:\\\"147.93\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:89;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"LE39382\\\";s:12:\\\"propertyname\\\";s:19:\\\"St George Residence\\\";s:7:\\\"minrate\\\";s:6:\\\"147.93\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:90;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"YXBUDAI\\\";s:12:\\\"propertyname\\\";s:22:\\\"Airport Hotel Budapest\\\";s:7:\\\"maxrate\\\";N;s:7:\\\"minrate\\\";s:6:\\\"150.95\\\";s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:91;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"KIBUD01\\\";s:12:\\\"propertyname\\\";s:24:\\\"Kempinski Hotel Budapest\\\";s:7:\\\"minrate\\\";s:6:\\\"152.82\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:92;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"LW9504\\\";s:12:\\\"propertyname\\\";s:23:\\\"New York Palace Boscolo\\\";s:7:\\\"minrate\\\";s:6:\\\"156.90\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:93;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"YXBUDSS\\\";s:12:\\\"propertyname\\\";s:29:\\\"Starlight Suiten Hotel Madach\\\";s:7:\\\"minrate\\\";s:6:\\\"162.03\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:94;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUD17\\\";s:12:\\\"propertyname\\\";s:22:\\\"Starlight Suiten Hotel\\\";s:7:\\\"minrate\\\";s:6:\\\"164.38\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:95;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"HL05815\\\";s:12:\\\"propertyname\\\";s:15:\\\"Hilton Budapest\\\";s:7:\\\"minrate\\\";s:6:\\\"164.38\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:96;a:6:{s:12:\\\"propertycode\\\";s:6:\\\"WYCOHR\\\";s:12:\\\"propertyname\\\";s:27:\\\"Corinthia Grand Hotel Royal\\\";s:7:\\\"minrate\\\";s:6:\\\"180.62\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:97;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"XLBUDQC\\\";s:12:\\\"propertyname\\\";s:13:\\\"Queen S Court\\\";s:7:\\\"minrate\\\";s:6:\\\"184.39\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:98;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDHE\\\";s:12:\\\"propertyname\\\";s:21:\\\"Hunguest Hotel Helios\\\";s:7:\\\"minrate\\\";s:6:\\\"191.27\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:99;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"IHBUDPE\\\";s:12:\\\"propertyname\\\";s:21:\\\"Hunguest Hotel Pelion\\\";s:7:\\\"minrate\\\";s:6:\\\"200.23\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:100;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"WV73280\\\";s:12:\\\"propertyname\\\";s:17:\\\"Domina Inn Fiesta\\\";s:7:\\\"minrate\\\";s:6:\\\"201.73\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}i:101;a:6:{s:12:\\\"propertycode\\\";s:7:\\\"FS61179\\\";s:12:\\\"propertyname\\\";s:27:\\\"Four Seasons Gresham Palace\\\";s:7:\\\"minrate\\\";s:6:\\\"384.54\\\";s:7:\\\"maxrate\\\";N;s:8:\\\"ratetype\\\";s:9:\\\"Base Rate\\\";s:9:\\\"direction\\\";s:0:\\\"\\\";}}', 'a:152:{i:0;s:7:\\\"XN02854\\\";i:1;s:7:\\\"YXBUDAI\\\";i:2;s:7:\\\"BXBUDAF\\\";i:3;s:7:\\\"YXBUDAH\\\";i:4;s:7:\\\"IP43777\\\";i:5;s:7:\\\"LXBUDAN\\\";i:6;s:7:\\\"UZ17126\\\";i:7;s:6:\\\"TY0170\\\";i:8;s:6:\\\"HARIUS\\\";i:9;s:7:\\\"PKBUDAR\\\";i:10;s:6:\\\"AC0487\\\";i:11;s:6:\\\"ACGLOR\\\";i:12;s:6:\\\"AC0852\\\";i:13;s:6:\\\"AC0471\\\";i:14;s:6:\\\"AC0483\\\";i:15;s:6:\\\"AC0323\\\";i:16;s:6:\\\"AC0681\\\";i:17;s:6:\\\"AC0492\\\";i:18;s:6:\\\"AC0484\\\";i:19;s:6:\\\"AC0701\\\";i:20;s:6:\\\"AC0748\\\";i:21;s:7:\\\"ONBUDAT\\\";i:22;s:7:\\\"HAATRIU\\\";i:23;s:6:\\\"AC0724\\\";i:24;s:6:\\\"AC0108\\\";i:25;s:7:\\\"LM33035\\\";i:26;s:7:\\\"BW89311\\\";i:27;s:7:\\\"BW89301\\\";i:28;s:7:\\\"BW89700\\\";i:29;s:7:\\\"BW89309\\\";i:30;s:6:\\\"EPZARA\\\";i:31;s:7:\\\"YHBUDBC\\\";i:32;s:7:\\\"BXBUDKR\\\";i:33;s:7:\\\"BXBUDMS\\\";i:34;s:7:\\\"BW89303\\\";i:35;s:7:\\\"BW89308\\\";i:36;s:7:\\\"BW89310\\\";i:37;s:6:\\\"AC0457\\\";i:38;s:7:\\\"UI14570\\\";i:39;s:7:\\\"ONBUDCI\\\";i:40;s:7:\\\"LEPLVAX\\\";i:41;s:7:\\\"ONBUDCH\\\";i:42;s:7:\\\"XW13717\\\";i:43;s:6:\\\"WYCOHR\\\";i:44;s:7:\\\"WVBUDGR\\\";i:45;s:7:\\\"WWBUDTH\\\";i:46;s:7:\\\"WVBUDTH\\\";i:47;s:7:\\\"WVBUDAT\\\";i:48;s:7:\\\"WV24441\\\";i:49;s:7:\\\"WVBUDGE\\\";i:50;s:7:\\\"WV21644\\\";i:51;s:7:\\\"WV73280\\\";i:52;s:7:\\\"IHBUDRE\\\";i:53;s:7:\\\"BXQGYFM\\\";i:54;s:7:\\\"FS61179\\\";i:55;s:7:\\\"TY01121\\\";i:56;s:7:\\\"YXBUD18\\\";i:57;s:7:\\\"YXBUD19\\\";i:58;s:7:\\\"YXSOBHK\\\";i:59;s:7:\\\"HL05815\\\";i:60;s:7:\\\"HL05836\\\";i:61;s:6:\\\"HI2631\\\";i:62;s:7:\\\"UZ17120\\\";i:63;s:7:\\\"ONBUDBE\\\";i:64;s:6:\\\"IHBUD7\\\";i:65;s:6:\\\"IHBUD5\\\";i:66;s:7:\\\"WV16797\\\";i:67;s:7:\\\"TV40015\\\";i:68;s:7:\\\"WV24185\\\";i:69;s:7:\\\"UZ17118\\\";i:70;s:7:\\\"IRBUD24\\\";i:71;s:7:\\\"XW18321\\\";i:72;s:6:\\\"IHQGY1\\\";i:73;s:7:\\\"IHBUDKO\\\";i:74;s:7:\\\"YH09042\\\";i:75;s:7:\\\"IHBUD22\\\";i:76;s:7:\\\"UZ17117\\\";i:77;s:7:\\\"IHBUDHO\\\";i:78;s:7:\\\"UZ17127\\\";i:79;s:7:\\\"WVQPJPL\\\";i:80;s:7:\\\"WV17105\\\";i:81;s:7:\\\"UZ17121\\\";i:82;s:7:\\\"IHBUD11\\\";i:83;s:7:\\\"UZ17119\\\";i:84;s:7:\\\"IHBUDQU\\\";i:85;s:7:\\\"WVQGYRB\\\";i:86;s:7:\\\"IHBUDSI\\\";i:87;s:7:\\\"WVBUDSA\\\";i:88;s:7:\\\"IHBUD13\\\";i:89;s:7:\\\"YXBUD10\\\";i:90;s:7:\\\"IHBUDGR\\\";i:91;s:7:\\\"IHBUDAQ\\\";i:92;s:7:\\\"IHBUDFL\\\";i:93;s:7:\\\"IHBUDFO\\\";i:94;s:7:\\\"IHBUDFR\\\";i:95;s:7:\\\"IHBUDHE\\\";i:96;s:7:\\\"IHBUDPA\\\";i:97;s:7:\\\"IHBUDPN\\\";i:98;s:7:\\\"IHBUDPE\\\";i:99;s:7:\\\"IHBUDRP\\\";i:100;s:7:\\\"IHBUDGO\\\";i:101;s:7:\\\"RTIBAER\\\";i:102;s:7:\\\"RTIBBUD\\\";i:103;s:7:\\\"RTMREMK\\\";i:104;s:7:\\\"RTLGBUD\\\";i:105;s:7:\\\"RTIBVOL\\\";i:106;s:7:\\\"ICBUDHB\\\";i:107;s:7:\\\"HAJAGEL\\\";i:108;s:7:\\\"LM89302\\\";i:109;s:7:\\\"YHBUDKD\\\";i:110;s:7:\\\"KIBUD01\\\";i:111;s:6:\\\"TY1123\\\";i:112;s:7:\\\"DSBUDLA\\\";i:113;s:7:\\\"MDBUD10\\\";i:114;s:7:\\\"YHBUDLG\\\";i:115;s:6:\\\"WV0818\\\";i:116;s:7:\\\"IRMARCO\\\";i:117;s:7:\\\"MCBUDHU\\\";i:118;s:7:\\\"MCBUDER\\\";i:119;s:7:\\\"RTMRBUA\\\";i:120;s:7:\\\"RTHUTAV\\\";i:121;s:7:\\\"RTMRDUN\\\";i:122;s:7:\\\"RTMRKRA\\\";i:123;s:7:\\\"RTMRMTP\\\";i:124;s:7:\\\"RTMRMUS\\\";i:125;s:7:\\\"RTMRBUD\\\";i:126;s:6:\\\"LW9504\\\";i:127;s:7:\\\"NSBUDCI\\\";i:128;s:7:\\\"IHBUD23\\\";i:129;s:7:\\\"RTNVRAK\\\";i:130;s:7:\\\"RTNVBUD\\\";i:131;s:7:\\\"RTNDBUD\\\";i:132;s:7:\\\"RTNVQZD\\\";i:133;s:7:\\\"YXBUDOH\\\";i:134;s:7:\\\"YHBUDPH\\\";i:135;s:7:\\\"XLBUDQC\\\";i:136;s:5:\\\"RD114\\\";i:137;s:7:\\\"RABUDNR\\\";i:138;s:7:\\\"RA15888\\\";i:139;s:6:\\\"RACAQU\\\";i:140;s:6:\\\"IR2038\\\";i:141;s:7:\\\"QRQGYRB\\\";i:142;s:6:\\\"YHBUD2\\\";i:143;s:7:\\\"RTBUDBU\\\";i:144;s:6:\\\"EPSOHO\\\";i:145;s:7:\\\"LE39382\\\";i:146;s:7:\\\"IHBUD17\\\";i:147;s:7:\\\"YXBUDSS\\\";i:148;s:7:\\\"UZ17122\\\";i:149;s:7:\\\"GT41562\\\";i:150;s:6:\\\"GW5927\\\";i:151;s:6:\\\"HAWIEN\\\";}') |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'ACGLOR' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'ACGLOR' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'ACGLOR' |
| 0.0009 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='GLOR' group by keywordname asc |
| 0.0165 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = 'GLOR'
ORDER BY `amenity` asc |
| 0.0003 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = 'GLOR'
LIMIT 200 |
| 0.0546 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = 'GLOR'
ORDER BY `propertypename` asc |
| 0.0004 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = 'GLOR' |
| 0.0161 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'ACGLOR'
LIMIT 200 |
| 0.0127 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = 'GLOR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ACGLOR' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0108' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0108' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0471' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0471' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0471' |
| 0.0008 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0471' group by keywordname asc |
| 0.0256 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0471'
ORDER BY `amenity` asc |
| 0.0005 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0471'
LIMIT 200 |
| 0.0512 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0471'
ORDER BY `propertypename` asc |
| 0.0003 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0471' |
| 0.0523 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0471'
LIMIT 200 |
| 0.0080 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0471' |
| 0.0004 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0471' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0484' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0484' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0484' |
| 0.0009 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0484' group by keywordname asc |
| 0.0110 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0484'
ORDER BY `amenity` asc |
| 0.0052 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0484'
LIMIT 200 |
| 0.0520 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0484'
ORDER BY `propertypename` asc |
| 0.0004 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0484' |
| 0.0098 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0484'
LIMIT 200 |
| 0.0003 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0484' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0484' |
| 0.0009 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0724' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0724' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0724' |
| 0.0009 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0724' group by keywordname asc |
| 0.0178 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0724'
ORDER BY `amenity` asc |
| 0.0004 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0724'
LIMIT 200 |
| 0.0745 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0724'
ORDER BY `propertypename` asc |
| 0.0003 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0724' |
| 0.0408 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0724'
LIMIT 200 |
| 0.0075 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0724' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0724' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'ONBUDAT' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'ONBUDAT' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'ONBUDAT' |
| 0.0011 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='ON' and propertyid='BUDAT' group by keywordname asc |
| 0.0067 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'ON'
AND `propertyid` = 'BUDAT'
ORDER BY `amenity` asc |
| 0.0032 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'ON'
AND `propertyid` = 'BUDAT'
LIMIT 200 |
| 0.0556 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'ON'
AND `propertyid` = 'BUDAT'
ORDER BY `propertypename` asc |
| 0.0002 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'ON'
AND `propertyid` = 'BUDAT' |
| 0.0254 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'ONBUDAT'
LIMIT 200 |
| 0.0175 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'ON'
AND `propertyid` = 'BUDAT' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'ONBUDAT' |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0492' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0492' |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0492' |
| 0.0010 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0492' group by keywordname asc |
| 0.0006 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0492'
ORDER BY `amenity` asc |
| 0.0003 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0492'
LIMIT 200 |
| 0.0513 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0492'
ORDER BY `propertypename` asc |
| 0.0002 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0492' |
| 0.0019 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0492'
LIMIT 200 |
| 0.0006 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0492' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0492' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'PKBUDAR' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'PKBUDAR' |
| 0.0002 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'PKBUDAR' |
| 0.0012 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='PK' and propertyid='BUDAR' group by keywordname asc |
| 0.0060 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'PK'
AND `propertyid` = 'BUDAR'
ORDER BY `amenity` asc |
| 0.0044 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'PK'
AND `propertyid` = 'BUDAR'
LIMIT 200 |
| 0.0529 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'PK'
AND `propertyid` = 'BUDAR'
ORDER BY `propertypename` asc |
| 0.0004 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'PK'
AND `propertyid` = 'BUDAR' |
| 0.0255 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'PKBUDAR'
LIMIT 200 |
| 0.0004 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'PK'
AND `propertyid` = 'BUDAR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'PKBUDAR' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0748' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0748' |
| 0.0002 | SELECT `name`
FROM (`states`)
WHERE `countrycode` = 'HU'
AND `abbrev` = ' '
LIMIT 1 |
| 0.0001 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0748' |
| 0.0009 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0748' group by keywordname asc |
| 0.0084 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0748'
ORDER BY `amenity` asc |
| 0.0003 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0748'
LIMIT 200 |
| 0.0532 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0748'
ORDER BY `propertypename` asc |
| 0.0004 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0748' |
| 0.0273 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0748'
LIMIT 200 |
| 0.0129 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0748' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0748' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0483' |
| 0.0001 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'AC0483' |
| 0.0002 | SELECT `url`
FROM (`hotelvideos`)
WHERE `propertycode` = 'AC0483' |
| 0.0009 | SELECT keywordnumber,keywordname, keyworddata FROM hoteldetails WHERE chaincode='AC' and propertyid='0483' group by keywordname asc |
| 0.0112 | SELECT *
FROM (`hotelamenities`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0483'
ORDER BY `amenity` asc |
| 0.0004 | SELECT *
FROM (`hotelvicinity`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0483'
LIMIT 200 |
| 0.0547 | SELECT *
FROM (`hoteltypegenericdescription`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0483'
ORDER BY `propertypename` asc |
| 0.0003 | SELECT *
FROM (`hoteloverview`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0483' |
| 0.0067 | SELECT *
FROM (`hoteldistancedirection`)
WHERE `propertycode` = 'AC0483'
LIMIT 200 |
| 0.0096 | SELECT *
FROM (`hotelimages`)
WHERE `chaincode` = 'AC'
AND `propertyid` = '0483' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'AC0483' |
| 0.0005 | SELECT *
FROM (`hotelsearchresult`)
LEFT JOIN `searchlog` ON searchlog.hotelsearchresult_id=hotelsearchresult.id
WHERE hotelsearchresult.id=816706
LIMIT 1 |
| 0.0171 | SELECT `propertypename`, `propertypecode`, `propertycode`, count(*) as hotelcount
FROM (`hoteltypegenericdescription`)
WHERE `propertycode` IN ('XN02854', 'YXBUDAI', 'BXBUDAF', 'YXBUDAH', 'IP43777', 'LXBUDAN', 'UZ17126', 'TY0170', 'HARIUS', 'PKBUDAR', 'AC0487', 'ACGLOR', 'AC0852', 'AC0471', 'AC0483', 'AC0323', 'AC0681', 'AC0492', 'AC0484', 'AC0701', 'AC0748', 'ONBUDAT', 'HAATRIU', 'AC0724', 'AC0108', 'LM33035', 'BW89311', 'BW89301', 'BW89700', 'BW89309', 'EPZARA', 'YHBUDBC', 'BXBUDKR', 'BXBUDMS', 'BW89303', 'BW89308', 'BW89310', 'AC0457', 'UI14570', 'ONBUDCI', 'LEPLVAX', 'ONBUDCH', 'XW13717', 'WYCOHR', 'WVBUDGR', 'WWBUDTH', 'WVBUDTH', 'WVBUDAT', 'WV24441', 'WVBUDGE', 'WV21644', 'WV73280', 'IHBUDRE', 'BXQGYFM', 'FS61179', 'TY01121', 'YXBUD18', 'YXBUD19', 'YXSOBHK', 'HL05815', 'HL05836', 'HI2631', 'UZ17120', 'ONBUDBE', 'IHBUD7', 'IHBUD5', 'WV16797', 'TV40015', 'WV24185', 'UZ17118', 'IRBUD24', 'XW18321', 'IHQGY1', 'IHBUDKO', 'YH09042', 'IHBUD22', 'UZ17117', 'IHBUDHO', 'UZ17127', 'WVQPJPL', 'WV17105', 'UZ17121', 'IHBUD11', 'UZ17119', 'IHBUDQU', 'WVQGYRB', 'IHBUDSI', 'WVBUDSA', 'IHBUD13', 'YXBUD10', 'IHBUDGR', 'IHBUDAQ', 'IHBUDFL', 'IHBUDFO', 'IHBUDFR', 'IHBUDHE', 'IHBUDPA', 'IHBUDPN', 'IHBUDPE', 'IHBUDRP', 'IHBUDGO', 'RTIBAER', 'RTIBBUD', 'RTMREMK', 'RTLGBUD', 'RTIBVOL', 'ICBUDHB', 'HAJAGEL', 'LM89302', 'YHBUDKD', 'KIBUD01', 'TY1123', 'DSBUDLA', 'MDBUD10', 'YHBUDLG', 'WV0818', 'IRMARCO', 'MCBUDHU', 'MCBUDER', 'RTMRBUA', 'RTHUTAV', 'RTMRDUN', 'RTMRKRA', 'RTMRMTP', 'RTMRMUS', 'RTMRBUD', 'LW9504', 'NSBUDCI', 'IHBUD23', 'RTNVRAK', 'RTNVBUD', 'RTNDBUD', 'RTNVQZD', 'YXBUDOH', 'YHBUDPH', 'XLBUDQC', 'RD114', 'RABUDNR', 'RA15888', 'RACAQU', 'IR2038', 'QRQGYRB', 'YHBUD2', 'RTBUDBU', 'EPSOHO', 'LE39382', 'IHBUD17', 'YXBUDSS', 'UZ17122', 'GT41562', 'GW5927', 'HAWIEN')
GROUP BY `propertypename`
ORDER BY `propertypename` |
| 0.0002 | INSERT INTO `searchlog` (`ipaddress`, `session_id`, `refferer`, `searched_for`, `time`, `data`, `hotelsearchresult_id`) VALUES ('38.107.191.109', '484a0d66ba7e4e786888d3c198b364a3', NULL, 'Budapest', 1268896458, 'a:7:{s:8:\\\"citycode\\\";s:3:\\\"bud\\\";s:8:\\\"citytext\\\";s:8:\\\"Budapest\\\";s:11:\\\"arrivaldate\\\";s:10:\\\"2010-03-19\\\";s:13:\\\"departuredate\\\";s:10:\\\"2010-03-20\\\";s:9:\\\"roomcount\\\";i:1;s:11:\\\"adultscount\\\";i:1;s:10:\\\"childcount\\\";i:0;}', 816706) |
| 0.0002 | SELECT `city_code`, `city_name`
FROM (`citycodes`)
WHERE `city_id` = 883
LIMIT 1 |
| 0.0001 | SELECT *
FROM (`affiliate`)
WHERE `aff_id` = '2' |
| 0.0001 | SELECT *
FROM (`affiliate_htmlcode`)
WHERE `user_id` = '2'
AND `type_id` = 1
LIMIT 1 |
| 0.0001 | SELECT *
FROM (`affiliate_htmlcode`)
WHERE `user_id` = '2'
AND `type_id` = 2
LIMIT 1 |
| 0.0004 | SELECT *
FROM (`affiliate_blocked_ip`)
WHERE `ip` = '38.107.191.109'
AND `block_type` = 0
AND `primary_key` = '1' |
| 0.0005 | UPDATE `affiliate_blocked_ip` SET `time` = '2010-03-18 04:14:18' WHERE `block_type` = 0 AND `ip` = '38.107.191.109' AND `primary_key` = '1' |
| 0.0005 | SELECT count(*) as trafficctr
FROM (`affiliate_traffic`)
WHERE `user_id` = '2'
AND `create_date` = '2010-03-18'
AND `product_id` = '1' |
| 0.0008 | UPDATE affiliate_traffic SET clickcount=clickcount+1, from_log=CONCAT(from_log, '
') WHERE user_id='2' AND create_date='2010-03-18' AND product_id='1' |
