Hello, please look here. When the module generate the list, one of the item is generated several times!
The query that generates the list is:
SELECT a.id, a.title, a.description AS text, '' AS created, '2' AS browsernav, s.id AS secid, a.id AS catid,
CASE WHEN CHAR_LENGTH( a.alias )
THEN CONCAT_WS( ':', a.id, a.alias )
ELSE a.id
END AS slug
FROM jos_categories AS a
INNER JOIN jos_sections AS s ON s.id = a.section
LEFT JOIN jos_menu AS m ON m.componentid = a.id
WHERE a.published =1
AND s.published =1
AND a.access <=0
AND s.access <=0
AND a.section
IN ( 5 )
ORDER BY a.name DESC
LIMIT 0 , 20
What’s wrong with this?
