ERROR!

mysqli_sql_exception: 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 'is FROM `imb__shop_price` where siteid=975 and pid=p.kid limit 1) as price fro' at line 4 in /data/shop/yuan.liectroux.shop/admin888/lib/vi_mysql_class.php:93 Stack trace: #0 /data/shop/yuan.liectroux.shop/admin888/lib/vi_mysql_class.php(93): mysqli->query() #1 /data/shop/yuan.liectroux.shop/admin888/lib/vi_mysql_class.php(251): VI_mysql_class->query() #2 /data/shop/yuan.liectroux.shop/cell/meta/meta_p_list.php(199): VI_mysql_class->getRows() #3 /data/shop/yuan.liectroux.shop/cell/p.php(6): require('...') #4 /data/shop/yuan.liectroux.shop/index.php(313): require('...') #5 /data/shop/yuan.liectroux.shop/admin888/core.class.php(74): imb_def() #6 /data/shop/yuan.liectroux.shop/global.php(60): ImbCMS_class->pageEngine() #7 /data/shop/yuan.liectroux.shop/index.php(3): require_once('...') #8 {main}select p.*,ui.ktitle,ui.ksubtitle1,ui.kdesc1, (select kurl from imb__media where siteid=975 and ktype='shop_imgs' and tid=p.kid order by norder limit 1) as kurl, (SELECT url FROM `uii_link` where siteid=975 and lang='is' and tid=p.kid limit 1) as url, (SELECT is FROM `imb__shop_price` where siteid=975 and pid=p.kid limit 1) as price from imb__shop as p left join ui_text as ui on p.kid=ui.uid where p.listid=19636 and p.siteid=975 and p.status=1 and ui.siteid=975 and ui.text_type=8 and ui.lang='is' order by p.kid desc limit 0,18;

ERROR: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 'is FROM `imb__shop_price` where siteid=975 and pid=p.kid limit 1) as price fro' at line 4