111Query:
SELECT * FROM tnladb1_posts
LEFT JOIN tnladb1_term_relationships ON(tnladb1_posts.ID = tnladb1_term_relationships.object_id)
LEFT JOIN tnladb1_term_taxonomy ON(tnladb1_term_relationships.term_taxonomy_id = tnladb1_term_taxonomy.term_taxonomy_id)
WHERE tnladb1_term_taxonomy.taxonomy = 'news'
AND tnladb1_posts.post_status = 'publish'
AND tnladb1_posts.post_content REGEXP '[[:<:]]scartho[[:>:]]' OR tnladb1_posts.post_title REGEXP '[[:<:]]scartho[[:>:]]' OR tnladb1_posts.post_title REGEXP '[[:<:]]scartho[[:>:]]' OR tnladb1_posts.post_content REGEXP '[[:<:]]scartho[[:>:]]'
ORDER BY tnladb1_posts.post_title ASC
LIMIT 4
4Array PAGEPOSTS = Array
scartho Are mince pies too boozy for children? - NLA
