----
               WHERE products.fk_cat = categories.id_cat
                  AND products.fk_col = collections.id_col
                  AND collections.link_col = ? 
SQL
    my $sth = database->prepare($sql);
    #print Dumper $link; # is okay
    $sth->execute( $link );
----