UPDATE `categories` SET `JO_Community`=(
SELECT COUNT(*) FROM `article_categories`
WHERE
article_categories.category_id = categories.id
AND
(SELECT type FROM article WHERE article.article_id = article_categories.article_id) IN ('post')
),`JO_Market`=(
SELECT COUNT(*) FROM `article_categories`
WHERE
article_categories.category_id = categories.id
AND
(SELECT type FROM article WHERE article.article_id = article_categories.article_id) IN ('product')
),`JO_Services`=(
SELECT COUNT(*) FROM `article_categories`
WHERE
article_categories.category_id = categories.id
AND
(SELECT type FROM article WHERE article.article_id = article_categories.article_id) IN ('service')
),`JO_Jobs`=(
SELECT COUNT(*) FROM `article_categories`
WHERE
article_categories.category_id = categories.id
AND
(SELECT type FROM article WHERE article.article_id = article_categories.article_id) IN ('vacant')
)
الشواغر - ساعات في مأدبا || وظائف الأردن - JO Jobs
