SQLCommand:select * from order_table
where order_udate <= date_add( now(), interval -1 day )
and order_date is null
and order_ddate is null
Access denied for user 'atmark-cafe'@'localhost' (using password: NO)SQLCommand:update item_table
set item_recomend = null, item_recomend_date = null
where item_recomend_date < '2024-06-02 00:00:00'
and item_recomend = 1
and item_ddate is null
Access denied for user 'atmark-cafe'@'localhost' (using password: NO) 酒のあきやま　オンラインショップ　-　MB Liquors　グレイス、キュヴェ三澤といったおいしいワインをお届け

酒のあきやま - 千葉県館山市 ワイン

0

毎週火曜日はポイント3倍 酒のあきやまオフィシャル店舗サイトはこちら

「シュヴァリエ」が発掘・お届けするコストパフォーマンス抜群のワインをお愉しみください

13時までのご注文は当日出荷
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)

  • 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)
SQLCommand:select * from item_table
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)
SQLCommand:select * from insert_page_table
where insert_page_position = 2
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

    　休業日　
    は、ご注文への返信、出荷作業はお休みとさせて頂きます。

    短縮営業日
    は、当日出荷できない場合がございます。