user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by ml.plid' at line 6
query: select ml1.link_path,ml1.link_title from cosmo_term_data td
inner join cosmo_term_node tn on tn.tid=td.tid
inner join cosmo_menu_node mn on mn.nid=tn.nid
inner join cosmo_menu_links ml on ml.mlid=mn.mlid
inner join cosmo_menu_links ml1 on ml1.mlid=ml.plid
where td.name='Book Publishing' and td.vid= group by ml.plid in /home/admin/public_html/cosmofilms.com/sites/all/themes/CosmoCorp/block-industries_products.tpl.php on line 39.