Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Re: [MJB] Last x voted: Edit Log

Hi,

Do you get the right results with this query? (in SQL Monitor)

Code:
SELECT DISTINCT(glinks_ClickTrack.LinkID) FROM glinks_ClickTrack  
	    JOIN  glinks_Links ON glinks_ClickTrack.LinkID = glinks_Links.ID 
            WHERE  ClickType = "Hits" 
	    ORDER BY glinks_ClickTrack.Created LIMIT 5;

If so, lemme know - and I'll write a little global to get the results for ya :)

UPDATE - that query doesn't do quite what I was expecting. Need a little time to look at other options =) (best it is can be all done in a single query, as its nicer on the server)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Products: Gossamer Links: Development, Plugins and Globals: Re: [MJB] Last x voted: Edit Log

Here is the list of edits for this post

Last edited by:

Edit Log: