TEST1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

SELECT T.Score, T.Id,  A.ParentId, T.Title, T.DisplayName, T.Location, T.AnswerCount, A.Body
FROM(
SELECT TOP 10 P.Id, P.Score, P.Title, U.DisplayName, U.Location, P.AnswerCount
FROM Posts P 
INNER JOIN Users U ON P.OwnerUserId = U.Id
WHERE PostTypeId = 1 AND U.Location LIKE '%Monterrey%'
ORDER BY Score ASC) T
INNER JOIN Posts A ON A.ParentId = T.Id

Enter Parameters

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