select count(*) as CT from TRN_PICTBLOG as PB left join MST_CAST as C on PB.CAST_ID = C.CAST_ID where PB.CAST_ID = and PB.REMOVE_DATE is NULL and C.REMOVE_DATE is null ; : failed...:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and PB.REMOVE_DATE is NULL and C.REMOVE_DATE is null' at line 1select PB.*, C.NAME, S.SHOP_NAME, S.URL_KEYWORD as S_URL_KEYWORD, C.URL_KEYWORD as C_URL_KEYWORD, T.NAME_E, DATE_FORMAT(PB.RECEIVE_DATE, '%m/%d %k:%i') as D_DATE, SUBSTRING(SUBJECT,1, 8) as D_SUBJECT, SUBSTRING(REPLACE(PB.BODY,'
',''),1, 20) as D_BODY, IF(PB.MIME like 'image%', 'diarypict', 'diarymovie') as DIRBASE, IF(PB.BODY_DECO is not null,1,0) as DECO, 'jpg' as EXT from TRN_PICTBLOG as PB left join MST_CAST as C on PB.CAST_ID = C.CAST_ID left join MST_SHOP as S on PB.SHOP_ID = S.SHOP_ID left join MST_SHOP_SUB_FOR_NUKINAVI as SN on PB.SHOP_ID = SN.SHOP_ID left join MST_TYPE as T on SN.TYPE_ID = T.TYPE_ID where PB.CAST_ID = and PB.REMOVE_DATE is NULL and C.REMOVE_DATE is null order by PB.RECEIVE_DATE DESC LIMIT 0, 15; : failed...:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and PB.REMOVE_DATE is NULL and C.REMOVE_DATE is null order by PB.RECEIVE_DATE DE' at line 1SELECT C.*, S.*, C.URL_KEYWORD as C_URL_KEYWORD, S.URL_KEYWORD as S_URL_KEYWORD, AR.NAME as AREA_NAME, T.NAME as TYPE_NAME, SN.TEL_1, T.NAME_E FROM MST_CAST as C left join MST_SHOP as S on C.SHOP_ID = S.SHOP_ID left join MST_SHOP_SUB_FOR_NUKINAVI as SN on SN.SHOP_ID = S.SHOP_ID left join MST_TYPE as T on SN.TYPE_ID = T.TYPE_ID left join MST_AREA as AR on AR.AREA_ID = SN.AREA_ID WHERE C.CAST_ID = ; : failed...:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
女の子日記・ / 一覧-すすきの風俗・札幌風俗店「ヌキなび北海道」
