| 0.0002 | INSERT INTO sessions (session_id, ip_address, user_agent, last_activity, aff_id, template, sitename, referer) VALUES ('1434f72b75ba9112c95ffcb912b59d31', '38.107.191.106', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1268896409, '2', 'oceanblue_dec', 'TravelAffiliatePro', '') |
| 0.0005 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MX1094' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BU15558' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BU15558' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'TL04177' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TL04177' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MX1095' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MX1095' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MX1492' |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BV6069' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BV6069' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'KG07364' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'KG07364' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'KG07362' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'KG07362' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'EA03590' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EA03590' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DICLMDR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'DICLMDR' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'EOOH430' |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'RF033' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'OZ14713' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'LQ550' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DI04246' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HJ15398' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HJ15398' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'EA02612' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EA02612' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'EOOH116' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EOOH116' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DI01482' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MTCMHCO' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MTCMHCO' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'TL23494' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BV5885' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BV5885' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'RF660' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'YX4633' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CX7027' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CX7027' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CIOH156' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CIOH156' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'QIOH059' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'QIOH059' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'YXCMHOS' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXCMHOS' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CIOH179' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CCOH246' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CCOH246' |
| 0.0005 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MS18590' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'SZOH249' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'RF262' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RF262' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BU4637' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BU4637' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CIOH432' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'EA03229' |
| 0.0008 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'EA03229' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI1624' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI1624' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'YO0050' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI2504' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI2504' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CX7069' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CX7069' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI2138' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI2138' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'QIOH305' |
| 0.0003 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'QIOH305' |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'RF121' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RF121' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DR0107' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'DR0107' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'TOCMHTA' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'TOCMHTA' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CZOH242' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CZOH242' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CZOH187' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CZOH187' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BW36094' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW36094' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DICLMIS' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'DICLMIS' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BW36106' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW36106' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI0768' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI0768' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CX7116' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CX7116' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BW36146' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BW36146' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI4427' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI4427' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CP6187' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CP6187' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CIOH508' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'SI3329' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'LQ886' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI5791' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HI5791' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI2193' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI2203' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'YXCMH05' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YXCMH05' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'YZ3068' |
| 0.0004 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'YZ3068' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'WVCMH09' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WVCMH09' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HX5187' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HX5114' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HX5114' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'ILVPHAM' |
| 0.0004 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DR0129' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'FNCMHSU' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'FNCMHSU' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HI0303' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'RCCMHRD' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'RCCMHRD' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'GI38751' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'GI38751' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HG4295' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'GI8660' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'GI8660' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HX4504' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HX4504' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HYCAPIT' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HYCAPIT' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'WICOLUM' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'WICOLUM' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'BRCMHBR' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'BRCMHBR' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'XLCMHTB' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'XLCMHTB' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CYCMHAP' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CYCMHAP' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HX5720' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HX5720' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HG5053' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HG5053' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'IMCMHGV' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'IMCMHGV' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CYCMHCE' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CYCMHCE' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'MCCMHAM' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'MCCMHAM' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'DT023' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'DT023' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'HX5021' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'HX5021' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'CP3578' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'CP3578' |
| 0.0003 | SELECT *
FROM (`hotels`)
INNER JOIN `countries` ON countries.iso = hotels.country
WHERE `propertycode` = 'UZ52611' |
| 0.0002 | SELECT round(((availablectr/availabilitypoll)*100)/500,2)*500 as score
FROM (`hotels`)
WHERE `propertycode` = 'UZ52611' |
| 0.0002 | SELECT `city_code`, `city_name`
FROM (`citycodes`)
WHERE `city_id` = 1059
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.106'
AND `block_type` = 0
AND `primary_key` = '1' |
| 0.0004 | UPDATE `affiliate_blocked_ip` SET `time` = '2010-03-18 04:13:30' WHERE `block_type` = 0 AND `ip` = '38.107.191.106' 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' |
