如何从Prestashop的数据库中获取特定产品

Question

Is there any simple way to retrieve only 'Product Packs' from database? I want to display all the product pack combinations in different category.

And it would be great if I can disable this pack to be appeared in other category. If its become too much complex, I have no problem with it.

As I am using a custom templates I am giving a sample of code about how it displays product in my Prestashop 1.6.1.4.

<div class ='cate_title'>
                    {foreach from=$productCates item=productCate name=posTabCategory}
                     <div id="tabtitle_{$productCate.id}" class="tab_title">        
                            <h2>
                                <span>{$productCate.name}</span>
                            </h2>
                    </div>  
                    {/foreach}
                </div>
                <ul class="tab_cates"> 
                {$count=0}
                {foreach from=$productCates item=productCate name=posTabCategory}
                        <li data-title="tabtitle_{$productCate.id}" rel="tab_{$productCate.id}" {if $count==0} class="active"  {/if} > {$productCate.name}</li>
                        {$count= $count+1}
                {/foreach}  
                </ul>
            </div>  
            <div class="tab1_container"> 
            {foreach from=$productCates item=productCate name=posTabCategory}
                <div id="tab_{$productCate.id}" class="tab_category">
                    <div class="row">
                        <div class="productTabCategorySlider1">
                            {foreach from=$productCate.product item=product name=posTabCategory}

                                <div class="cate_item">
                                    <div class="item-inner">
                                        <a class ="bigpic_{$product.id_product}_tabcategory product_image" href="{$product.link|escape:'html'}" title="{$product.name|escape:html:'UTF-8'}"><img class="img-responsive" src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default')|escape:'html'}" alt="{$product.name|escape:html:'UTF-8'}" />

      ..............................
      ...............................

Answer 1

Follow is sql by which you can get all pack products from database $pack_products = Db::getInstance()->executeS('SELECT * FROM '._DB_PREFIX_.'product WHERE cache_is_pack = 1');