Avond reparatie

Onze winkels zijn voor vandaag alweer gesloten, maar geen paniek! Deze avond staat ons team voor u klaar tot 21:00 om alsnog uw telefoon te repareren op afspraak!

Bel ons direct: ‭‬‭‬‭06 15 25 26 70‬

YourFix - Contacteer ons voor vragen, problemen of opmerkingen.

Bel nu 072 - 582 4996 (Alkmaar)
072 - 574 3060 (Heerhugowaard)
0224 - 745 223 (Schagen)

Winkelmandje ⁽⁰⁾

Onze vestigingen

YourFix Alkmaar

Langestraat 102
1811 JK Alkmaar

Telefoon	072-5824996
Mobiel	06 15 25 26 70
E-mailadres	alkmaar@yourfix.nl

Maandag	12:00 - 18:00
Dinsdag	09:30 - 18:00
Woensdag	09:30 - 18:00
Donderdag	09:30 - 20:00
Vrijdag	09:30 - 18:00
Zaterdag	09:30 - 17:30
Zondag	12:00 - 17:00

YourFix Heerhugowaard

Middenwaard 48-C
1703 SH Heerhugowaard

Telefoon	072-5743060
Mobiel	0725743060
E-mailadres	hhw@yourfix.nl

Maandag	12:00 - 18:00
Dinsdag	09:30 - 18:00
Woensdag	09:30 - 18:00
Donderdag	09:30 - 18:00
Vrijdag	09:30 - 19:00
Zaterdag	09:30 - 17:00
Zondag	12:00 - 17:00

U kunt alle vragen aan ons stellen via het onderstaande contact formulier. Wij streven ernaar om uw vraag binnen 2 uur te beantwoorden. Onze contact gegevens vindt u aan de rechterzijde van deze pagina.

Extra informatie

Bankgegevens
KVK	67415296
BTW-nummer	NL221043779B01

Bank	ING
T.N.V.	YourFix Heerhugowaard
Rek.nummer	07457060
IBAN	NL07 INGB 0007457060

