SQL Hatası: SQLSTATE[HY093]: Invalid parameter number SQL Query:
SELECT
i.*,
(
SELECT COUNT(*)
FROM doping d
WHERE d.ilanId = i.Id
AND d.name = 'kategori'
AND d.onay = '1'
AND d.val >= CURDATE()
) AS isKategoriDoping
FROM ilanlar i
WHERE
(
i.category1 = :id OR i.category2 = :id OR i.category3 = :id OR
i.category4 = :id OR i.category5 = :id OR i.category6 = :id OR
i.category7 = :id OR i.category8 = :id OR i.category9 = :id OR
i.category10 = :id
)
AND i.bitis >= :bugun
AND i.confirm = '1'
ORDER BY
isKategoriDoping DESC,
dates DESC
LIMIT :limit, :sayfada