Back To Top

Shop for Regina Andrew Products

Regina Andrew Room Accents

 Room Accents SELECT DISTINCT cg.Description,IF(pb.client_flag =1 ,CONCAT('/uploads/products/',pb.thumb),pb.thumb) as Image, mh.Description AS mhDescription, mh.slug AS mhSlug, cgDescription, cg.slug AS cgSlug, c.pkID AS cID, c.ConsumerDescription, c.slug AS cSlug, c.Category_Group, c.pkID AS cID, bd.CommonBrandName, bd.CommonBrandID as BrandID ,bd.video_name, bd.video_thumb, bd.pkID AS id FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN tbl_products as pb ON (pb.cSlug = c.slug AND pb.cgSlug = cg.slug AND pb.mhSlug = mh.slug) INNER JOIN Brand_Data as bd ON (bd.pkID = pb.pkBrand) INNER JOIN ModelPrice ON ModelPrice.pkProduct = pb.pkID AND ModelPrice.SKU = pb.SKU AND ModelPrice.Available = 1 INNER JOIN tbl_store_brands AS sb ON sb.brandID = bd.pkID AND sb.categoryID = c.pkID WHERE bd.slug = 'regina-andrew' AND cg.slug = 'room-accents' GROUP BY c.slug ORDER BY mh.seq

Regina Andrew Lighting

 Lighting SELECT DISTINCT cg.Description,IF(pb.client_flag =1 ,CONCAT('/uploads/products/',pb.thumb),pb.thumb) as Image, mh.Description AS mhDescription, mh.slug AS mhSlug, cgDescription, cg.slug AS cgSlug, c.pkID AS cID, c.ConsumerDescription, c.slug AS cSlug, c.Category_Group, c.pkID AS cID, bd.CommonBrandName, bd.CommonBrandID as BrandID ,bd.video_name, bd.video_thumb, bd.pkID AS id FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN tbl_products as pb ON (pb.cSlug = c.slug AND pb.cgSlug = cg.slug AND pb.mhSlug = mh.slug) INNER JOIN Brand_Data as bd ON (bd.pkID = pb.pkBrand) INNER JOIN ModelPrice ON ModelPrice.pkProduct = pb.pkID AND ModelPrice.SKU = pb.SKU AND ModelPrice.Available = 1 INNER JOIN tbl_store_brands AS sb ON sb.brandID = bd.pkID AND sb.categoryID = c.pkID WHERE bd.slug = 'regina-andrew' AND cg.slug = 'lighting' GROUP BY c.slug ORDER BY mh.seq

Regina Andrew Living Room

 Living Room SELECT DISTINCT cg.Description,IF(pb.client_flag =1 ,CONCAT('/uploads/products/',pb.thumb),pb.thumb) as Image, mh.Description AS mhDescription, mh.slug AS mhSlug, cgDescription, cg.slug AS cgSlug, c.pkID AS cID, c.ConsumerDescription, c.slug AS cSlug, c.Category_Group, c.pkID AS cID, bd.CommonBrandName, bd.CommonBrandID as BrandID ,bd.video_name, bd.video_thumb, bd.pkID AS id FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN tbl_products as pb ON (pb.cSlug = c.slug AND pb.cgSlug = cg.slug AND pb.mhSlug = mh.slug) INNER JOIN Brand_Data as bd ON (bd.pkID = pb.pkBrand) INNER JOIN ModelPrice ON ModelPrice.pkProduct = pb.pkID AND ModelPrice.SKU = pb.SKU AND ModelPrice.Available = 1 INNER JOIN tbl_store_brands AS sb ON sb.brandID = bd.pkID AND sb.categoryID = c.pkID WHERE bd.slug = 'regina-andrew' AND cg.slug = 'living-room' GROUP BY c.slug ORDER BY mh.seq