(default) 47 queries took 90 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `repair_products`	9	9	2
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
3	SHOW FULL COLUMNS FROM `cities`	2	2	3
4	SHOW FULL COLUMNS FROM `timetable`	32	32	5
5	SHOW FULL COLUMNS FROM `locations`	26	26	2
6	SHOW FULL COLUMNS FROM `location_settings`	7	7	2
7	SHOW FULL COLUMNS FROM `messages`	5	5	2
8	SHOW FULL COLUMNS FROM `users`	24	24	2
9	SHOW FULL COLUMNS FROM `user_locations`	3	3	2
10	SHOW FULL COLUMNS FROM `stock_requests`	7	7	2
11	SHOW FULL COLUMNS FROM `daily_cash`	7	7	2
12	SHOW FULL COLUMNS FROM `price_changes`	5	5	2
13	SHOW FULL COLUMNS FROM `repair_problems`	14	14	2
14	SHOW FULL COLUMNS FROM `tags`	2	2	2
15	SHOW FULL COLUMNS FROM `stocks`	9	9	2
16	SHOW FULL COLUMNS FROM `repair_problem_tags`	3	3	2
17	SHOW FULL COLUMNS FROM `repair_problem_stocks`	3	3	2
18	SHOW FULL COLUMNS FROM `view_stats`	12	12	2
19	SHOW FULL COLUMNS FROM `settings`	32	32	2
20	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci';	1	1	1
21	SHOW FULL COLUMNS FROM `reviews`	6	6	2
22	SHOW FULL COLUMNS FROM `mail_queue`	8	8	2
23	SHOW FULL COLUMNS FROM `invoices`	23	23	3
24	SHOW FULL COLUMNS FROM `user_points`	7	7	2
25	SHOW FULL COLUMNS FROM `invoice_rules`	11	11	2
26	SHOW FULL COLUMNS FROM `devices`	15	15	2
27	SHOW FULL COLUMNS FROM `device_types`	2	2	1
28	SHOW FULL COLUMNS FROM `repair_brands`	5	5	2
29	SHOW FULL COLUMNS FROM `device_repairs`	17	17	2
30	SHOW FULL COLUMNS FROM `device_repair_repair_problems`	3	3	2
31	SHOW FULL COLUMNS FROM `device_photos`	6	6	2
32	SHOW FULL COLUMNS FROM `coupons`	15	15	2
33	SHOW FULL COLUMNS FROM `invoice_coupons`	4	4	2
34	SHOW FULL COLUMNS FROM `permission_pages`	3	3	2
35	SHOW FULL COLUMNS FROM `permission_page_level`	3	3	2
36	SHOW FULL COLUMNS FROM `permission_page_user`	3	3	2
37	SHOW FULL COLUMNS FROM `events`	10	10	2
38	SHOW FULL COLUMNS FROM `repair_options`	5	5	2
39	SHOW FULL COLUMNS FROM `repair_option_values`	4	4	2
40	SHOW FULL COLUMNS FROM `shop_articles`	13	13	2
41	SHOW FULL COLUMNS FROM `shop_categories`	3	3	2
42	SELECT `User`.`id`, `User`.`jid`, `User`.`email`, `User`.`pin`, `User`.`enabled`, `User`.`company_name`, `User`.`last_ip`, `User`.`receive_email`, `User`.`password`, `User`.`level`, `User`.`firstname`, `User`.`lastname`, `User`.`address`, `User`.`city`, `User`.`zipcode`, `User`.`telephone`, `User`.`temporarily`, `User`.`hash`, `User`.`tablet_registration`, `User`.`admin_registration`, `User`.`location_id`, `User`.`comment`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`lastname`, ', ', `User`.`firstname`)) AS `User__name`, ((SELECT IFNULL(SUM(`UserPoint`.`points`), 0) FROM user_points as UserPoint WHERE `UserPoint`.`user_id` = `User`.`id` AND `UserPoint`.`redeem_date` >= DATE_SUB(NOW(),INTERVAL 1 YEAR))) AS `User__points`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `users` AS `User` LEFT JOIN `locations` AS `Location` ON (`User`.`location_id` = `Location`.`id`) WHERE `User`.`id` IS NULL LIMIT 1	0	0	1
43	SELECT `Setting`.`title`, `Setting`.`id`, `Setting`.`contact_email`, `Setting`.`homepage_text`, `Setting`.`termsconditions`, `Setting`.`price_text`, `Setting`.`title_users`, `Setting`.`title_pricing`, `Setting`.`title_services`, `Setting`.`title_pages`, `Setting`.`title_news`, `Setting`.`show_notification`, `Setting`.`notification`, `Setting`.`insurance_text`, `Setting`.`service_text`, `Setting`.`meta_description`, `Setting`.`show_big_notification`, `Setting`.`big_notification_title`, `Setting`.`big_notification`, `Setting`.`shipping_costs_limit`, `Setting`.`shipping_costs`, `Setting`.`point_amount_needed`, `Setting`.`money_for_point`, `Setting`.`give_points`, `Setting`.`default_tax`, `Setting`.`invoice_footer`, `Setting`.`promo_code_display`, `Setting`.`promo_code_header`, `Setting`.`promo_code_content`, `Setting`.`coupon_price_minimal`, `Setting`.`quotation_price`, `Setting`.`popup_work_night` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1	1	1	1
44	SELECT `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created`, `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `LocationSetting`.`id`, `LocationSetting`.`location_id`, `LocationSetting`.`report_email`, `LocationSetting`.`invoice_footer`, `LocationSetting`.`show_invoice_stats`, `LocationSetting`.`notification_email`, `LocationSetting`.`contact_text` FROM `locations` AS `Location` LEFT JOIN `timetable` AS `Timetable` ON (`Timetable`.`location_id` = `Location`.`id`) LEFT JOIN `location_settings` AS `LocationSetting` ON (`LocationSetting`.`location_id` = `Location`.`id`) WHERE `Location`.`id` = 1 LIMIT 1	1	1	1
45	SELECT `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created`, `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `LocationSetting`.`id`, `LocationSetting`.`location_id`, `LocationSetting`.`report_email`, `LocationSetting`.`invoice_footer`, `LocationSetting`.`show_invoice_stats`, `LocationSetting`.`notification_email`, `LocationSetting`.`contact_text` FROM `locations` AS `Location` LEFT JOIN `timetable` AS `Timetable` ON (`Timetable`.`location_id` = `Location`.`id`) LEFT JOIN `location_settings` AS `LocationSetting` ON (`LocationSetting`.`location_id` = `Location`.`id`) WHERE `Location`.`is_store` = 1 ORDER BY `Location`.`order` ASC	2	2	1
46	SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Timetable`.`sat_popup` = 1 AND `Timetable`.`sat_closedallday` = 0 AND `Timetable`.`sat_closed` > '18:00:00' AND `Timetable`.`sat_closed` > CURTIME() AND CURTIME() > '18:00:00' AND `Location`.`is_store` = 1	0	0	1
47	SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Location`.`is_store` = 1 AND `Timetable`.`sat_closedallday` = 0 ORDER BY `Timetable`.`sat_closed` DESC LIMIT 1	1	1	1

(default) 47 queries took 90 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `repair_products`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SHOW FULL COLUMNS FROM `cities`

SHOW FULL COLUMNS FROM `timetable`

SHOW FULL COLUMNS FROM `locations`

SHOW FULL COLUMNS FROM `location_settings`

SHOW FULL COLUMNS FROM `messages`

SHOW FULL COLUMNS FROM `users`

SHOW FULL COLUMNS FROM `user_locations`

SHOW FULL COLUMNS FROM `stock_requests`

SHOW FULL COLUMNS FROM `daily_cash`

SHOW FULL COLUMNS FROM `price_changes`

SHOW FULL COLUMNS FROM `repair_problems`

SHOW FULL COLUMNS FROM `tags`

SHOW FULL COLUMNS FROM `stocks`

