SQL help - can this be done with one query?

[eluser]Sarfaraz Momin[/eluser]
Hey Grant,
I donno if the following would help you much but I had a similar situation and I found a way to get pass it. The query is as follows

MarterLinks = tags
CountLinks = item_tag

Code:

select masterLinks.masterLinkID, masterLinks.postUser,".
"masterLinks.postPic,masterLinks.postLink,".
"masterLinks.postID,masterLinks.postText,".
"masterLinks.postDate,masterLinks.postContent,masterLinks.postTitle,".
"substring(max(concat(countLinks.published,'|',countLinksID)),21) as countLinksID, ".
"count(countLinksID) as numCountLinks from masterLinks left join countLinks ".
"using(masterLinkID) group by masterLinkID order by masterLinkID;

You can add a simple userid in the where clause to get result based on users.

Have a good day !!!