Manufacturers Directory from Taiwan, China, Asia Manufacturers and Suppliers and exporters
System Upgrade Notice!
Websites will be unavailable due to system maintenance during the times as follows. From December 2, 2009, 10:00pm - December 2, 2009, 12:00pm (Taiwan). We apologize for any inconvenience this may cause.
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