Staphylococcus aureus - Advanced Query Form

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

idstrainother_namestcountryregionyearage_yrage_mthsexdiseasesourcceepidemiologyspeciesoxsaumethicillinvancomycinspa_typereferencecommentssendercuratordate_entereddatestampusernamerefarccaroeglpfgmk_pta_tpi_yqilbaps

SELECT * FROM profiles LEFT OUTER JOIN sts ON profiles.st = sts.ref WHERE [st]=57 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