I want to dump tags by order from the #__tags database table, but there is no order column in the structure, though there is ordering capability in the tags component.
I've viewed the relevant files from com_tags in reference to ordering, but I have not been able to define the logic to apply to my query statement.
SELECT p.alias,p.title,t.title AS tagname FROM #__content p,#__tags t,#__contentitem_tag_map m WHERE m.tag_id = t.id AND m.content_item_id = p.id AND p.catid = 27 ORDER BY t.tagorder ASC //this column not included in table
I don't see any column that handles ordering. How can I get the ordering as arranged in the component's tags view page?