SQLCommand:select * from insert_page_table
where insert_page_position = 1
and insert_page_status = 1
and insert_page_ddate is null
order by isnull( insert_page_display ), insert_page_display, insert_page_id
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)
where insert_page_position = 1
and insert_page_status = 1
and insert_page_ddate is null
order by isnull( insert_page_display ), insert_page_display, insert_page_id
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)
-
INFORMATION お知らせ
SQLCommand:select *,
date_format( information_cdate, '%Y.%m.%d' ) as dt
from information_table
where information_status = 1
and information_ddate is null
and information_cdate <= now()
order by information_cdate desc, information_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO) -
営業カレンダー
2024年 6月 翌月>>
- 日
- 月
- 火
- 水
- 木
- 金
- 土
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
休業日は、ご注文への返信、出荷作業はお休みとさせて頂きます。短縮営業日は、当日出荷できない場合がございます。
SQLCommand:select * from banner_table
where banner_ddate is null
order by isnull( banner_display ), banner_display, banner_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:select distinct category_table.*
from category_table
inner join item_category_table on item_category_category = category_id
inner join item_table on item_category_item = item_id and item_ddate is null and item_password is null and item_status = 1
where category_top = 1
and category_ddate is null
order by isnull( category_display ), category_display, category_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)
where item_status = 1
and item_recomend = 1
and item_ddate is null
and item_password is null
and ( item_indate is null or item_indate <= now() )
and ( item_closedate is null or item_closedate >= now() )
order by case when item_stock <= 0 then 2 else 1 end, isnull( item_recomend_display) desc, item_recomend_display, isnull( item_display ) desc, item_display, item_id desc
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)