FAQ  •  Register  •  Login

Linking the media_item table to the genre table

<<

martianw

Streaming enthusiast

Posts: 28

Joined: Fri Dec 14, 2012 2:49 pm

Post Sun Mar 15, 2020 8:21 am

Linking the media_item table to the genre table

Hi, I'm trying to write some simple SQL queries to run within the Derby ij interpretter to do simple things like list all movies in the database. I have the basics working fine, but cannot see how to join the media_item table to the genre table. I understand that the database schema may change across releases and am OK with accepting that risk. This is just for me.

Any suggestions, gratefully received.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17212

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Tue Mar 17, 2020 9:05 am

Re: Linking the media_item table to the genre table

there is a table GENRE_ITEM which links genre_id and media_item_id.
<<

alicelamm1

Serviio newbie

Posts: 1

Joined: Mon Feb 01, 2021 7:37 am

Post Mon Feb 01, 2021 7:46 am

Re: Linking the media_item table to the genre table

I have the basics proessays working fine, but cannot see how to join the media_item table to the genre table.

Hi,
You'll need to join the media table to the Media_Genre table and the genre table to the Media_Genre table.

Return to Third-party tools integration

Who is online

Users browsing this forum: No registered users and 12 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.