SELECT a.id, a.catcode, a.parentProdcode, a.prodcode, a.productname, c.bsPrdId, a.prodshortdesc, a.proddesc, a.isPoa, a.price1, a.price2, a.price3, b.catname FROM `gizm_product_master` a LEFT JOIN `gizm_conf_cat_master` b ON a.`catcode`=b.`catcode` LEFT JOIN gizm_bussiness_products c ON a.prodcode=c.prodcode WHERE a.status=1 AND a.prodTyp=1 AND a.listProd=1 AND a.isDeleted=0 AND CONVERT(a.addedOn, DATE)>=CONVERT('2017-01-01', DATE) GROUP BY a.prodcode order by a.visitCnt DESC, a.updatedOn DESC limit 4
    Lost connection to MySQL server during query

    select a.*, DATE_FORMAT(a.updatedOn,'%d %b %Y') AS updatedOnDisp, b.catname from gizm_article_pages a LEFT JOIN gizm_conf_cat_master b ON a.catCode=b.catcode WHERE a.status='1' AND a.isDeleted='0' order by a.updatedOn DESC limit 4
    MySQL server has gone away

Find all your gizms / electronic product and pricing options nearby you...

More...


SELECT a.id, a.catcode, a.parentProdcode, a.prodcode, a.productname, a.prodshortdesc, a.proddesc, a.isPoa, a.price1, a.price2, a.price3, a.avlStat, a.avlDt, b.catname FROM `gizm_product_master` a LEFT JOIN `gizm_conf_cat_master` b ON a.`catcode`=b.`catcode` WHERE a.status=1 AND a.prodTyp=1 AND a.listProd=1 AND a.isDeleted=0 GROUP BY a.prodcode order by a.priorProd DESC, a.updatedOn DESC limit 18
MySQL server has gone away

No product is found.


select a.*, DATE_FORMAT(a.updatedOn,'%d %b %Y') AS updatedOnDisp, b.catname from gizm_article_pages a LEFT JOIN gizm_conf_cat_master b ON a.catCode=b.catcode WHERE a.status='1' AND a.isDeleted='0' order by a.updatedOn DESC limit 6
MySQL server has gone away

select stateId, stateName, stateName AS ddNameTxt, stateCode, cntCodeFips104, stateTyp, status from gizm_conf_states WHERE status = 1 AND cntCodeFips104 = 'IN'
MySQL server has gone away

Your feedback is Our inspiration!!

Please feel free to send us your feedback or any suggestion. We look forward to hearing from you!

Note: Your reviews will be posted on www.gizmento.com website subject to conditions:
  • Gizmento reserves the right to refuse and remove any review.