Interesting
$query_getUserNews = sprintf("SELECT * FROM news_articles WHERE news_articles.news_local IN (SELECT localRetailer FROM users WHERE userID = %s)", GetSQLValueString($userIDv_getUserNews, "int"));
$getUserNews = mysql_query($query_getUserNews, $datab2) or die(mysql_error());
$row_getUserNews = mysql_fetch_assoc($getUserNews);
$totalRows_getUserNews = mysql_num_rows($getUserNews);
Gives me an exact match.
i.e. the news article row has "246, 51, 122, 127, 29, 70" in its news_local field
it only come up as a result when the user row has the exact "246, 51, 122, 127, 29, 70" in its local_stores field.
I will continue to investigate the IN command