SELECT a.id FROMfh40d_menuAS a INNERJOIN `fh40d_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title ISNOTNULLAND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%'