WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67df.MAI' (Errcode: 30 "Read-only file system")]SHOW FULL COLUMNS FROM `wp_options`
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67e1.MAI' (Errcode: 30 "Read-only file system")]SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67e2.MAI' (Errcode: 30 "Read-only file system")]SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67e3.MAI' (Errcode: 30 "Read-only file system")]SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67e4.MAI' (Errcode: 30 "Read-only file system")]SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67e9.MAI' (Errcode: 30 "Read-only file system")]SELECT COUNT(DISTINCT CONCAT(LOWER(property_name), '|', LOWER(region))) FROM wp_everge_property_index WHERE post_status = 'publish' AND merchant_source = 'sykes' AND latitude IS NOT NULL AND longitude IS NOT NULL AND latitude BETWEEN 54.287689 AND 54.648049 AND longitude BETWEEN -3.380461 AND -2.760389
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-236772-25bc1-67ed.MAI' (Errcode: 30 "Read-only file system")]
SELECT terms.slug, COUNT(DISTINCT matched.dedup_key) AS feature_count
FROM (
SELECT MIN(post_id) AS post_id,
CONCAT(LOWER(property_name), '|', LOWER(region)) AS dedup_key
FROM wp_everge_property_index
WHERE post_status = 'publish' AND merchant_source = 'sykes' AND latitude IS NOT NULL AND longitude IS NOT NULL AND latitude BETWEEN 54.287689 AND 54.648049 AND longitude BETWEEN -3.380461 AND -2.760389
GROUP BY dedup_key
) AS matched
INNER JOIN wp_term_relationships AS relationships
ON relationships.object_id = matched.post_id
INNER JOIN wp_term_taxonomy AS taxonomy
ON taxonomy.term_taxonomy_id = relationships.term_taxonomy_id
AND taxonomy.taxonomy = 'property_features'
INNER JOIN wp_terms AS terms
ON terms.term_id = taxonomy.term_id
GROUP BY terms.slug