アガット ターコイズバングル

SELECT * FROM v_info WHERE LUMINA_FLG=1 AND PRIVATE_FLG=0 AND PR_FLG=0 AND SCHOOL_FLG=0 AND (date_format(PUBLIC_FROM_DT,'%Y-%m-%d %H:%i')<=now() || PUBLIC_FROM_DT='0000-00-00 00:00') AND (date_format(PUBLIC_TO_DT,'%Y-%m-%d %H:%i')>=now() || PUBLIC_TO_DT='0000-00-00 00:00') ORDER BY PR_FLG DESC,cast(PUBLIC_DT as DATE) DESC,REGIST_DT DESC LIMIT 0,10

SELECT * FROM v_info WHERE LUMINA_FLG=1 AND PRIVATE_FLG=0 AND PR_FLG=0 AND SCHOOL_FLG=0 AND (date_format(PUBLIC_FROM_DT,'%Y-%m-%d %H:%i')<=now() || PUBLIC_FROM_DT='0000-00-00 00:00') AND (date_format(PUBLIC_TO_DT,'%Y-%m-%d %H:%i')>=now() || PUBLIC_TO_DT='0000-00-00 00:00') AND NEWS_FLG=1 ORDER BY PR_FLG DESC,cast(PUBLIC_DT as DATE) DESC,REGIST_DT DESC LIMIT 0,10

SELECT * FROM v_info WHERE LUMINA_FLG=1 AND PRIVATE_FLG=0 AND PR_FLG=0 AND SCHOOL_FLG=0 AND (date_format(PUBLIC_FROM_DT,'%Y-%m-%d %H:%i')<=now() || PUBLIC_FROM_DT='0000-00-00 00:00') AND (date_format(PUBLIC_TO_DT,'%Y-%m-%d %H:%i')>=now() || PUBLIC_TO_DT='0000-00-00 00:00') AND EVENT_FLG=1 ORDER BY PR_FLG DESC,cast(PUBLIC_DT as DATE) DESC,REGIST_DT DESC LIMIT 0,10

SELECT * FROM v_info WHERE LUMINA_FLG=1 AND PRIVATE_FLG=0 AND PR_FLG=0 AND SCHOOL_FLG=0 AND (date_format(PUBLIC_FROM_DT,'%Y-%m-%d %H:%i')<=now() || PUBLIC_FROM_DT='0000-00-00 00:00') AND (date_format(PUBLIC_TO_DT,'%Y-%m-%d %H:%i')>=now() || PUBLIC_TO_DT='0000-00-00 00:00') AND GOODS_FLG=1 ORDER BY PR_FLG DESC,cast(PUBLIC_DT as DATE) DESC,REGIST_DT DESC LIMIT 0,10

SELECT * FROM v_info WHERE LUMINA_FLG=1 AND PRIVATE_FLG=0 AND PR_FLG=0 AND SCHOOL_FLG=0 AND (date_format(PUBLIC_FROM_DT,'%Y-%m-%d %H:%i')<=now() || PUBLIC_FROM_DT='0000-00-00 00:00') AND (date_format(PUBLIC_TO_DT,'%Y-%m-%d %H:%i')>=now() || PUBLIC_TO_DT='0000-00-00 00:00') AND OTHER_FLG=1 ORDER BY PR_FLG DESC,cast(PUBLIC_DT as DATE) DESC,REGIST_DT DESC LIMIT 0,10