Sql запрос JOIN и LIMIT - Разработка расширений для Joomla 3.x

SELECT t.`title`, r.`title`
FROM `nr5p8_turism_tour` AS `t`
left Join `nr5p8_turism_route` AS `r` ON r.`id`=t.`route_id`
order By r.`id`

SELECT t.`title`,
(SELECT r.`title` FROM `nr5p8_turism_route` AS `r` WHERE t.`title`=r.`title` LIMIT 5 ORDER BY r.`id`) AS r_title 
FROM `nr5p8_turism_tour` AS `t`

Select ta.alias, ta.id
    , tb.alias
From prefix_categories As ta
    Left Join   (
                Select tx1.catid, tx1.alias, tx1.id
                    , (Select Count(*)
                        From prefix_content As tx2
                        Where tx2.catid = tx1.catid
                            And tx2.id < tx1.id) As rank
                From prefix_content As tx1
                ) as tb
        On tb.catid = ta.id
            And tb.rank <= 2
WHERE
  ta.parent_id > 0
  AND ta.extension = 'com_content'