Please Log in to join the conversation.
SELECT `user_id`, `type`, `object`, GROUP_CONCAT( `id` ) AS ids, COUNT(*) AS total
FROM `jos_comprofiler_plugin_activity_hidden`
WHERE `object` = ''
GROUP BY `user_id`, `type`, `object`;
Please Log in to join the conversation.
Please Log in to join the conversation.
UPDATE `jos_comprofiler_plugin_activity_hidden` SET `asset` = NULL WHERE `asset` = ''
UPDATE `jos_comprofiler_plugin_activity_hidden` SET `object` = NULL WHERE `object` = 0
SELECT `user_id`, `type`, `asset`, GROUP_CONCAT( `id` ) AS ids, COUNT(*) AS total
FROM `jos_comprofiler_plugin_activity_hidden`
WHERE `asset` IS NOT NULL
GROUP BY `user_id`, `type`, `asset`
HAVING total > 1;
SELECT `user_id`, `type`, `object`, GROUP_CONCAT( `id` ) AS ids, COUNT(*) AS total
FROM `jos_comprofiler_plugin_activity_hidden`
WHERE `object` IS NOT NULL
GROUP BY `user_id`, `type`, `object`
HAVING total > 1;
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.