SELECT id, value
FROM `#__comprofiler_plugin_gallery_items`
WHERE `type` = 'photos'
AND `asset` LIKE 'monia.imgs.%'
AND `user_id` = '[user_id]'
AND (
`description` LIKE CONCAT('%', '[post_keyword_1]', '%')
OR `title` LIKE CONCAT('%', '[post_keyword_1]', '%')
OR `file` LIKE CONCAT('%', '[post_keyword_1]', '%')
OR `description` LIKE CONCAT('%', '[post_keyword_2]', '%')
OR `title` LIKE CONCAT('%', '[post_keyword_2]', '%')
OR `file` LIKE CONCAT('%', '[post_keyword_2]', '%')
);
Please Log in to join the conversation.
index.php?option=com_comprofiler&view=pluginclass&plugin=cbgallery&action=item&func=display&id=MEDIA_ID_HERE
index.php?option=com_comprofiler&view=pluginclass&plugin=cbgallery&action=item&func=embed&id=MEDIA_ID_HERE
index.php?option=com_comprofiler&view=pluginclass&plugin=cbgallery&action=item&func=preview&id=MEDIA_ID_HERE
index.php?option=com_comprofiler&view=pluginclass&plugin=cbgallery&action=item&func=show&id=MEDIA_ID_HERE
Please Log in to join the conversation.