<div class="col-md-3">
   <!--hide on screens smaller than lg Begin-->
   <div class="d-none d-lg-block">
      <!--filter filter-lg Begin--> 
      <div class="filter filter-lg">
         <!--Accordioncategories Begin-->
         <div class="accordion" id="accordioncategories">
            <div class="accordion-item">
               <h2 class="accordion-header" id="categoriesheading">
                  <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#collapsecategories" aria-expanded="false">
                  Categories
                  </button>
               </h2>
               <div id="collapsecategories" class="accordion-collapse collapse show" aria-labelledby="categoriesheading" data-bs-parent="#accordioncategories">
                  <div class="accordion-body border-0">
                     <?php  $sqlcategory="SELECT * FROM  company_master ORDER BY rand() LIMIT 6";
                        $myquerycou=$conn->query($sqlcategory);
                        $mydaracategory= $myquerycou->fetchAll()  ;
                        
                        
                        
                        foreach( $mydaracategory as $rowcat ){  
                        
                        $company_name = addslashes($rowcat["company"]); 
                        if($company_name!=''){
                        ?>
                     <div class="form-check mb-2">
                        <a title="Accessories coupons and offers" href="coupons/<?=($company_name)?>">
                        <label class="form-check-label cursor-pointer">
                        <?=$company_name?>
                        </label></a>
                     </div>
                     <?php } } ?>
                  </div>
               </div>
            </div>
         </div>
         <!--Accordioncategories End-->
      </div>
      <!--filter filter-lg End--> 
   </div>
   <!--hide on screens smaller than lg End-->
   <!--hide on lg and wider screens Begin-->
   <div class="d-lg-none">
      <div onclick="filterbottomopenNav()" class="filter-bottom">
         <h6 class="text-uppercase"><i class="fas fa-sliders-h pe-2"></i> Filter</h6>
      </div>
      <!--filterfootermySidenav-->
      <div id="filterfootermySidenav" class="filterbottomsidenav shadow-sm">
         <ul class="list-unstyled p-0 t-9">
            <!--filterbottomcloseNav list-->
            <li> <a href="#" class="closebtn" onclick="filterbottomcloseNav()"><i class="fas fa-times"></i></a></li>
            <!--Search in Filter list-->
            <li>
               <p class="fw-bold mb-3">Filter</p>
               <div class="input-group mb-3">
                  <input type="text" class="form-control bg-smoke-white" placeholder="Search in Filter">
                  <span class="input-group-text bg-smoke-white">
                     <svg xmlns="http://www.w3.org/2000/svg" width="18" height="17" viewBox="0 0 18 17">
                        <path fill="#888" d="M7.44412,0 C3.89304889,0 1,3.04362024 1,6.77956734 C1,10.5155004 3.89304444,13.5591417 7.44412,13.5591417 C8.97992889,13.5591417 10.3906356,12.9879695 11.4994711,12.0395771 L15.8603644,16.6274712 C16.1206778,16.9013327 16.5444311,16.9013561 16.80476,16.6274712 C17.0650867,16.3535863 17.0650867,15.9150898 16.80476,15.6412283 L12.4438689,11.0533342 C13.3471556,9.88618462 13.88824,8.39712964 13.88824,6.77956734 C13.88824,3.04362024 10.9951933,0 7.44412,0 Z M7.44412,1.40266959 C10.2746378,1.40266959 12.5549733,3.8016865 12.5549733,6.77956734 C12.5549733,9.75741311 10.2746333,12.1564721 7.44412,12.1564721 C4.61360667,12.1564721 2.33326667,9.75741311 2.33326667,6.77956734 C2.33326667,3.8016865 4.61360222,1.40266959 7.44412,1.40266959 Z" transform="rotate(-3 9 8.416)"></path>
                     </svg>
                  </span>
               </div>
            </li>
         </ul>
      </div>
   </div>
   <!--hide on lg and wider screens End-->
   <!--Coupons from Similar Stores Begin-->
   <div class="similar-store">
      <div class="my-4"></div>
      <h6 class="mb-3">popular Brand</h6>
      <ul class="list-unstyled">
         <?php  $sqlcategory="SELECT * FROM  brand_master ORDER BY rand() LIMIT 6";
            $myquerycou=$conn->query($sqlcategory);
            $mydaracategory= $myquerycou->fetchAll()  ;
            
            $rows_foundcou = $myquerycou->rowCount();
            
            foreach( $mydaracategory as $rowcat ){  
            
            $brand_name = addslashes($rowcat["brand_name"]); 
            if($brand_name!=''){
            ?>
         <li><a title="<?=$brand_name?>" href="brand-specific/<?=($brand_name)?>"> <?=$brand_name?></a></li>
         <?php } } ?>
      </ul>
   </div>
   <!--Coupons from Similar Stores End-->
   <!--Popular Stores Begin-->
   <div class="similar-store">
      <div class="divider my-3"></div>
      <h6 class="mb-3">Popular Stores</h6>
      <ul class="list-unstyled">
         <?php  $sqlcategory="SELECT * FROM  store_master ORDER BY rand() LIMIT 6";
            $myquerycou=$conn->query($sqlcategory);
            $mydaracategory= $myquerycou->fetchAll()  ;
            
            $rows_foundcou = $myquerycou->rowCount();
            
            foreach( $mydaracategory as $rowcat ){  
            
            $store_name = addslashes($rowcat["store_name"]); 
            if($store_name!=''){
            ?>
         <li><a title="<?=$store_name?>" href="store-specific/<?=($store_name)?>"><?=$store_name?></a></li>
         <?php } } ?>
      </ul>
   </div>
   <!--Popular Stores End-->
           <!--Accordioncountry Begin-->
           <div class="accordion  accordion-flush " id="accordioncountry">
            <div class="accordion-item">
           
               <h3 class="h6 accordion-header border-bottom" id="countryheading">
                  <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#collapsecountry" aria-expanded="false">
                  Country
                  </button>
               </h3>
               <div id="collapsecountry" class="accordion-collapse collapse show" aria-labelledby="countryheading" data-bs-parent="#accordioncountry">
               <div class="accordion-body border-0">
                              <ul class="list-group list-group-flush">
                                 <?php
                                    $count_country = "SELECT coupon_country_name, COUNT(*) AS 'number' from coupon group by coupon_country_name;";
                                     $mydara_country = $conn->query($count_country);
                                     $country_fetch =  $mydara_country->fetchAll();
                                     $count_rows = $mydara_country->rowCount();
                                    // var_dump( $country_fetch );
                                    foreach( $country_fetch  as $rowcount ){  
                                    $country_name = $rowcount['coupon_country_name'];
                                    $number = $rowcount['number'];
                                    if($country_name != ""){
                                 ?>
                              <li class="list-group-item d-flex justify-content-between align-items-start">
                                    <a class="d-content" href="coupon-country/<?=($country_name)?>">
                                      <div title="<?=$country_name?>" class="pe-3 me-auto list-txt">
                                         <p><?=$country_name?></p>
                                      </div>
                                      <span class="badge bg-primary rounded-pill"> <?=$number?></span></a>
                                    </li>

                                    <?php } }?>
                                    <!-- <li class="list-group-item d-flex justify-content-between align-items-start">
                                    <a class="d-content" href="#">
                                      <div title="Germany" class="pe-3 me-auto list-txt">
                                         <p>Germany</p>
                                      </div>
                                      <span class="badge bg-primary rounded-pill">6</span></a>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-start">
                                    <a class="d-content" href="#">
                                      <div title="New York" class="pe-3 me-auto list-txt">
                                         <p>New York</p>
                                      </div>
                                      <span class="badge bg-primary rounded-pill">66</span></a>
                                    </li> -->
                            
                              
                              </ul>
                           </div>
               </div>
            </div>
         </div>
         <!--Accordioncategories End-->
    <!--Banner Begin-->
   <div class="mb-3">
    <?php    if(!empty($google_adar )){
      echo $google_adar ;
      }else{
      echo ' <img src="admin/forms/'.$adimg1.'" alt="Vertical Banner" title="Vertical Banner" class="img-fluid rounded-3 mt-2">';
      }
      
      ?>
</div>
   <!--Banner End-->
    <!--Google Ads Begin-->
    <div class="mb-3"><?=$google_addis?></div>
      <!--Google Ads End-->
</div>