|
|
|
| Скажите, как можно оптимизировать запрос и укажите на ошибки.
запрос для joomla
SELECT a.*, UPPER(`metakey`) as metakey2,
b.id as bid, b.alias as balias, b.title as category,
c.alias as calias, d.self, d.tag, f.content_id
FROM #__content AS a
LEFT JOIN #__categories AS b ON a.catid = b.id
INNER JOIN #__sections AS c ON c.id = a.sectionid
LEFT JOIN #__tags AS d ON a.tags = d.self
INNER JOIN #__content_frontpage AS f ON a.id = f.content_id
{$where} ORDER BY a.created DESC LIMIT 0,10
|
| |
|
|