Sign In | Register |    
Post a Project
Madeintn>Foods>the albrosco group
Contact Supplier
 
 
 
The Albrosco Group
Brands :
Blue Ribbon
Little Chef
MacFoods
May Pride
Mayflower
Heat & Eat
Lu Blue
Bug Off
Flamingo
Pantai
Funmin
Loveme
Teddy
Smithsfields
Blue Ribbon
Little Chef
MacFoods
May Pride
Mayflower
Heat & Eat
Lu Blue
Bug Off
Flamingo
Pantai
Funmin
Loveme
Smithsfields
Sano
superfresh

the albrosco group

Address: Trinidad and Tobago, W.I.
Views: 2644
City: Belmont
Country: N/A
Contact No: N/A
Fax: N/A
Owner/Manager: Andrew Aleong
Website: N/A
Products/Services:  Foods  Canned foods  Canned Meat  Canned Vegetables  Fish  Sauces  Soups & Noodles  Insect Repellent  Kitchen Products  Dish cleaners  Clothes Care  Detergent  Bath & Body Care  Soap 
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 ='138' AND CompanyDetailsID = '65'