SQLSTATE[HY093]: Invalid parameter number Raw SQL : SELECT p.* FROM `products` p JOIN `products_categories` pc ON p.id = pc.product_id WHERE pc.category_id = :cat_id AND p.available = :available Parameters : cat_id => available => 1