WordPress database error: [Disk full (/tmp/#sql_68d_2.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 (5753) 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 (5753) 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 (5753) 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 (5753) 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 (5753) 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 (5753) 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 (5753) 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`
Edinburgh Castle 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 (5753) 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
Evolved Guide gives you the opportunity to spend your free time by joining one of the most significant Edinburgh CastleWalking Tour with a certified local guide who will be able to satisfy all your requests and needs.
Edinburgh Castle is the oldest fortress in the city and one of the most emblematic places in the whole of Scotland. The Castle rises on the hill of Castle Hill from which you can enjoy one of the most beautiful panoramas of the city.
Enter the castle and witness an ancient tradition dating back to 1861, the cannon shot of one o’clock. It will be the general of the Artillery to fire a cannon shot from the castle. You must know that once the cannon shot indicated the time to the sailors and the locals, like a modern tolling of bells.
With this Edinburgh CastleWalking Tour of Evolved Guide you enter one of Scotland’s largest and most beautiful fortifications. You will discover the 3000 years of history of Edinburgh Castle and its role in the formation and development of Scotland. Roman legionaries, the Angles, the princesses, the British, the Castle has a lively and lively history. James I, Maria di Guida, Maria Stuarda, John Knox are just some of the names that have marked the history of this land. Our certified guide will know how to catch your attention with the most compelling stories and court intrigues that have marked Edinburgh Castle.
Are you ready to go down to the basement? Through a faithful reconstruction of the prisons, you will be able to learn better, together with your local guide, what the conditions of the prisoners who lived imprisoned in the cells of the castle were.
And then the Royal Palace, the Hall of Honor, the Royal Arsenare and the Church of St. Mary, will be a dive into the past that you will not forget. Did you know that in the Royal Palace, in one of its rooms, Maria Stuarda‘s son Giacomo IV was born? Around his birth, however, there is a macabre story because it is said that in reality small bones were discovered behind a wall, and it seems that the one who was crowned king of Scotland, as the legitimate son of Mary, was actually an imposter and that the true James IV had been killed when he was still in swaddling clothes.
It’s just a legend, but who can ever find out the truth?!
On our Evolved Guide platform, Edinburgh CastleWalking 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!
Come back with a unique experience of the Edinburgh CastleWalking Tour with your Licensed 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.
