Error in Query Subquery returns more than 1 row
SELECT category_id, bp.package_id, bp.package_name, bt.type_id, bt.type_name, type_base_price AS base_price, type_extra_price AS extra_price,
package_color_bw,package_color_premium,package_color_premium_type,
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 = bptp.type_id AND bpue.publication_id = bp.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 = bptp.type_id AND publication_id = bp.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 = bptp.type_id AND bpue.publication_id = bp.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 = bptp.type_id AND publication_id = bp.publication_id)) AS size
FROM bookmyad_packages bp JOIN bookmyad_package_type_price bptp ON (bptp.package_id=bp.package_id)
JOIN bookmyad_type bt ON (bptp.type_id=bt.type_id)
WHERE bp.package_id = '89' AND category_id = '108'
.png)
.jpg)
.jpg)
.jpg)
+91 8800 33 4456 
login
