http%3A%2F%2Fgalenet.galegroup.com%2Fservlet%2FMOME%3Faf%3DRN%26ae%3DU108023617
Editar
SELECT COUNT(*) as count FROM journals INNER JOIN proveedores ON journals.id=proveedores.id WHERE (Proveedor='Latino') AND Titulo LIKE"A%" AND IFC!="0";
SELECT COUNT(*) as count FROM journals INNER JOIN proveedores ON journals.id=proveedores.id WHERE (Url_rev LIKE"%.ar/%" OR Url_rev LIKE"%.ar/" OR Url_rev LIKE"%.ar") OR (Url_rev LIKE"%.bo/%" OR Url_rev LIKE"%.bo/" OR Url_rev LIKE"%.bo") OR (Url_rev LIKE"%.br/%" OR Url_rev LIKE"%.br/" OR Url_rev LIKE"%.br") OR (Url_rev LIKE"%.cl/%" OR Url_rev LIKE"%.cl/" OR Url_rev LIKE"%.cl") OR (Url_rev LIKE"%.co/%" OR Url_rev LIKE"%.co/" OR Url_rev LIKE"%.co") OR (Url_rev LIKE"%.cr/%" OR Url_rev LIKE"%.cr/" OR Url_rev LIKE"%.cr") OR (Url_rev LIKE"%.cu/%" OR Url_rev LIKE"%.cu/" OR Url_rev LIKE"%.cu") OR (Url_rev LIKE"%.do/%" OR Url_rev LIKE"%.do/" OR Url_rev LIKE"%.do") OR (Url_rev LIKE"%.ec/%" OR Url_rev LIKE"%.ec/" OR Url_rev LIKE"%.ec") OR (Url_rev LIKE"%.gt/%" OR Url_rev LIKE"%.gt/" OR Url_rev LIKE"%.gt") OR (Url_rev LIKE"%.hn/%" OR Url_rev LIKE"%.hn/" OR Url_rev LIKE"%.hn") OR (Url_rev LIKE"%.mx/%" OR Url_rev LIKE"%.mx/" OR Url_rev LIKE"%.mx") OR (Url_rev LIKE"%.ni/%" OR Url_rev LIKE"%.ni/" OR Url_rev LIKE"%.ni") OR (Url_rev LIKE"%.pa/%" OR Url_rev LIKE"%.pa/" OR Url_rev LIKE"%.pa") OR (Url_rev LIKE"%.pe/%" OR Url_rev LIKE"%.pe/" OR Url_rev LIKE"%.pe") OR (Url_rev LIKE"%.py/%" OR Url_rev LIKE"%.py/" OR Url_rev LIKE"%.py") OR (Url_rev LIKE"%.sv/%" OR Url_rev LIKE"%.sv/" OR Url_rev LIKE"%.sv") OR (Url_rev LIKE"%.uy/%" OR Url_rev LIKE"%.uy/" OR Url_rev LIKE"%.uy") OR (Url_rev LIKE"%.ve/%" OR Url_rev LIKE"%.ve/" OR Url_rev LIKE"%.ve") AND Titulo LIKE"A%" AND IFC!="0";
Todo esta super bien