{"er":1,"code":{"code":"ER_SUBQUERY_NO_1_ROW","errno":1242,"sqlMessage":"Subquery returns more than 1 row","sqlState":"21000","index":0,"sql":"SELECT * ,  \n    ( SELECT CONCAT(ref , ' ' , titre) FROM langues WHERE id = SP.langue ) AS langue__txt__T ,\n    ( SELECT nom FROM liste_table_self_creation WHERE id = SP.formType ) AS formType__txt__T ,\n    (SELECT COUNT(id) FROM  statiquepage WHERE pageMerre = SP.id ) AS nbrOfLangue ,\n    ( SELECT titre FROM statiquepage WHERE id = SP.pageMerre ) AS pageMerre__txt__T ,\n    \n    (SELECT GROUP_CONCAT( DISTINCT JSON_OBJECT( 'id' , type1 , 'type1' , type1 , 'type1__txt__T' , (SELECT titre FROM type1 WHERE id = type1) ) SEPARATOR ',' ) FROM typepage TP WHERE TP.id = SP.id ) AS type1 , \n   \n    (SELECT GROUP_CONCAT( DISTINCT JSON_OBJECT('id' , type2 ,'type2' ,  CONCAT_WS('-' , type1 , type2 ) , 'type2__txt__T' , (SELECT titre FROM type2 WHERE id = type2) ) SEPARATOR ',' ) FROM typepage TP2 WHERE TP2.id = SP.id  AND type2 IS NOT NULL ) AS type2 , \n \n    (SELECT GROUP_CONCAT( DISTINCT JSON_OBJECT('id' , type3 ,'type3' , CONCAT_WS('-' , type1 , type2 , type3 ) , 'type3__txt__T'  ,   (SELECT titre FROM type3 WHERE id = type3) )  SEPARATOR ',' ) FROM typepage TP3 WHERE TP3.id = SP.id AND type3 IS NOT NULL ) AS type3 \n    \n\n    FROM statiquepage SP  WHERE 1=1  AND pageMerre = (SELECT id FROM statiquepage WHERE 1 = 1     ) AND langue =  'product-details.html '   AND trans <> 'A'  GROUP BY SP.id ORDER BY SP.id DESC   "}}