SELECT COUNT(*) FROM product AS a1 WHERE a1.status='Y' AND a1.model_status='Y' AND a1.picture_status='Y' AND
                    (
                        a1.model_category1_pk='33' OR
                        a1.model_category2_pk='33' OR
                        a1.model_category3_pk='33'
                    ) AND a1.model_pk='65' AND a1.picture_pk='8765'