Sign In | Register |    
 
 
 
Langston Roach Industries Limited
Brands :
Lanher Cleaning Solutions
Soft & Silky

langston roach industries limited

Address: #106 Saddle Road
Views: 727
City: San Juan
Country: N/A
Contact No: 1 (868) 674-0216
Fax: N/A
Owner/Manager: Langston Roach
Website: www.lritnt.com
Products/Services:
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 ='146' AND CompanyDetailsID = '71'