rtgx

temp.menu.categories = CONTENT
temp.menu.categories {
  table = tt_products_cat 
  select {
    selectFields = tt_products_cat.uid AS uid, tt_products_cat.title AS title, COUNT(tt_products.uid) AS productsCount
    pidInList = {$plugin.tt_products.PIDlist}
    join = tt_products ON tt_products_cat.uid = tt_products.category
    where = tt_products.pid IN ( {$pid.storagePagesProducts} )
    andWhere = tt_products.inStock > 0 AND tt_products.deleted = 0 AND tt_products.hidden = 0 AND ( tt_products.starttime <= UNIX_TIMESTAMP() ) AND ( tt_products.endtime = 0 OR tt_products.endtime > UNIX_TIMESTAMP() )
    groupBy = uid
    orderBy = title
  }
  renderObj = COA
  renderObj.10 = TEXT
  renderObj.10 {
    field = uid
    wrap = <li><a href="index.php?id={$plugin.tt_products.PIDlist}&tx_ttproducts_pi1[cat]=|" class="w1" onfocus="blurLink(this);">
  }
  renderObj.20 = TEXT
  renderObj.20 {
    field = title
    wrap = <img src="fileadmin/admin/img/leftMenuArrow.gif" alt="" /> |</a></li>
  }
}