Error in Query Subquery returns more than 1 row
SELECT be.edition_id, edition_name, circulation, type_base_price AS base_price, type_extra_price AS extra_price,
category_id, bpetp.type_id, bt.type_name, be.publication_id,
IFNULL((SELECT uom_name FROM bookmyad_publication_uom_exceptions bpue JOIN bookmyad_uom bu ON (bpue.uom_id=bu.uom_id)
WHERE bpue.type_id = bpetp.type_id AND bpue.publication_id = be.publication_id AND category_id=bpue.category_id),
(SELECT uom_name FROM bookmyad_publication_to_type bpt JOIN bookmyad_uom bu ON (bpt.uom_id=bu.uom_id)
WHERE bpt.type_id = bpetp.type_id AND publication_id = be.publication_id)) AS uom,
IFNULL((SELECT IF(type_id = 1, minimum_width, CONCAT(minimum_width, 'X', minimum_height)) FROM bookmyad_publication_uom_exceptions bpue
WHERE bpue.type_id = bpetp.type_id AND bpue.publication_id = be.publication_id AND category_id=bpue.category_id),
(SELECT IF(type_id = 1, minimum_width, CONCAT(minimum_width, 'X', minimum_height)) FROM bookmyad_publication_to_type
WHERE type_id = bpetp.type_id AND publication_id = be.publication_id)) AS size
FROM bookmyad_edition be
JOIN bookmyad_publication_to_edition_price bpep ON (be.edition_id=bpep.edition_id)
JOIN bookmyad_publication_to_edition_to_type_price bpetp ON (bpep.edition_price_id=bpetp.edition_price_id)
JOIN bookmyad_edition_to_city bec ON (bec.edition_parent_id=be.edition_id)
JOIN bookmyad_type bt ON (bpetp.type_id=bt.type_id)
WHERE be.edition_id = '93' AND category_id = '108' AND bpetp.type_id = 1
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.