Select Code to Download

Select or download this

my $sth = $dbh->prepare( "SELECT * FROM Images 
    LEFT JOIN Regio ON Images.RegioID = Regio.RegioID
    LEFT JOIN Insula ON Images.InsulaID = Insula.InsulaID
    LEFT JOIN ImgThemes ON Images.ImageID = ImgThemes.ImageID
    LEFT JOIN Sources ON Images.SourceID = Sources.SourceID
    ORDER BY ImageName LIMIT $start,$numrows" );

Select or download this

-------         ---------      ----------
Regio           Images         ImgThemes
-------         ---------      ----------
...
                Publishers     ----------        |
                PublishYear    ThemeCategoryID >-|
                               CategoryName