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 (11403) 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 (11403) 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 (11403) 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 (11403) 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 (11403) 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 (11403) 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 (11403) 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`
Colombo city tour | Evolved Guide
WordPress database error: [Disk full (/tmp/#sql_68d_3.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 (11403) 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
Did you chose to visit Colombo, Sri Lanka? Great idea, you will not regret it!
Colombo, the second capital of Sri Lanka, offers many attractions that are worth a visit. What are the best things to do in Colombo? Here, you will find numerous Buddhist; Hindu and Catholic themples, as well as museums and parks. This great mix of cultures and religions is the consequence of the ancient Dutch; Portuguese and British settlement in this area.
– Start your trip from the Gangaramaya Temple, just a few minutes from Beira Lake.
– Another pride of Sri Lanka is the National Museum, the largest museum in the state, founded in 1877.
– The Pettah floating market is one of the most unusual in Colombo city. Shop for fruits and vegetables, as well as clothing; jewelry, and electronics.
– For animal lovers, you can?t miss the National Zoo, better known as the Dehivala Zoo.
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.