SHOW FULL COLUMNS FROM `repair_problem_tags`

SHOW FULL COLUMNS FROM `repair_problem_stocks`

SHOW FULL COLUMNS FROM `view_stats`

SHOW FULL COLUMNS FROM `settings`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci';

SHOW FULL COLUMNS FROM `reviews`

SHOW FULL COLUMNS FROM `mail_queue`

SHOW FULL COLUMNS FROM `invoices`

SHOW FULL COLUMNS FROM `user_points`

SHOW FULL COLUMNS FROM `invoice_rules`

SHOW FULL COLUMNS FROM `devices`

SHOW FULL COLUMNS FROM `device_types`

SHOW FULL COLUMNS FROM `repair_brands`

SHOW FULL COLUMNS FROM `device_repairs`

SHOW FULL COLUMNS FROM `device_repair_repair_problems`

SHOW FULL COLUMNS FROM `device_photos`

SHOW FULL COLUMNS FROM `coupons`

SHOW FULL COLUMNS FROM `invoice_coupons`

SHOW FULL COLUMNS FROM `permission_pages`

SHOW FULL COLUMNS FROM `permission_page_level`

SHOW FULL COLUMNS FROM `permission_page_user`

SHOW FULL COLUMNS FROM `events`

SHOW FULL COLUMNS FROM `repair_options`

SHOW FULL COLUMNS FROM `repair_option_values`

SHOW FULL COLUMNS FROM `shop_articles`

SHOW FULL COLUMNS FROM `shop_categories`

SELECT `User`.`id`, `User`.`jid`, `User`.`email`, `User`.`pin`, `User`.`enabled`, `User`.`company_name`, `User`.`last_ip`, `User`.`receive_email`, `User`.`password`, `User`.`level`, `User`.`firstname`, `User`.`lastname`, `User`.`address`, `User`.`city`, `User`.`zipcode`, `User`.`telephone`, `User`.`temporarily`, `User`.`hash`, `User`.`tablet_registration`, `User`.`admin_registration`, `User`.`location_id`, `User`.`comment`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`lastname`, ', ', `User`.`firstname`)) AS `User__name`, ((SELECT IFNULL(SUM(`UserPoint`.`points`), 0) FROM user_points as UserPoint WHERE `UserPoint`.`user_id` = `User`.`id` AND `UserPoint`.`redeem_date` >= DATE_SUB(NOW(),INTERVAL 1 YEAR))) AS `User__points`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `users` AS `User` LEFT JOIN `locations` AS `Location` ON (`User`.`location_id` = `Location`.`id`) WHERE `User`.`id` IS NULL LIMIT 1

SELECT `Setting`.`title`, `Setting`.`id`, `Setting`.`contact_email`, `Setting`.`homepage_text`, `Setting`.`termsconditions`, `Setting`.`price_text`, `Setting`.`title_users`, `Setting`.`title_pricing`, `Setting`.`title_services`, `Setting`.`title_pages`, `Setting`.`title_news`, `Setting`.`show_notification`, `Setting`.`notification`, `Setting`.`insurance_text`, `Setting`.`service_text`, `Setting`.`meta_description`, `Setting`.`show_big_notification`, `Setting`.`big_notification_title`, `Setting`.`big_notification`, `Setting`.`shipping_costs_limit`, `Setting`.`shipping_costs`, `Setting`.`point_amount_needed`, `Setting`.`money_for_point`, `Setting`.`give_points`, `Setting`.`default_tax`, `Setting`.`invoice_footer`, `Setting`.`promo_code_display`, `Setting`.`promo_code_header`, `Setting`.`promo_code_content`, `Setting`.`coupon_price_minimal`, `Setting`.`quotation_price`, `Setting`.`popup_work_night` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1

SELECT `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created`, `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `LocationSetting`.`id`, `LocationSetting`.`location_id`, `LocationSetting`.`report_email`, `LocationSetting`.`invoice_footer`, `LocationSetting`.`show_invoice_stats`, `LocationSetting`.`notification_email`, `LocationSetting`.`contact_text` FROM `locations` AS `Location` LEFT JOIN `timetable` AS `Timetable` ON (`Timetable`.`location_id` = `Location`.`id`) LEFT JOIN `location_settings` AS `LocationSetting` ON (`LocationSetting`.`location_id` = `Location`.`id`) WHERE `Location`.`id` = 1 LIMIT 1

SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Timetable`.`sat_popup` = 1 AND `Timetable`.`sat_closedallday` = 0 AND `Timetable`.`sat_closed` > '18:00:00' AND `Timetable`.`sat_closed` > CURTIME() AND CURTIME() > '18:00:00' AND `Location`.`is_store` = 1

SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Location`.`is_store` = 1 AND `Timetable`.`sat_closedallday` = 0 ORDER BY `Timetable`.`sat_closed` DESC LIMIT 1

Uw naam
E-mailadres
Telefoonnummer
Straat & huisnummer
Postcode & Plaats
Onderwerp
Bericht