So I implemented a 3 table tag solution, als indicated in this classic post (so-called “Toxi” solution). Everthing works splendid, the only thing I struggle with is to get all items that are …
Tag: tags
Find all records that have X tags ordered by ascending time, BUT, the ones that match the most tags should be grouped first
Ok, this is a little hard to explain, and the title is not the best :/ but, basically, I have 3 tables and I’m trying to write a query that returns them with 2 levels of ordering. The first by the amount of “tags” each row has, and the second by when that row was created. And I would like
WordPress SQL: get post category and tags
I want to query Wordpress data stored in a MySQL database, in order to get a result with columns: post_id category comma-separated tags Expected output: +—————+———-+—————-+…
SQL query for multiple tag inclusion
I´m net very good in explaining this. But i do my best: I’ve made a tagging tool for people. Some people contains more then 1 tag, and i need to get those but dont know how to write the SQL query for multiple tag inclusion. I know you can’t write WHERE conditions like this: LOWER( peoples_tags.tag_id ) = ‘outside’ AND