Sign In | Register |    
Madeintn>>arima door centre
Arima Door Centre
Brands :
Arima Door Centre

arima door centre

Address: #4 Cleaver Road (Opp. Cleaver Woods Park) Arima, Trinidad, W.I.
Views: 25
City: Arima
Country: N/A
Contact No: 1-(868)-642-3509
Fax: 1-(868)-642-3509
Owner/Manager: Eustace Nancis
Website: N/A
Products/Services:  Furniture Furnishing  Door  Kitchen Cupboards 
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 ='153' AND CompanyDetailsID = '74'