Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r8986eb7a4926bada39ac722b03bc97c0c43b296b -rcd8b26e40ef07acd50b490475e013a9f9c7335b5
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision 8986eb7a4926bada39ac722b03bc97c0c43b296b)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision cd8b26e40ef07acd50b490475e013a9f9c7335b5)
@@ -176,7 +176,7 @@
                             " AND sim_sp.site_id IN (SELECT site_id FROM session_site WHERE session_id = " + skuTableWidgetData.getSessionId() + ")" +
                             " AND sp.product_id = sim.product_id AND sim.similar_product_id = sim_sp.product_id ) similarproduct ";
                 else
-                    sql += " , SIMILAR_PRODUCT similarproduct , (SELECT DISTINCT /*+ no_index(site_product) */ product_id FROM site_product WHERE site_id IN" +
+                    sql += " , SIMILAR_PRODUCT similarproduct , (SELECT /*+ no_index(site_product) */ DISTINCT product_id FROM site_product WHERE site_id IN" +
                             " (SELECT site_id FROM session_site WHERE session_id = " + skuTableWidgetData.getSessionId() + ")) sp ";
             }