SQL ERROR: query=(
SELECT
'common' AS book_type,
pbs.book_section_id,
pbs.snippet,
b.id AS book_id,
b.name AS book_name,
b.year AS book_year,
b.series AS book_series,
b.link as book_link,
b.litres_link,
ba.id AS author_id,
ba.name AS author_name,
ba.link as author_link,
bst.pid as pid,
bs.link as section_link
FROM kartaslov.phrases p
JOIN kartaslov.phrase_book_section pbs
ON pbs.phrase_id = p.id
AND pbs.book_type = 'common'
JOIN kartaslov.books b
ON b.id = pbs.book_id
JOIN kartaslov.book_authors ba
ON ba.id = b.author_id
JOIN kartaslov.book_section_text bst
ON bst.id = pbs.book_section_text_id
JOIN kartaslov.book_sections bs
ON bs.id = bst.book_section_id
WHERE p.phrase = ?
LIMIT 0, 3
)
UNION ALL
(
SELECT
'classic' AS book_type,
pbs.book_section_id,
pbs.snippet,
cb.id AS book_id,
cb.name AS book_name,
cb.year AS book_year,
cb.series AS book_series,
cb.link as book_link,
NULL AS litres_link,
cba.id AS author_id,
cba.name AS author_name,
cba.link AS author_link,
cbst.pid as pid,
cbs.link as section_link
FROM kartaslov.phrases p
JOIN kartaslov.phrase_book_section pbs
ON pbs.phrase_id = p.id
AND pbs.book_type = 'classic'
JOIN kartaslov.classic_books cb
ON cb.id = pbs.book_id
JOIN kartaslov.classic_book_authors cba
ON cba.id = cb.author_id
JOIN kartaslov.classic_book_section_text cbst
ON cbst.id = pbs.book_section_text_id
JOIN kartaslov.classic_book_sections cbs
ON cbs.id = cbst.book_section_id
WHERE p.phrase = ?
LIMIT 0, 3
); err=Unknown column 'pbs.book_section_id' in 'SELECT'
SQL_ERR
16 2 — betydning, synonymer og topresultater fra Google/Yandex