prefix '/en/collections' => sub {
    get '/:link' => sub {
        my $link          = params->{'link'};
	#print Dumper $link;
my $sql = <<'SQL';
                  SELECT 
                      imgf,
                      long_i,
                      status_prod,
                      name_prod,
                      name_cat,
                      name_col
                 FROM products,
                      categories,
                      collections
               WHERE products.fk_cat = ?
                  AND products.fk_col = ?
                  AND link_col = ? 
SQL
    my $sth = database->prepare($sql);
    #print Dumper $link; # is okay
    $sth->execute( 'categories.id_cat', 'collections.id_col', $link );
     template 'col-m',
          {
            have_text_markdown => $have_text_markdown,
            bigprodlist        => $sth->fetchall_arrayref( {} )
          },
          { layout => 'pin' };
    };
};