JOIN CLUB Clos de la Tech

Be among the first considered for allocations of upcoming releases and get access to special tasting events and seminars.

SELECT TablProdMast.* , TablDiscMast.id AS DiscID , TablDiscMast.startdate AS DiscStartDate , TablDiscMast.enddate AS DiscEndDate , TablDiscMast.distype AS DiscType , TablDiscMast.disamount AS DiscAmt , (100-TablDiscMast.disamount) AS DisPercen , IF(( NOW() BETWEEN TablDiscMast.startdate AND TablDiscMast.enddate OR NOW() BETWEEN TablDiscMast.startdate AND TablDiscMast.enddate OR (NOW() > TablDiscMast.startdate AND NOW() < TablDiscMast.enddate) OR (NOW() < TablDiscMast.startdate AND NOW() > TablDiscMast.enddate) ),IF(distype = '0', (ROUND((TablProdMast.product_price - TablDiscMast.disamount),2)), (ROUND(((ROUND(((ROUND((100-TablDiscMast.disamount),2)) * TablProdMast.product_price),2))/100),2)) ),TablProdMast.product_price) AS CurrentPrice , TablCateMast.id AS CategoryID , AttrValu.id AS AttributeValueID FROM zp_ecommerce_product_master AS TablProdMast LEFT OUTER JOIN zp_ecommerce_product_category_map AS TablProdCateMap ON TablProdCateMap.product_id = TablProdMast.id LEFT OUTER JOIN zp_ecommerce_category_master AS TablCateMast ON TablCateMast.id = TablProdCateMap.category_id LEFT OUTER JOIN zp_ecommerce_product_attribute_set AS ProdAttrSet ON TablProdMast.id = ProdAttrSet.product_id LEFT OUTER JOIN zp_ecommerce_product_attribute_set_value AS AttrSetValu ON ProdAttrSet.id = AttrSetValu.prod_attribute_set_id LEFT OUTER JOIN zp_ecommerce_attribute_value AS AttrValu ON AttrValu.id = AttrSetValu.attribute_value_id LEFT OUTER JOIN zp_ecommerce_watchlist AS TablWatchlist ON TablWatchlist.item_id = TablProdMast.id LEFT OUTER JOIN zp_ecommerce_discount_product_map AS TablProdDiscMap ON TablProdDiscMap.productid = TablProdMast.id LEFT OUTER JOIN zp_ecommerce_discount_master AS TablDiscMast ON TablProdDiscMap.disid = TablDiscMast.id WHERE TablProdMast.status = '1' AND TablCateMast.id = '36' GROUP BY TablProdMast.id ORDER BY listing_position
Out of resources when opening file '/tmp/#sql_1ca_0.MYI' (Errcode: 24 - Too many open files)