| 0.0006 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('4ee4f5b9f816ff6efb104b05bf6cc862', '54.205.188.59', 'CCBot/2.0 (http://commoncrawl.org/faq/)', 1406043153)
|
| 0.0006 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0003 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0042 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = '' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0006 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = 'a:1:{s:5:\"print\";s:1:\"1\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = 'a:2:{s:5:\"print\";s:1:\"1\";s:16:\"destination_type\";s:9:\"Countries\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = 'a:3:{s:5:\"print\";s:1:\"1\";s:16:\"destination_type\";s:9:\"Countries\";s:7:\"country\";s:17:\"US Virgin Islands\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE `ci_sessions` SET `last_activity` = 1406043153, `user_data` = 'a:4:{s:5:\"print\";s:1:\"1\";s:16:\"destination_type\";s:9:\"Countries\";s:7:\"country\";s:17:\"US Virgin Islands\";s:13:\"selected_node\";s:8:\"overview\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
SELECT *
FROM (`config_categories`)
WHERE `type` = 'left'
AND `parent_category_id` IN (SELECT id FROM config_categories WHERE link = "/countries")
AND `display_order` != '0'
ORDER BY `display_order`
|
| 0.0006 |
SELECT `province_code`, `province_name`, `c`.`country_name`
FROM (`provinces` p)
LEFT JOIN `countries` c ON `c`.`country_code` = `p`.`country_code`
WHERE `c`.`country_name` = 'US Virgin Islands'
ORDER BY `p`.`province_name`
|
| 0.0032 |
SELECT rc.id as regions_cities_id, rc.region_name, rc.major_city, rc.key_region, c.country_name, p.province_name FROM regions_cities rc INNER JOIN countries c ON c.country_code = rc.country_code LEFT JOIN provinces p ON rc.province_code = p.province_code WHERE c.country_name = "US Virgin Islands" AND rc.major_city = 1 AND rc.nfuwt != 1 UNION SELECT rc.id as regions_cities_id, rc.region_name, rc.major_city, rc.key_region, c.country_name, p.province_name FROM regions_cities rc INNER JOIN provinces p ON p.province_code = rc.province_code INNER JOIN countries c ON p.country_code = c.country_code WHERE c.country_name = "US Virgin Islands" AND rc.major_city = 1 AND rc.nfuwt != 1 ORDER BY region_name
|
| 0.0028 |
SELECT rc.id as regions_cities_id, rc.region_name, rc.major_city, rc.key_region, c.country_name, p.province_name FROM regions_cities rc INNER JOIN countries c ON c.country_code = rc.country_code LEFT JOIN provinces p ON rc.province_code = p.province_code WHERE c.country_name = "US Virgin Islands" AND rc.major_city = 0 AND rc.nfuwt != 1 UNION SELECT rc.id as regions_cities_id, rc.region_name, rc.major_city, rc.key_region, c.country_name, p.province_name FROM regions_cities rc INNER JOIN provinces p ON p.province_code = rc.province_code INNER JOIN countries c ON p.country_code = c.country_code WHERE c.country_name = "US Virgin Islands" AND rc.major_city = 0 AND rc.nfuwt != 1 ORDER BY region_name
|
| 0.0018 |
SELECT `r`.`id` as resort_id, `r`.`name`, `r`.`major_resort`, `r`.`attr_ski_chk`, `r`.`attr_beach_chk`, `c`.`country_name`, (SELECT region_name FROM regions_cities WHERE country_code = c.country_code AND id = r.region_city_code) as region_name
FROM (`resorts` r)
LEFT JOIN `countries` c ON `c`.`country_code` = `r`.`country_code`
WHERE `c`.`country_name` = 'US Virgin Islands'
AND `attr_ski_chk` != "Yes"
ORDER BY `r`.`major_resort` DESC, `r`.`name`
|
| 0.0013 |
SELECT `r`.`id` as resort_id, `r`.`name`, `r`.`major_resort`, `r`.`attr_ski_chk`, `r`.`attr_beach_chk`, `c`.`country_name`, (SELECT region_name FROM regions_cities WHERE country_code = c.country_code AND id = r.region_city_code) as region_name
FROM (`resorts` r)
LEFT JOIN `countries` c ON `c`.`country_code` = `r`.`country_code`
WHERE `c`.`country_name` = 'US Virgin Islands'
AND `attr_ski_chk` = 'Yes'
ORDER BY `r`.`major_resort` DESC, `r`.`name`
|
| 0.0012 |
SELECT `iata_code`, `name`, `url_name`, `c`.`country_name`
FROM (`port_of_call` pc)
LEFT JOIN `countries` c ON `c`.`country_code` = `pc`.`country_code`
WHERE `c`.`country_name` = 'US Virgin Islands'
ORDER BY `pc`.`name`
|
| 0.0004 |
SELECT *
FROM (`config_nodes` cn)
JOIN `config_nodes_categories` cnc ON `cnc`.`node_id` = `cn`.`id`
WHERE `cnc`.`category_id` IN (select id from config_categories where link = "/overview")
ORDER BY `cn`.`position`, `cnc`.`display_order`
|
| 0.0034 |
SELECT `id`, `headline`, `via_title`, `via_link`, `body`, `event_date`, `end_date`, `anchor_link`
FROM (`news`)
WHERE `for_pro` = 1
AND `end_date` > '2014-07-22'
AND `country_code` = (SELECT country_code FROM countries WHERE country_name = "US Virgin Islands")
|
| 0.0009 |
SELECT *
FROM (`tour_operators`)
WHERE `country_code` = (SELECT country_code FROM countries WHERE country_name = "US Virgin Islands")
AND `show_in_column` = 1
ORDER BY `show_in_column` DESC, `name`
|
| 0.0004 |
SELECT country_code FROM countries WHERE country_name = "US Virgin Islands"
|
| 0.0009 |
SELECT * from tourop_list WHERE destinations LIKE '%VI%' ORDER BY id DESC
|
| 0.0005 |
SELECT `country_code`
FROM (`countries`)
WHERE `country_name` = 'US Virgin Islands'
|
| 0.0150 |
SELECT d.id AS destination_id, d.overview AS destination_overview, d.extended_overview AS destination_extended_overview, d.photo as destination_photo, d.*, c.*, 'US Virgin Islands' AS country_name, LENGTH(CONCAT_WS(d.time, d.electricity, d.language, d.health, d.tipping, d.safety, d.business, d.communications, d.duty_free)) AS basics, LENGTH(CONCAT_WS(d.embassy_consulate_us, d.embassy_consulate_uk, d.embassy_consulate_ca, d.embassy_consulate_au, d.embassy_consulate_ir, d.embassy_consulate_nz)) AS contacts, (SELECT money FROM destinations WHERE country_code = "VI" ) AS money, (SELECT LENGTH(CONCAT_WS(passport_visa, entry_req_us, entry_req_uk, entry_req_ca, entry_req_au, entry_req_ir, entry_req_nz))
FROM destinations WHERE country_code = "VI" ) AS visa, (SELECT group_concat(id) FROM public_holiday p WHERE p.country_code = "VI" order by p.weight desc) AS public_holiday, (SELECT count(*) FROM tour_operators t where t.country_code = d.country_code) AS num_tour_ops, (SELECT count(id) AS total_rows FROM tourop_list tl WHERE tl.destinations LIKE ("%VI%")) AS num_tour_operators, (SELECT group_concat(name) FROM port_of_call pc WHERE pc.country_code = d.country_code) AS ports_of_call, (SELECT group_concat(region_name) FROM regions_cities WHERE major_city = 1 AND nfuwt != 1 AND country_code = d.country_code ORDER BY major_city DESC, region_name ASC) AS cities, (SELECT group_concat(region_name) FROM regions_cities WHERE major_city = 0 AND nfuwt != 1 AND country_code = d.country_code ORDER BY major_city DESC, region_name ASC) AS regions, (SELECT group_concat(name) FROM resorts WHERE major_resort = 1 AND country_code = d.country_code ORDER BY major_resort DESC, name ASC) AS resorts, (SELECT count(*) FROM dmcs WHERE country_code = d.country_code) AS num_dmcs, (SELECT concat(caption, " © ", copyright) FROM images WHERE filename = d.photo) AS photo_copyright, (SELECT count(*) FROM airports ai where ai.nfuwt != 1 AND ai.country_code = d.country_code) AS num_airports, (SELECT count(*) FROM events e where e.country_code = d.country_code AND show_on_country = 1) AS num_events, (SELECT count(*) FROM activities where region_city_code = "0" AND country_code = d.country_code) AS num_activities, (SELECT count(*) FROM attractions a where a.country_code = d.country_code AND show_on_country = 1 AND excursion = "No") AS num_attractions, (SELECT count(*) FROM attractions a where a.country_code = d.country_code AND show_on_country = 1 AND show_on_kids = 1 AND excursion = "No") AS num_kids_attractions, (SELECT count(*) FROM attractions a where a.country_code = d.country_code AND excursion = "Yes") AS num_excursions, (SELECT phrases FROM phrase_book pb where pb.country_code = c.country_code AND phrases != "") AS num_phrases, (SELECT count(*) FROM image_bridge ib LEFT OUTER JOIN images i ON ib.image_id=i.id WHERE ib.destination_code = c.country_code) AS num_photos, (SELECT count(*) FROM hospitals h where h.country_code = c.country_code) AS num_hospitals
FROM (destinations d)
LEFT JOIN countries c ON c.country_code = d.country_code
LEFT JOIN provinces pr ON pr.province_code = d.province_code
WHERE `c`.`country_name` = 'US Virgin Islands'
|
| 0.0005 |
UPDATE ci_sessions SET last_activity = 1406043153, user_data = 'a:4:{s:5:\"print\";s:1:\"1\";s:16:\"destination_type\";s:9:\"Countries\";s:7:\"country\";s:17:\"US Virgin Islands\";s:13:\"selected_node\";s:8:\"overview\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
UPDATE ci_sessions SET last_activity = 1406043153, user_data = 'a:5:{s:5:\"print\";s:1:\"1\";s:16:\"destination_type\";s:9:\"Countries\";s:7:\"country\";s:17:\"US Virgin Islands\";s:13:\"selected_node\";s:8:\"overview\";s:6:\"region\";s:0:\"\";}' WHERE `session_id` = '4ee4f5b9f816ff6efb104b05bf6cc862'
|
| 0.0005 |
SELECT *
FROM (currencies, countries)
WHERE countries.country_code IN ('us', 'gb', 'ca', 'au', 'za', 'ie', 'nz')
AND `currencies`.`country_name` = countries.country_name
ORDER BY countries.country_name
|
| 0.0076 |
SELECT DISTINCT d.country_code, c.country_name, d.province_code, a.name, a.name as airport_name, a.full_name, a.name as airport_name, a.iata_code, a.location, a.transfer_city, a.time, a.contacts as airport_contacts, a.car_rental, a.taxi, a.transfer_terminals, a.airport_facilities, a.departure_tax, a.website, (SELECT COUNT(provinces.province_name) FROM provinces WHERE provinces.country_code = c.country_code) as num_provinces, (SELECT COUNT(id) FROM airports a WHERE a.country_code = c.country_code) as num_airports
FROM (destinations d)
JOIN countries c ON c.country_code = d.country_code
LEFT JOIN airports a ON a.country_code = c.country_code
WHERE (a.name IS NOT NULL OR (SELECT COUNT(provinces.province_name) FROM provinces WHERE provinces.country_code = c.country_code) != 0) AND a.nfuwt != 1
AND `country_name` = 'US Virgin Islands'
ORDER BY c.country_name, airport_name
|
| 0.0009 |
SELECT i.*, e.fullname, e.bio, e.pic FROM interviews i INNER JOIN experts e ON i.expert_id = e.id
INNER JOIN countries c ON i.spatial_id = c.country_code WHERE i.interview_type = 'country' AND c.country_name = 'US Virgin Islands'
|
| 0.0012 |
SELECT TagID FROM FORUM_DiscussionTags WHERE Tag = 'US Virgin Islands'
|
| 0.0006 |
SELECT DiscussionID FROM FORUM_DiscussionHasTags WHERE TagID IN (2330)
GROUP BY DiscussionID HAVING COUNT(DiscussionID) = 1
|
| 0.0004 |
SELECT od.`Name`, od.`DiscussionID` FROM FORUM_Discussion od
WHERE od.`DiscussionID` IN ( 2172 ) ORDER BY od.`DateLastActive` DESC LIMIT 0 , 15;
|
