String[561] (SELECT p."LIBRARY_ID", p."TITLE", p."SUBTITLE", p."IMAGE", p."PARENT_ID", p."MASK", p."SALE_SKU", p."EPISODE", p."GUIDE_DESCRIPTION", p."SHORT_DESCRIPTION", (select l_tmp."WEBSITE_LOCAL" from "OPTION1_library" l_tmp, "_XAVIOUR_page" p_tmp WHERE l_tmp."WEBSITE_LOCAL" = p_tmp."URL" and p_tmp."ACTIVE" = true and l_tmp."LIBRARY_ID"=p."LIBRARY_ID") as "WEBSITE_LOCAL" FROM "OPTION1_library" p WHERE p."PUBLISHED" = true AND p."SALE_TYPE"='online' ORDER BY p."TITLE", p."SUBTITLE"  [nativecode=ERROR:  more than one row returned by a subquery used as an expression])