Product Types
select price.code,price.product ,price.vat_word ,/*pricelist_menu.grpname*/ menu_dtl_name as sub_gr , price.First , price.Second , price.Third , price.Fourth,product.name_flash ,product.pic_name ,product.url as url ,product.detail,product.pic_folder ,item_master.SPEC,price.Special,price.cpn , price.warranty,price.date_,price.Note ,price.price_protection,price.price_71 ,price.price_81 ,price.old_data,price.Spec as spec_price ,price.url as price_call,menu_list_dtl.menu_id ,price.menu_dtl_id,price.seventh, asone_point.level1,asone_point.level2,asone_point.multiple from price LEFT JOIN item_master ON price.code = item_master.CODE LEFT JOIN product ON price.code = product.code LEFT JOIN menu_list_dtl ON price.menu_dtl_id= menu_list_dtl.menu_dtl_id LEFT JOIN pricelist_menu ON menu_list_dtl.menu_id = pricelist_menu.menu_id LEFT JOIN asone_point ON price.code=asone_point.code where price.eshop_only !='e' and price.system_only != 'SYSTEM' and price.Grp ='Mobile Phone' group by price.code order by pricelist_menu.no_ , price.Item_no asc,price.product ----