SELECT
products.Name As Name,
products.SellerID As SellerID,
products.Description As Description,
products.FileImage As FileImage,
products.Youtube As Youtube,
products.Price As Price,
products.Unit As Unit,
products.MainCategoryID As MainCategoryID,
seller.Address As Address,
seller.GoogleMap As GoogleMap,
seller.Name As SellerName,
seller.NameAlias As SellerNameAlias,
seller.PhoneNumber As PhoneNumber,
seller.EmailID As EmailID,
products.RecordID As RecordID
FROM products
INNER JOIN seller on seller.RecordID=products.SellerID
WHERE products.NameAlias='ACECZONE-P'
