[insert_php] global $wpdb; $get_brands = $wpdb->get_results(“SELECT * FROM pifl_terms as pt INNER JOIN pifl_term_taxonomy as ptt ON pt.term_id=ptt.term_id WHERE ptt.taxonomy=’pwb-brand’ ORDER BY pt.name ASC”); foreach($get_brands as $get_brand){ $get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_link)){ $get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”); } } [/insert_php]

BRANDS

Royalty Product Distributors UK
Sabina Product Distributors UK
Sumo Home Care Product Distributors UK
Robust Energy Drinks Distributors UK
Flower Garden Air Freshener Suppliers UK
Golden Country Corn Flakes Distributors UK
We have 17 brands of our own covering a variety of products from drinks to household goods. All of our products are designed to be on par with, if not, a better quality than the market leaders at a 30-40% lesser price. For example, our English Breeze & Flower Garden air fresheners have 2% perfume instead of the industry norm of 1% resulting in a longer lasting fragrance. Aside from our own brands that have become household names in 80 + countries within just 23 years, we also represent multinationals in various parts of the world. For example, we are the official distributor for Mondelēz in GCC & Africa, for Kraft-Heinz in Africa, for Nestle and Unilever in Africa & the Middle East and so on…

CATEGORIES

Our Brands

[insert_php] foreach($get_brands as $get_brand){ $parent_cat_list = ”; $get_termmeta_category = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_category’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_category[0]->meta_value)){ $parent_cat_list = $get_termmeta_category[0]->meta_value; } $get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_link)){ $get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”); echo’
‘; echo’
->meta_value.'” link=”‘.$get_termmeta_link[0]->meta_value.'”]
‘; echo’
‘; } } [/insert_php]

Leading Brands

[insert_php] foreach($get_brands as $get_brand){ $get_parent_cat = $wpdb->get_results(“SELECT rel1.* FROM pifl_term_relationships as rel JOIN pifl_term_relationships as rel1 ON rel1.object_id=rel.object_id WHERE rel.term_taxonomy_id=$get_brand->term_taxonomy_id”); $parent_cat_list = ”; foreach($get_parent_cat as $parent_cat){ $get_parent_cat_name = $wpdb->get_row(“SELECT trm.slug FROM pifl_term_taxonomy as tax JOIN pifl_terms as trm ON trm.term_id=tax.term_id WHERE tax.term_taxonomy_id=$parent_cat->term_taxonomy_id AND trm.term_id!=$get_brand->term_id”); $parent_cat_list .= $get_parent_cat_name->slug.” “; } $get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(empty($get_termmeta_link)){ $get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_img_id[0]->meta_value)){ $get_termmeta_category = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_category’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_category[0]->meta_value)){ $parent_cat_list = $get_termmeta_category[0]->meta_value; } echo’
‘; echo’
->meta_value.'” link=”‘.$get_termmeta_link[0]->meta_value.'”]
‘; echo’
‘; } } } [/insert_php]