[silverd]

Little stumped.

I want to display all posts that contain an [IMG] tag and are not in a deleted thread.

Something like:

SELECT * FROM post WHERE pagetext='[img]' WHERE thread.threadid=post.threadid AND thread.visible=1

--------------- Added [DATE]1307553941[/DATE] at [TIME]1307553941[/TIME] ---------------

still trying

SELECT * FROM post WHERE pagetext LIKE '%[img]%' WHERE post.threadid=thread.threadid AND thread.visible = 1