Query error: Subquery returns more than 1 row - Invalid query:
SELECT
b.*
, (
SELECT
ml.id_language
FROM
emmeti_com_languages AS l
LEFT JOIN
emmeti_com_pages_languages AS ml
ON
ml.id_language = l.id
WHERE
l.code = 'en'
AND
ml.id_ref = b.id
) AS lng_exists
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'model'
AND
t.context = 'list'
)
, `b`.`model`
) AS `model`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'seo_description'
AND
t.context = 'list'
)
, `b`.`seo_description`
) AS `seo_description`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'seo_keywords'
AND
t.context = 'list'
)
, `b`.`seo_keywords`
) AS `seo_keywords`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'seo_title'
AND
t.context = 'list'
)
, `b`.`seo_title`
) AS `seo_title`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'title'
AND
t.context = 'list'
)
, `b`.`title`
) AS `title`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'url'
AND
t.context = 'list'
)
, `b`.`url`
) AS `url`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'url_root'
AND
t.context = 'list'
)
, `b`.`url_root`
) AS `url_root`
, COALESCE (
(
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = COALESCE(NULLIF(`b`.`other_content_id`, -1), `b`.`id`)
AND
t.language = 'en'
AND
t.type = 'content'
AND
t.context IN ('', 'list')
)
, (
SELECT
t2.content
FROM
emmeti_com_pages AS t2
WHERE
t2.id = `b`.`other_content_id`
)
, (
SELECT
t.text
FROM
`emmeti_com_pages_translations` AS t
WHERE
t.id_ref = `b`.`id`
AND
t.language = 'en'
AND
t.type = 'content'
AND
t.context IN ('', 'list')
)
, `b`.`content`
) AS `content`
FROM
emmeti_com_pages AS b
WHERE b.enabled = '1' AND b.deleted = 0 HAVING CONCAT(url_root, IF(url_root != '', '/', ''), url) = 'company/sustainability/our-10-commitments'
Fatal error: Uncaught Error: Call to a member function custom_row_object() on bool in /var/www/vhosts/emmeti.com/httpdocs/modules/pages/class.php:279
Stack trace:
#0 /var/www/vhosts/emmeti.com/httpdocs/router.php(203): pages->get()
#1 {main}
thrown in /var/www/vhosts/emmeti.com/httpdocs/modules/pages/class.php on line 279