WordPress database error: [Disk full (/tmp/#sql_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_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_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_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-05-05'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-05-05 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-05-05 ',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-05-05 ',start) AS block_start, CONCAT('2025-05-05 ',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-05-05 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-05 ',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-05-05 ',`start`) AS block_start, CONCAT('2025-05-05 ',`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-05-05 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-05 ',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.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 >= '14:00:00') AND t.last_second = 1 GROUP BY t.id LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_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-05-06'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-05-06 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-05-06 ',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-05-06 ',start) AS block_start, CONCAT('2025-05-06 ',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-05-06 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-06 ',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-05-06 ',`start`) AS block_start, CONCAT('2025-05-06 ',`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-05-06 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-06 ',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.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 LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_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-05-07'
) gc ON (
gc.user_id = t.user_id
AND gc.start < DATE_ADD(CONCAT('2025-05-07 ',tt.time), INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(gc.lx - 0,2) + POW(gc.ly - 0,2)))) MINUTE)
AND CONCAT('2025-05-07 ',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-05-07 ',start) AS block_start, CONCAT('2025-05-07 ',end) AS block_end
FROM fc_guide_day_blocks
WHERE day = '3'
) gdb ON (
gdb.user_id = t.user_id
AND gdb.block_start < DATE_ADD(CONCAT('2025-05-07 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-07 ',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-05-07 ',`start`) AS block_start, CONCAT('2025-05-07 ',`end`) AS block_end
FROM fc_tour_day_blocks
WHERE day = '3'
) tdb ON (
tdb.tour_id = t.id
AND tdb.block_start < DATE_ADD(CONCAT('2025-05-07 ',tt.time),INTERVAL t.duration +
30*(1 + ROUND(SQRT(POW(0,2) + POW(0,2)))) MINUTE)
AND CONCAT('2025-05-07 ',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.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 LIMIT 0,100
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_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.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
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value IN ('9256') )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_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.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
WordPress database error: [Disk full (/tmp/#sql_3dd_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_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
Pisa | Evolved Guide
WordPress database error: [Disk full (/tmp/#sql_3dd_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_3dd_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_3dd_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_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY RAND()
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
0
Experiences
0
Guides
Best Guided Tour with Best Private Tour Guides in Pisa
With Evolved Guides you will be able to visit your favorite cities and their beauties exclusively, accompanied by the experience and the professionalism of our private tour guides, making your tour personalized and unforgettable. Go back home with the unique experience of your Private Tour Guide Certified Evolved Guide.
Evolved Guide is a professional platform for online booking of private tour guides in the world.
Works of art, monuments and sites have a history.
A history constructed by the people who wanted, created and lived them.
Let our guides tell you more about the history of the cities you will be visiting on our tours all over the world.
With us, you get the best private guided tours of destinations all over the world, for all tastes and budgets!
Select a guided tour of your preference and book the private tour guide for you: pictures of the guide, age, years of experience, specialization, users ratings, prices, deals, departure times, duration, and customized itinerary will help you in choosing the right one.
Guided Tour of Pisa
Visit Pisa, a city of Tuscany, by joining a Guided Tour of Pisa among those proposed by the authorizedlocalguides of EvolvedGuide.
There are various legends about the origins of Pisa, of which the most credited one narrates that the city was founded by some Greeks fleeing the homonymous Greek city of Pisa, which was destroyed in the 6th century BC. They therefore reached the banks of the Tyrrhenian Sea, and started the new settlement.
Pisa has good food and wine, but is especially famous for its most important square, PiazzadelDuomoofPisa, where there are threeveryimportantmonuments: the CathedralofPisa, built between 1063 and 1118 in PisanRomanesquestyle, the BaptisteryofSanGiovanni and the LeaningTower, bell tower of the XII century, which today is one of the most famous monuments in the world because of its characteristic inclination. For this reason, PiazzadelDuomo is also called PiazzadeiMiracoli (Square of Miracles) and is a UNESCOWorldHeritageSite.
Tourists from all over the world come to visit Pisa mainly to see the three monuments (or miracles) of PiazzadeiMiracoli on foot, since they are very close to each other. Joining a privatewalkingtour is the best choice for all those who want to combine a walk along the three monuments with the engaging commentary of an authorizedlocalguide.
Choose EvolvedGuide, the only platform where all the guidedtours in Pisa are customized by our tourguides. Choose the tour depending on the itinerary, duration, departure time, price and offers. Evaluate the various proposals of our tourguides and choose the option that’s right for you! Come home with a unique memory of the privatetourofPisa thanks to the Evolved–GuideAuthorizedPrivateGuide.
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY RAND()
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'town' AND wp_postmeta.meta_value = '9256' )
) AND wp_posts.post_type = 'route' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'continent','country','town','route' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','continent','country','town','route' ) )
GROUP BY wp_posts.ID
ORDER BY RAND()
WordPress database error: [Disk full (/tmp/#sql_3dd_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")] SELECT COUNT(T.id) as Tour_Count,U.*,T.id as T_ID FROM `fc_users` U
LEFT JOIN `fc_tours` T ON U.id = T.user_id
WHERE U.state = 2 AND U.user_type = 2
GROUP BY U.id
ORDER BY `Tour_Count` DESC
LIMIT 12