SELECT ar.id, ar.codigo, ar.familia, fam.familia AS familia_txt, web.slugify(fam.familia) as slug_fam, ar.tipo_unidad, ti.porcentaje AS iva , wa.nombre, wa.descripcion, wa.modo_empleo, wa.ingredientes, wa.conservacion, wa.presentacion , wad.descripcion AS descripcion_alternativa, wad.destacado , empresa_1.precio_articulo(ar.codigo, NULL) AS tvprecio , wa.gluten , wa.leche , wa.huevo , wa.pescado , wa.cacahuete , wa.soja , wa.sulfitos , wa.frutos_secos , wa.sesamo , wa.mostaza , wa.crustaceos , wa.altramuces , wa.apio , wa.moluscos , wa.fenilalanina , wa.fructosa , wa.lactosa FROM public.articulos AS ar INNER JOIN web.articulos AS wa ON ar.codigo = wa.codigo INNER JOIN web.articulos_dominios AS wad ON wad.codigo = wa.codigo INNER JOIN web.dominios AS wd ON wd.id = wad.id_dominio INNER JOIN web.familias AS fam ON (ar.familia::varchar =ANY(string_to_array(fam.familias_asociadas, ','))) INNER JOIN public.tipos_iva AS ti ON ar.tipo_iva = ti.codigo WHERE ar.baja IS NULL AND ar.marca = 1 AND wd.nombre = $1 AND empresa_1.precio_articulo(ar.codigo, NULL) > 0 AND (fam.publicado = 1 OR ar.codigo IN ('ES06', 'ES11', 'ES12', 'ES14')) ORDER BY ar.codigo LIMIT $2 OFFSET $3;array(3) { [0]=> string(21) "www.essentialsport.es" [1]=> int(30) [2]=> float(0) }