dbCount, er2 = dbmap.SelectInt("SELECT COUNT(*) AS N FROM (SELECT av.id FROM Table av LEFT JOIN Table2 dt ON dt.`app_id` = av.`app_id` LEFT JOIN Table3 a ON a.`id` = av.`app_id` WHERE dt.`user_id` IN (?) OR a.`org_id` IN (?) GROUP BY av.id LIMIT ? OFFSET ?) tmp", user_id, org_ids, limit, offset)
user_id = 1000org_ids = 13444,12444,10333limit = 25offset = 0
Any idea why this returns no error or results in GO but when run directly on the database returns 1 result? There are no errors either.