FROM glmmarticu a LEFT JOIN glmmtemasi t ON a.tema_interes = t.codigo LEFT JOIN glmmeanpor p ON a.ean = p.ean LEFT JOIN glmmforlib f ON a.tipo_formato = f.codigo LEFT JOIN gwarticu_info_alternativa ia ON a.codigo = ia.cod_libro LEFT JOIN glmmeditor e ON a.editorial = e.codigo LEFT JOIN glmlrefbie r ON a.codigo = r.articulo WHERE 1 = 1 AND MATCH (autor) AGAINST ('martin*' IN BOOLEAN MODE) AND MATCH (autor) AGAINST ('padgett*' IN BOOLEAN MODE) AND a.visible = 'S'