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 database selected


  • 1 Results Found

Orkney Smokehouse

Orkney Smokehouse
Hits 1139

Orkney Smokehouse supplies smoked salmon produce by mail order with a full price list and fish catalogue available through the website.