SELECT `id` FROM `koybq_menu` WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '13'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '12'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '11'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '10'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '9'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '8'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '7'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '6'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '5'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '4'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '3'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '2'

SELECT*FROMkoybq_community_groups_discussWHERE `id` = '1'

SELECT id
FROMkoybq_assetsWHERE parent_id = 0

SELECT id
FROMkoybq_assetsWHERE parent_id = 0

SELECT a.`params`, a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script FROM `koybq_menu` AS a LEFTJOIN `koybq_menu` AS b ON b.`id`=a.`parent_id` AND b.`published`='1' WHERE a.`published`='1' AND a.`menutype`='jomsocial' AND a.`access`='0' ORDERBY a.`lft`