SQL: SELECT distinct t.name FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN wp_posts p ON tr.object_id=p.id AND p.post_status='publish' WHERE `tt`.taxonomy='category'

No such file or directory
Welcome to Canaries Directory!

Welcome to Canaries Directory!

Tuesday, March 13th, 2012

Welcome to the latest addition to the Canaries Media group of website, Canaries Directory, a free directory of businesses and services in the Canary Islands.

To list your business or services in the Canary Islands free of charge, just click the ‘Add Listing’ button to the top-right of the site and that’s it!

If there is a category that you feel is missing on our list, we’d love to know about it, just drop us an email at info@canariesdirectory.com or, even better, just use the ‘Contact Us’ form and we’ll add your category!

Thanks!

Leave a Reply

*