delete from whos_online where time_last_click < '1718126223'
insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '3k2smumo1uj8r090b8q3g39p4j', '3.12.150.203', '1718127123', '1718127123', '/faq.php/includes/languages/french/images/ext/megastore_theme/megastore_styles/images/box/P67038576_marantec_D382_handzender.jpg')
select banners_id, date_scheduled from banners where date_scheduled != ''
CREATE TABLE IF NOT EXISTS `buyshop_theme` (
`color_value` varchar(200) NOT NULL,
`slider_type` varchar(200) NOT NULL,
`option_themecolor` varchar(200) NOT NULL,
`option_textcolor` varchar(200) NOT NULL,
`option_linkcolor` varchar(200) NOT NULL,
`option_linkhovercolor` varchar(200) NOT NULL,
`option_bgcolor` varchar(200) NOT NULL,
`option_captions_text_color` varchar(200) NOT NULL,
`option_captions_text_google` varchar(200) NOT NULL
) DEFAULT CHARSET=latin1 AUTO_INCREMENT=2
CREATE TABLE IF NOT EXISTS `custom_menu_block` (
`menu_block_id` int(11) NOT NULL,
`menu_block_content` text NOT NULL,
PRIMARY KEY (`menu_block_id`)
) DEFAULT CHARSET=latin1 AUTO_INCREMENT= 0
CREATE TABLE IF NOT EXISTS `custom_product_block` (
`menu_block_id` int(11) NOT NULL,
`menu_block_content` text NOT NULL,
PRIMARY KEY (`menu_block_id`)
) DEFAULT CHARSET=latin1 AUTO_INCREMENT= 0
CREATE TABLE IF NOT EXISTS `buyshop_stickers` (
`sticker_new_status` varchar(200) NOT NULL,
`sticker_new_position` varchar(200) NOT NULL,
`sticker_sale_status` varchar(200) NOT NULL,
`sticker_sale_position` varchar(200) NOT NULL,
`sticker_options_status` varchar(200) NOT NULL,
`sticker_options_position` varchar(200) NOT NULL
) DEFAULT CHARSET=latin1 AUTO_INCREMENT=2
select distinct c.categories_id, c.parent_id, cd.categories_id, cd.categories_name from categories c, categories_description cd, categories_classes cc where c.categories_id = cd.categories_id and c.parent_id = '0' and cd.language_id='3' and c.cat_class_id = cc.cat_class_id and cc.cat_visible_everywhere = '1' and c.cat_position < '2' order by sort_order, cd.categories_name