SELECT cs.platform,
     (SELECT COUNT(*) FROM general_list as loc WHERE loc.platform=cs.platform) as indexed,
     (SELECT COUNT(*) FROM cs.table     as loc WHERE loc.platform=cs.platform) as sandbox
FROM states, (
    SELECT platform, table
    FROM states
    WHERE visible=1
) as cs