SELECT * FROM PostLinks pl JOIN Posts as tp ON tp.Id = pl...

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 *
FROM PostLinks pl
JOIN Posts as tp ON tp.Id = pl.PostId
JOIN Posts as mp ON mp.Id = pl.RelatedPostId
WHERE pl.LinkTypeId = 3
ORDER BY pl.CreationDate DESC

Enter Parameters

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