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
How to register

How to register

Wednesday, March 14th, 2012

Registering

If you would like to list your business, first you must register as a user, to do this, simply click on the ‘Add Listing’ icon to the top-right of the website, or click here.

Click on ‘Click here to register a new account’. Here enter your desired username (we recommend you use your businesses name) and a valid email address (we sent you login details here). Click ‘Submit’ and we will send you your login details. It is recommend that you change your password later on.

Check your email and after a few minutes you should receive an email from us with your username and password, enter them and this will take you to your account page from where you can add, modify and delete any of your listings.

We suggest that you change your assigned password to something a little easier to remember, to do this, click the ‘change my password’ link in the ‘My Account’ section.

Comments are closed.