Staphylococcus aureus - Advanced Query Form

Combine searches with:	AND OR
idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernameField26Field27Field28Field29Field30Field31Field32Field33Field34Field35refarccaroeglpfgmk_pta_tpi_yqil	= > < NOT LIKE
idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernameField26Field27Field28Field29Field30Field31Field32Field33Field34Field35refarccaroeglpfgmk_pta_tpi_yqil	= > < NOT
idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernameField26Field27Field28Field29Field30Field31Field32Field33Field34Field35refarccaroeglpfgmk_pta_tpi_yqil	= > < NOT
idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernameField26Field27Field28Field29Field30Field31Field32Field33Field34Field35refarccaroeglpfgmk_pta_tpi_yqil	= > < NOT

idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernameField26Field27Field28Field29Field30Field31Field32Field33Field34Field35refarccaroeglpfgmk_pta_tpi_yqil

SELECT * FROM profiles LEFT OUTER JOIN sts ON profiles.st = sts.ref WHERE [st]='47' AND (id in (SELECT profileID FROM user_profiles up WHERE up.userID IN (-1)) ) ORDER BY id;

To view comma delimited file of results click here