$other_date = "CAST( $other_date AS TIMESTAMP )" if driver_name =~ /^Pg/i;
$other_date = str2time_sql. $other_date. str2time_sql_closing;
+my $in = concat_sql([ '?', "'_IN'" )
+my $out = concat_sql([ '?', "'_OUT'" )
+
my $sql = "
SELECT DISTINCT srv_date, srv_time FROM srvexport
WHERE NOT EXISTS (
SELECT 1 FROM srvexport AS other
- WHERE other.serviceid IN ( ?||'_IN', ?||'_OUT')
+ WHERE other.serviceid IN ( $in, $out )
AND ABS( $_date - $other_date ) <= 60
)
ORDER BY id