total_pages0SELECT cld_code,cld_companyname,cld_companyname,cld_city,cld_country,cld_details,cld_feature,clc_clscode,clp_prjcode FROM (SELECT t1.cld_code, t1.cld_companyname, t1.cld_city, t1.cld_country, t1.cld_details, t1.cld_feature, t2.clc_clscode,t3.clp_prjcode FROM tblclientdetails AS t1, tblclientdetails_classcode AS t2,tblclientdetails_projectcode AS t3 WHERE ( t2.clc_clscode = '' ) AND ( t1.cld_code = t2.clc_cldcode ) AND ( t1.cld_code = t3.clp_cldcode ) ORDER BY FIELD(t3.clp_prjcode,87) DESC, t1.cld_companyname ASC) AS details GROUP BY cld_code ORDER BY FIELD(clp_prjcode,87) DESC LIMIT 0, 30 Gulf Oilfield Directory | Companies - Alphabetical List

Classification List -


Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/oilandgaspages/public_html/testclassi.php on line 166