Join the Discussion

Interview with me on BBC

Posted by: Freediver81, Replies: 13

One of my favourite songs....

Posted by: hyeparis, Replies: 1

High Altitude Diving???

Posted by: harbour seal, Replies: 3

Danger of Dying?

Posted by: Whopperhead, Replies: 3

Spearfishing in Portugal

Posted by: MCerieiro, Replies: 35

Is there any countries that u dont need spearfishing licence

Posted by: phuketfreediver, Replies: 32

		SELECT
			a.id,

			UNIX_TIMESTAMP(a.date) AS date,

			a.title,

			a.rating,

			a.blurb,

			o.name,

			o.email,

			i.path,

			c.id AS cid,

			c.name AS cname

		FROM

			article a,

			user o

		LEFT OUTER JOIN

			images i

			ON (o.photo = i.id),

			art_cat ac,

			category c,

			category c2

		WHERE

			a.owner = o.id

		AND

			a.publishstate = 3

		AND

			ac.aid = a.id

		AND

			c2.id = ac.cid

		AND

			c.id = c2.parentid

		AND

			c.visible & 1

		ORDER BY

			a.date DESC,

			a.id

		LIMIT 12