query to url

More
13 years 4 months ago #12661 by fesghel
query to url was created by fesghel
Hi,
Look, such a url:
com_flexicontent&view=category&cid=13
that shows category items for category 13, apparently equals to such query in db:
SELECT i.title
FROM #_content i
RIGHT(LEFT or INNER) JOIN #_flexicontent_cats_item_relations rel ON rel.itemid = i.id
WHERE rel.catid =13

The question is: What's the equal url for this query:
SELECT i.title
FROM #_content i
RIGHT(LEFT or INNER) JOIN #_flexicontent_cats_item_relations rel ON rel.itemid = i.id
WHERE rel.catid =4
?
Or: How can I show such a query in the web? Any suggestions?
*Both categories are assigned to same template.

Thanks
OR rel.catid =13

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.266 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline