FROM glmrlibtem te, glmmtemasi t, glmmarticu a 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 te.tema IN ('007006') AND te.articulo = a.codigo AND te.tema = t.codigo  AND tipo_articulo like 'L%'  AND a.visible = 'S' <br><br>