Thank you, but for a long time, now i can do it and save $3 (!!!).
Looking for Db.helper.php add this line : INNER JOIN #__content_frontpage AS f ON f.content_id = a.id
Before
- Code: Select all
ELSE a.id END AS art_slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias)
ELSE c.id END AS cat_slug
FROM
#__content AS a
INNER JOIN
#__categories AS c ON c.id = a.catid
After
- Code: Select all
ELSE a.id END AS art_slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias)
ELSE c.id END AS cat_slug
FROM
#__content AS a
INNER JOIN #__content_frontpage AS f ON f.content_id = a.id
INNER JOIN
#__categories AS c ON c.id = a.catid
Now you can use this code if you wanna save some money.