SELECT catalog_no, ename, cname, photo FROM product_catalog LEFT JOIN catalog ON product_catalog.catalog=catalog.catalog_no LEFT JOIN catalog_customer_group ON catalog.catalog_no=catalog_customer_group.catalog WHERE product=197 AND customer_group=0 ORDER BY sort