WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_notifications`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_posts`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wfblocks7`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wfblocks7`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT COLLATION_NAME
FROM information_schema.columns
WHERE TABLE_SCHEMA = '0x-g8t3-COMEVOLVEDGUIDE_develop_db' AND TABLE_NAME = 'wp_icl_strings' AND COLUMN_NAME = 'context'
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wfblocks7`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wfblocks7`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `fc_sessions`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `fc_sessions`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `fc_sessions`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_notifications`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_notifications`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_notifications`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Disk full (/tmp/#sql_68d_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '-'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('- ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('- ',start) AS block_start, CONCAT('- ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '4'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('- ',`start`) AS block_start, CONCAT('- ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '4'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '-'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('- ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('- ',start) AS block_start, CONCAT('- ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '4'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('- ',`start`) AS block_start, CONCAT('- ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '4'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '2025-04-13'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-04-13 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-04-13 ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('2025-04-13 ',start) AS block_start, CONCAT('2025-04-13 ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '0'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('2025-04-13 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-13 ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('2025-04-13 ',`start`) AS block_start, CONCAT('2025-04-13 ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '0'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('2025-04-13 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-13 ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL AND t.id IN (SELECT tour_id FROM fc_tour_times WHERE time >= '00:00:00') AND t.last_second = 1 GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '2025-04-14'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-04-14 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-04-14 ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('2025-04-14 ',start) AS block_start, CONCAT('2025-04-14 ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '1'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('2025-04-14 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-14 ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('2025-04-14 ',`start`) AS block_start, CONCAT('2025-04-14 ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '1'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('2025-04-14 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-14 ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL AND t.id IN (SELECT tour_id FROM fc_tour_times WHERE time >= '00:00:00') AND t.last_minute = 1 GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '2025-04-15'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-04-15 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-04-15 ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('2025-04-15 ',start) AS block_start, CONCAT('2025-04-15 ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '2'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('2025-04-15 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-15 ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('2025-04-15 ',`start`) AS block_start, CONCAT('2025-04-15 ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '2'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('2025-04-15 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-04-15 ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL AND t.id IN (SELECT tour_id FROM fc_tour_times WHERE time >= '00:00:00') AND t.last_minute = 1 GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '-'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('- ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('- ',start) AS block_start, CONCAT('- ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '4'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('- ',`start`) AS block_start, CONCAT('- ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '4'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '-'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('- ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('- ',start) AS block_start, CONCAT('- ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '4'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('- ',`start`) AS block_start, CONCAT('- ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '4'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL GROUP BY t.id ORDER BY final_price ASC LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
Buckingham Palace and Change of Guard Walking Tour | Evolved Guide
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW COLUMNS FROM `wp_aioseo_posts`
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (8)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.menu_order ASC
WordPress database error: [Disk full (/tmp/#sql_68d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (493)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.menu_order ASC
WordPress database error: [Disk full (/tmp/#sql_68d_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT DISTINCT t.*,
tp.price AS price,
ROUND(IF(t.discount = 0,tp.price,tp.price*(1 - t.discount/100)),2) AS final_price,
t.id as rating
FROM fc_tours t
JOIN fc_users u ON u.id = t.user_id AND u.state = 2
JOIN fc_tour_times tt ON tt.tour_id = t.id
LEFT JOIN (
SELECT user_id, start, end, lx, ly
FROM fc_guide_calendar
WHERE DATE(start) = '-'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('- ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gc.end, INTERVAL
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
)
LEFT JOIN (
SELECT user_id, CONCAT('- ',start) AS block_start, CONCAT('- ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '4'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(gdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
LEFT JOIN (
SELECT tour_id, CONCAT('- ',`start`) AS block_start, CONCAT('- ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '4'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('- ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('- ',tt.time) < DATE_ADD(tdb.block_end, INTERVAL
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
)
JOIN fc_tour_prices tp ON tp.tour_id = t.id WHERE t.state = 2 AND t.approve = 1 AND t.route_id IN (5633) AND t.state = 2 AND gc.user_id IS NULL AND gdb.user_id IS NULL AND tdb.tour_id IS NULL GROUP BY t.id LIMIT 0,100
0
Tours
0
Languages
Choose a Buckingham Palace and Change of Guard Walking Tour and get inside one of the most beautiful royal palaces in the world, Buckingham Palace.
Heart of the British monarchy, Buckingham Palace is a still active palace. Consisting of 755 rooms and 20 hectares of parkland, the palace is located in the heart of the Westminster district and since 1837 has been the residence of the English royal family.
With the help of a local expert guide you will enter the official residence of Queen Elizabeth II.
Explore the otherwise inaccessible environments, such as the State Apartments, the best treasures of the Royal Collection with paintings by Rubens, Canaleto, Poussin, and sculptures by Canova.
Stroll through the beautiful and colorful gardens of the Royal Palace, an oasis in central London that will leave you breathless. Exotic plantations, colorful and all kinds of flowers will open in front of your eyes and you will be left speechless.
Are you ready for an extraordinary show?
Then let yourself be fascinated by the change of the English guard who is entrusted with the security of Buckingham Palace. It is a very ancient tradition that dates back to 1660 and that will surely surprise you.
The Buckingham Palace and Change of Guard Walking Tour?will give you the opportunity to listen to the band that will accompany the royal guard to the main entrance of Buckingham Palace.
If you’re lucky, the band can even play a song!
On our Evolved Guide platform, Buckingham Palace and Change of Guard Walking Tour?is customized by each of our tourist guides: for itineraries, duration and offer prices. Search among the proposals and choose a tourist guide for you!
Return with a unique experience of a Buckingham Palace and Change of Guard Walking Tour with your Certified Tourist Guide of Evolved Guide!
Here is a list of tours made by our guides. To check availability use the calendar on the top of this page
There are no available tours for this destination, with the selected criteria. Please, try to edit them to have more results.
