Query pad

Posted in

#1 by ahahahahahahaha
2023-01-02 at 08:42		< report >Hi I noticed there is an images table on the query pad; is there a way to find the ids for all the images that are associated to a VN?Last modified on 2023-01-02 at 08:43
#2 by Draconyan
2023-01-02 at 09:48		< report >The table vn_screenshots contains the relations between VNs, screenshots and releases.

select vn.id, vn.title, vn_screenshots.*
from images
inner join vn_screenshots on vn_screenshots.scr = images.id
inner join vn on vn.id = vn_screenshots.id
where vn.id = 'v1'
Last modified on 2023-01-02 at 09:48
#3 by ahahahahahahaha
2023-01-02 at 20:04		< report >Thanks :)

Reply

You must be logged in to reply to this thread.