SQL query failed: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 2167. query was: SELECT r.link_id, r.title, r.comments, r.rank, to_char(r.submit_date,'MM-DD-YY') as fmt_submit_date, r.helpful_count, r.total_count, r.review_id, r.username, b.name || ' ' || p.title AS product_title, CASE WHEN (cp.brand_id IS NULL OR p.inactive) THEN 1 ELSE 0 END AS inactive, 'outlet' as catalog_id FROM review r JOIN public.products p ON r.link_id = p.sku LEFT JOIN products cp ON r.link_id = cp.sku LEFT JOIN brand b ON p.brand_id = b.brand_id WHERE username = '' AND review_status_id = 3 AND anonymous <> 1 ORDER BY ((2 * helpful_count) - total_count) DESC, total_count DESC, submit_date DESC, review_id DESC