string(2627) "SELECT product_no , product_name , product_brand , product_brand_eng , product_price , product_margin , CP_CODE , product_img_dir , event_type , product_cate_code , cnt_chk_type , product_stock_cnt , SALE_TYPE , BND_CODE , product_option , delivery_type , delivery_cost , reg_date , order_price , product_option , event_cate_code , (SELECT count(*) FROM webis_shop_product_ripple WHERE product_num=webis_shop_product.product_no) as CommentCnt , (SELECT COUNT(*) FROM webis_shop_wishlist WHERE product_code=webis_shop_product.product_no) as WishCnt , LENGTH(event_type) as EventLength , IF(product_option !='' , 'Y', 'N') IsOption , delivery_min , product_maker1 , gift_type FROM webis_shop_product WHERE product_no IN ('3966111 ','3997779 ','3997780 ','3997781 ','3997783 ','4039852 ','4039854 ','4039855 ','4039856 ','4039857 ','4039858 ','4039859 ','4039861 ','4039862 ','4039864 ','4039865 ','4039866 ','4039867 ','4039868 ','4039869 ','4039870 ','4039871 ','4039872 ','4039873 ','4039874 ','4039875 ','4039876 ','4039877 ','4039879 ','4039880 ','4039882 ','4039883 ','4039884 ','4039885 ','4039887 ','4039888 ','4039889 ','4039890 ','4039891 ','4039893 ','4039896 ','4039897 ','4039898 ','4039900 ','4039901 ','4039902 ','4039904 ','4039906 ','4039907 ','4039908 ','4039909 ','4039911 ','4039915 ','4039916 ','4039919 ','4039920 ','4039921 ','4039922 ','4039924 ','4039925 ','4039926 ','4039927 ','4039930 ','4039931 ','4039932 ','4039933 ','4039934 ','4039936 ','4039937 ','4039939 ','4039940 ','4039942 ','4039943 ','4039944 ','4039945 ','4039946 ','4039947 ','4039948 ','4039949 ','4039951 ','4039952 ','4039954 ','4039955 ','4039956 ','4039957 ','4067669 ','4067672 ','4067673 ','4067674 ','4174024 ','4174026 ','4174028 ','4174030 ','4174032 ','4174034 ','4174036 ','4174039 ','4174042 ','4174044 ','4174062 ','4174063 ','4174064 ','4174074 ','4174075 ','4174076 ','4174077 ','4174078 ','4174079 ','4174080 ','4174081 ','4174082 ','4179345 ','4179346 ','4179347 ','4179349 ') AND SALE_TYPE IN (79, 89, 99) AND DISP_TYPE='Y' AND order_price > 0 ORDER BY CommentCnt DESC LIMIT 0, 24"