[Chuck S]

Okay found it FIRST OFFICIAL BUG

FROM {$Globals['rp_db_prefix']}categories c
LEFT JOIN {$Globals['rp_db_prefix']}notify n ON (n.userid={$User['userid']} AND n.product=c.id AND n.type=1)
WHERE c.id=$cat";