Sign In | Register |    
Caribbean Sheet Tubular Industries Limited (CASAT)
Brands :

caribbean sheet tubular industries limited (casat)

Address: LP No. 36 El Socorro Road, San Juan, Trinidad and Tobago
Views: 931
City: San Juan
Country: N/A
Contact No: +1 674-6050
Fax: N/A
Owner/Manager: Pramanan Beharry
Products/Services:  Furniture Furnishing  Office Furniture and Furnishings   Wooden Furniture  Wood  wood furnishings   wooden doors and cabinets 
Experience: Established
Certification Type: N/A
Issued By: N/A
Description of Certificate: N/A
Certification logo: N/A
  • Company Profile
  • About Us
  • Products & Services
  • Key Personnel

Unknown column 'BC.CompanyEmailID' in 'field list'

SELECT CompanyDetailsID,fkUserID,CompanyName,LocationofRegistration,CompanyOperationalAddress,BC.City,BC.State,BC.Country,BC.ZipCode,MainProducts,OtherProducts,CompanyRegistered,TotalNoEmployees,CompanyWebsiteUrl,LegalOwner,OfficeSize,CompanyAdvantages,UserPhoneNumber,FaxNo,ProductServices,Brands,fkCategoryID,fkChildCategoryID,C.Name,History,BC.CompanyEmailID,BC.Facebook,BC.Instagram FROM base_company_details AS BC LEFT JOIN country AS C ON C.pkCountryID = BC.Country RIGHT JOIN users AS U ON U.pkUserID = BC.fkUserID WHERE fkUserID ='119' AND CompanyDetailsID = '51'