[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

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]