SELECT * FROM `prod_cat_link` JOIN `product` on `prod_cat_link`.`product_id`=`product`.`product_id` JOIN `product_price_link` on `prod_cat_link`.`product_id`=`product_price_link`.`product_id` JOIN `merchandise` on `product`.`merchandise_id`=`merchandise`.`merchandise_id` WHERE `prod_cat_link`.`category_id` = '184' AND `product_price_link`.`price_band_id`='1'
