/*select c.Text as [Highest Scored Comment], p.body as Post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

/*select c.Text as [Highest Scored Comment], p.body as Post
from 
(select TOP 1 PostId, Score, Text from comments
order by Score desc)c
join Posts p
on p.id = c.PostId
;*/



select count(*) from posts

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results