SELECT `p`.*, digira_price_calculation(s.site_price_val,s.site_side_price_val, s.site_price_per, s.site_side_price_per, p.vat_price, pm.offer_money, pm.offer_percent, pm.offer_start, pm.offer_end, pm.real_price) AS `vat_price`, digira_price_calculation(s.site_price_val,s.site_side_price_val, s.site_price_per, s.site_side_price_per, p.vat_price, null, null, null, null, null) AS `price_without_reductions` FROM `product` AS `p`
 LEFT JOIN `product_meta` AS `pm` ON p.id = pm.product_id AND pm.site_id = '8'
 LEFT JOIN `site` AS `s` ON s.id = '8'
 LEFT JOIN `category_product_bridge` AS `cpb` ON p.id = cpb.product_id
 LEFT JOIN `digira_category` AS `c` ON cpb.digira_category_id = c.digira_id WHERE ((c.id = '141' OR c.parent_id = '141')) AND (p.type != 'periodical') AND (p.type != 'folio') AND ((p.folio_status = 'active' OR p.folio_status IS NULL OR p.folio_status = '')) AND (state = 'active') AND (lower(p.language) LIKE '%est%') AND (pm.visible = 1 OR pm.visible IS NULL) GROUP BY `p`.`id` ORDER BY `vat_price` ASC LIMIT 12