delete from lh_projects_projectloci where projectidfk = delete from lh_projects_users_email where useridfk = delete from lh_projects_users where useridfk = delete from lh_projects_users where projectidfk = select p.id, p.name from lh_projects p, lh_projects_users_email pe, lh_users u where p.id = pe.projectidfk and pe.useridfk = u.id and u.username = select p.id, p.name from lh_projects_projectloci pl, lh_projectloci p where pl.projectidfk in () and pl.projectlociidfk = p.id select p.id, p.name, count(i.id) as numissues, p.mailserver, p.mailusername, p.mailpassword, p.mailemailaddress from lh_projects p left join lh_issues i on p.id = i.projectidfk group by p.id, p.name, p.mailserver, p.mailusername, p.mailpassword, p.mailemailaddress order by p.name asc select u.emailaddress from lh_projects_users_email pe , lh_users u where pe.projectidfk = and pe.useridfk = u.id select u.id, u.username, u.name from lh_projects_users pu, lh_users u where pu.projectidfk = and pu.useridfk = u.id select p.id, p.name, p.mailserver, p.mailusername, p.mailpassword, p.mailemailaddress from lh_projects p where p.mailserver <> '' select p.id, p.name from lh_projects p , lh_projects_users pu , lh_users u where p.id = pu.projectidfk and pu.useridfk = u.id and u.username = order by p.name asc insert into lh_projects_users_email(projectidfk, useridfk) values(,) insert into lh_projects_projectloci(projectidfk, projectlociidfk) values(,) insert into lh_projects_users(projectidfk, useridfk) values(,) insert into lh_projects_users(projectidfk, useridfk) values(,)