|
Posted by dikkuuhh on 05/02/07 09:09
At the moment i have this query:
SELECT number, COUNT( * ) as count ' .
FROM visit ' .
RIGHT JOIN visitHit ON ( visitHit.visitId = visit.id ) AND ( type
= "link" )
WHERE ( brochureId = 57 )
GROUP BY number
ORDER BY number
I get a list of the numbers of the links a have with the number of
times it's clicked.
Now i don't wanna know this but the URL of the link, that's in another
table (pageElement.link)
Do i need a double join query or not? Can somebody help me out with an
example?
Navigation:
[Reply to this message]
|