- SQLCommand:select *,
date_format( blog_odate, '%Y-%m-%d' ) as odate,
date_format( blog_odate, '%w' ) as wdate
from blog_table
left join company_table on blog_company = company_id and company_ddate is null and company_status = 1
left join bcategory_table on blog_bcategory = bcategory_id
where blog_odate <= now()
and blog_status = 1
and blog_ddate is null
order by blog_odate, blog_udate desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)
SQLCommand:select company_id, company_name, company_display, count( blog_id ) as cnt
from company_table
inner join blog_table on company_id = blog_company and blog_ddate is null and blog_status = 1 and blog_odate <= now()
group by company_id, company_name, company_display
order by company_display, company_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:select bcategory_id, bcategory_name, bcategory_display, count( blog_id ) as cnt
from bcategory_table
inner join blog_table on bcategory_id = blog_bcategory and blog_ddate is null and blog_status = 1 and blog_odate <= now()
group by bcategory_id, bcategory_name, bcategory_display
order by bcategory_display, bcategory_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:select date_format( blog_odate, '%Y年%c月' ) as dt,
date_format( blog_odate, '%Y%m' ) as dt2,
count( blog_id ) as cnt
from blog_table
where blog_odate <= now()
and blog_ddate is null
and blog_status = 1
group by date_format( blog_odate, '%Y年 %c月' ), date_format( blog_odate, '%Y/%m' )
order by date_format( blog_odate, '%Y%m' ) desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)
from company_table
inner join blog_table on company_id = blog_company and blog_ddate is null and blog_status = 1 and blog_odate <= now()
group by company_id, company_name, company_display
order by company_display, company_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:select bcategory_id, bcategory_name, bcategory_display, count( blog_id ) as cnt
from bcategory_table
inner join blog_table on bcategory_id = blog_bcategory and blog_ddate is null and blog_status = 1 and blog_odate <= now()
group by bcategory_id, bcategory_name, bcategory_display
order by bcategory_display, bcategory_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:select date_format( blog_odate, '%Y年%c月' ) as dt,
date_format( blog_odate, '%Y%m' ) as dt2,
count( blog_id ) as cnt
from blog_table
where blog_odate <= now()
and blog_ddate is null
and blog_status = 1
group by date_format( blog_odate, '%Y年 %c月' ), date_format( blog_odate, '%Y/%m' )
order by date_format( blog_odate, '%Y%m' ) desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)