客戶口碑

SELECT amount,reply,(SELECT CONCAT('',photo_merge) FROM logoless.design WHERE no=design_no) photo1,print_date,(SELECT (SELECT nickname FROM logoless.user WHERE no=orders.member_no) FROM logoless.orders where order_no=word_of_mouth_diy.order_no) nickname,person,message,vote,'DIY作品' words,create_time FROM logoless.word_of_mouth_diy WHERE is_on=1 AND design_no IN(SELECT `no` FROM logoless.design WHERE is_public=1 AND is_delete=0) GROUP BY nickname UNION ALL SELECT amount,reply,photo1,print_date,person nickname,person,message,vote,'團體服' words,create_time FROM logoless.word_of_mouth_group WHERE is_on=1 GROUP BY nickname ORDER BY create_time DESC LIMIT 36,12