Manufacturers Directory from Taiwan, China, Asia Manufacturers and Suppliers and exporters

SELECT 1 AS KR, (SELECT CONVERT(varchar(255),content) FROM company_ext WHERE type=1 AND company_id=c.company_id) AS content, c.company_id, c.company_name, c.e_date AS u_date, c.city, c.member_lv, c.country_id as country, u.last_login, c.url, 1 AS RANK, 1 AS kd FROM company c INNER JOIN ap_users u ON c.company_id=u.company_id WHERE c.company_name LIKE '%%' AND u.online = 1 ORDER BY member_lv ASC,c.u_date DESC