Sign In | Register |    
Madeintn>Furniture Furnishing>diamond interiors limited
Diamond Interiors Limited
Brands :
Diamond Interiors

diamond interiors limited

Address: 2 Redman Lane, Don Miguel Road, San Juan, Trinidad
Views: 316
City: N/A
Country: N/A
Contact No: +1-868-674-4517
Fax: N/A
Owner/Manager: Ian Riley
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 ='129' AND CompanyDetailsID = '61'