-
update banners_history set banners_shown = banners_shown + 1 where banners_id = '7' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
delete from whos_online where time_last_click < '1718125993'
update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '18.116.49.224', time_last_click = '1718126893', last_page_url = '/index.php/images/light/includes/languages/dutch/images/megastore_theme/megastore_js/images/icons/credit-card-icon.png' where session_id = ''
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='4' 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
VAT and shipping costsCurrently VAT rates and shipping costs are displayed for NL, to change choose the correct country below: |
Language: |
My Account
Log In Create an Account CheckoutLanguage:
DeutschEnglishFrançaisNederlandsPolskiVAT and shipping costs
Currently VAT rates and shipping costs are displayed for NL, to change choose the correct country below:
Currency selection
Euro (€)Polish Zloty (zł)U.S. Dollar ($)Pounds Sterling (£)Customer Service
Safe payment Shipping Returns Frequently asked questions ContactsThis website (New-remote.com) is a division of Parts United Home Products.
Contact phone:
+31 88 844 02 98
E-mail address:
info@new-remote.com
Office address:
Hoorn 159
2404HH, Alphen aan den Rijn
Nederland
Chamber of Commerce number: 64977781
VAT number: NL855931061B01
Currently VAT rates and shipping costs are displayed for NL, to change choose the correct country below: