Exception

Database Exceptionyii\db\Exception

SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
The SQL being executed was:

SELECT C.Worksheet_id,
(SELECT C.CoverURL FROM catalogs C WHERE C.ID = '10') AS CoverURL ,
(SELECT W.name FROM worksheets W WHERE W.ID = C.worksheet_id) AS JENIS_BAHAN,
(SELECT GROUP_CONCAT(CS.Value ORDER BY CR.Tag,CS.Sequence ASC SEPARATOR ' ') FROM catalog_subruas CS LEFT JOIN catalog_ruas CR ON CS.RuasID = CR.ID WHERE CR.CatalogId = C.ID AND CR.Tag IN (245) GROUP BY CR.CatalogId) AS JUDUL,
(SELECT GROUP_CONCAT(CS.Value ORDER BY CR.Tag,CS.Sequence ASC SEPARATOR ' ') FROM catalog_subruas CS LEFT JOIN catalog_ruas CR ON CS.RuasID = CR.ID WHERE CR.CatalogId = C.ID AND CR.Tag IN (240) GROUP BY CR.CatalogId) AS JUDUL_SERAGAM,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SUBRUAS = 'e'
THEN CONCAT ( '(' , CS.Value , ') |' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (100,110,111,700,710,711,800,810,811)
AND CS.Subruas IN ('a', 'd' ,'e')
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z
) AS PENGARANG,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (250)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS EDISI,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (490)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS PERNYATAAN_SERI,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (260,264)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS PENERBITAN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SUBRUAS = '3'
THEN CONCAT ( '[' , CS.Value , ']' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (300)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
ORDER BY CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS DESKRIPSI_FISIK,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
-- CS.Value AS VAL1
CASE
WHEN CS.SUBRUAS = '3'
THEN CONCAT ( '[' , CS.Value , ']' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (336)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
ORDER BY sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z
) AS KONTEN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (337)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS MEDIA,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (338)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS PENYIMPANAN_MEDIA,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (538)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS INFORMASI_TEKNIS,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (020)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISBN,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (022)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISSN,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (024)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISMN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SubRuas <> 'a'
THEN
CONCAT(' ',CS.Value)
ELSE CS.Value
END AS VAL1

FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (600,610,611,650,651)
GROUP BY
CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS SUBJEK,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (520)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z



) AS ABSTRAK,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (500,501,502,504,505,533,550)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS CATATAN,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,36,3) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 5) AS BAHASA,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,34,1) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 17) AS BENTUK_KARYA,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,23,1) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 2) AS TARGET_PEMBACA,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '10'
AND CR.Tag IN (856)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS LOKASI_AKSES_ONLINE
FROM catalogs C WHERE C.ID = '10' AND isopac = 1

Error Info: Array
(
    [0] => 21000
    [1] => 1242
    [2] => Subquery returns more than 1 row
)
$_GET = [
    'id' => '10',
];

$_SESSION = [
    '__flash' => [],
];