SELECT * FROM t1 b, t2 ib  WHERE ib.isbn_id IN (SELECT id FROM t3 WHERE isbn = :string  AND b.id = ib.book_id ORDER BY b.name';

$search = $this->collection['db']->prepare($sql);
$search->bindValue(':string', '966-06-0023-2', PDO::PARAM_STR);
$search->execute();

ERROR: cannot cast ISBN to EAN13 for number: "966-06-0023-2"

SELECT id, name, year, page, letter, city,
                                                (SELECT
                                                        array_to_string(public.array_accum(id || '#::#' || name || '#::#' || letter || '#::#' || main), '#||#')
                                                        FROM (SELECT a.id, a.name, ba.main
                                                                        FROM
                                                                                library.authors a,
                                                                                library.relation_books_authors ba
                                                                        WHERE
                                                                                a.id = ba.author_id
                                                                        AND
                                                                                ba.book_id = b.id
                                                                                ORDER BY ba.position
                                                                ) AS subauth) AS authors,
                                                                (SELECT
                                                                        array_to_string(public.array_accum(id || '#::#' || name || '#::#' || letter || '#::#' || main), '#||#')
                                                                        FROM (SELECT p.id, p.name, bp.main
                                                                                FROM
                                                                                        library.publishings p,
                                                                                        library.relation_books_publishings bp
                                                                                WHERE
                                                                                        p.id = bp.publishing_id
                                                                                AND
                                                                                        bp.book_id = b.id
                                                                                        ORDER BY bp.position
                                                                ) AS subpubl) AS publishings,
                                                                (SELECT
                                                                        array_to_string(public.array_accum(isbn || '#::#' || main || '#::#' || note || '#::#' || position || '#::#' || publishing), '#||#')
                                                                FROM (SELECT
                                                                                CASE
                                                                                        WHEN b.year <  2007 
                                                                                        THEN  ts_headline(i.isbn::isbn::varchar, plainto_tsquery(isbn($ 1 )::varchar), 'StartSel="<b style=""color:#FF0000"">", StopSel="</b>"')
                                                                                        ELSE ts_headline(i.isbn::varchar, plainto_tsquery(isbn13($ 1 )::varchar), 'StartSel="<b style=""color:#FF0000"">", StopSel="</b>"')
                                                                                        END AS isbn,
                                                                                bi.main, bi.position, bi.note,
                                                                                (library.convert_isbn_id_to_publishing_name(i.id)) AS publishing
                                                                                        FROM
                                                                                                library.isbn i,
                                                                                                library.relation_books_isbn bi
                                                                                        WHERE
                                                                                                i.id = bi.isbn_id
                                                                                        AND
                                                                                                bi.book_id = b.id
                                                                                        ORDER BY bi.position
                                                                        ) AS subisbn) AS isbn,
                                                                        (SELECT
                                                                                id || '#::#' || code || '#::#' || name
                                                                        FROM
                                                                                 library.udc u,
                                                                                 library.relation_books_udc bu
                                                                                WHERE u.id = bu.udc_id AND bu.book_id = b.id) AS udc
                                                         FROM library.books b, library.relation_books_isbn ib
                                                                WHERE ib.isbn_id IN (SELECT id FROM library.isbn WHERE isbn = $ 1 )
                                                                        AND b.id = ib.book_id ORDER BY b.name