Mechanika Maszyn i Mechanika Pojazdowa Karol Meckien
Kowalewo 34A, Szubin
Naprawa pomp wtryskowych, silników diesela.
Trzciński Piotr Przedsiębiorstwo Wielobranżowe
ul. Pałucka 39, Szubin
"Leksus" Przedsiębiorstwo Handlowo-Usługowe Ryszard Koźma
ul. Konopnickiej 8, Szubin
Moto-Centrum Stanisław Zieliński
ul. L.W.P. 11, Szubin
Mostowa 15, Szubin
Sportowa 11, Szubin
ul. Sienkiewicza 25, Szubin
Kcyńska 7, Szubin
Banaszak Dariusz Zakład Mechaniki Pojazdowej
Smolniki 29, Szubin
Gąbin 16, Szubin
Serdecznie zapraszamy do skorzystania z usług naszego warsztatu!. Zajmujemy się elektryką, elektromechaniką, mechaniką pojazdową a takze serwisem klimatyzacji. Obsługujemy samochody zarówno dostawcze jak i osobowe. Warsztat czynny od...
Paweł O. | Moto-Centrum Stanisław Zieliński
Polecam usług w Moto-Centrum. Wszystkie naprawy wykonywane rzeteleni, profesjonalnie i w terminie !
P.C. | Mechanika Maszyn i Mechanika Pojazdowa Karol Meckien
Kilkukrotnie korzystałem już tutaj z usług naprawy pomp wtryskowych do japońskich ciągników ( Kubota, Yanmar, Iseki ). Zawsze pompa była należycie naprawiona, terminowo - bez jakichkolwiek...
Kurinho | Mechanika Maszyn i Mechanika Pojazdowa Karol Meckien
Powiem krótko- dobra robota :) chłopaki z warsztatu mieli dużo pojęcia i wiedzę o robocie. uszczelnili mi pompę, ustawili odpowiednią dawke przy tym ustawili zapłon (poprawka po poprzednim...
Zadowolona klientka | PGAUTO Paweł Ginter
Pan Paweł jest bardzo rzetelny i uczciw, a przy tym sympatyczny . Udzielił mi wyczerpujacych informacji ma temat usterki, tego co wymieniał i dlaczego. Pełen profesjonalizm. Gorąco polecam!
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `specializations` | 5 | 5 | 1 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | |
3 | SHOW FULL COLUMNS FROM `mechanics_services` | 6 | 6 | 1 | |
4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_polish_ci'; | 1 | 1 | 0 | |
5 | SHOW FULL COLUMNS FROM `mechanics` | 95 | 95 | 1 | |
6 | SHOW FULL COLUMNS FROM `areas` | 2 | 2 | 1 | |
7 | SHOW FULL COLUMNS FROM `comments` | 49 | 49 | 1 | |
8 | SHOW FULL COLUMNS FROM `users` | 26 | 26 | 1 | |
9 | SHOW FULL COLUMNS FROM `answers` | 6 | 6 | 1 | |
10 | SHOW FULL COLUMNS FROM `comments_histories` | 5 | 5 | 1 | |
11 | SHOW FULL COLUMNS FROM `images` | 8 | 8 | 1 | |
12 | SHOW FULL COLUMNS FROM `histories` | 6 | 6 | 1 | |
13 | SHOW FULL COLUMNS FROM `pricing_fixed` | 8 | 8 | 0 | |
14 | SHOW FULL COLUMNS FROM `pricing_services` | 13 | 13 | 1 | |
15 | SHOW FULL COLUMNS FROM `pricing_categories` | 5 | 5 | 0 | |
16 | SHOW FULL COLUMNS FROM `services` | 24 | 24 | 1 | |
17 | SHOW FULL COLUMNS FROM `symptoms` | 6 | 6 | 1 | |
18 | SHOW FULL COLUMNS FROM `categories` | 9 | 9 | 1 | |
19 | SHOW FULL COLUMNS FROM `mechanics_categories` | 3 | 3 | 1 | |
20 | SHOW FULL COLUMNS FROM `mechanics_symptoms` | 3 | 3 | 0 | |
21 | SHOW FULL COLUMNS FROM `categories_symptoms` | 3 | 3 | 1 | |
22 | SHOW FULL COLUMNS FROM `services_symptoms` | 3 | 3 | 1 | |
23 | SHOW FULL COLUMNS FROM `mechanics_specializations` | 3 | 3 | 1 | |
24 | SHOW FULL COLUMNS FROM `articles` | 29 | 29 | 1 | |
25 | SHOW FULL COLUMNS FROM `articles_categories` | 10 | 10 | 1 | |
26 | SHOW FULL COLUMNS FROM `articles_files` | 8 | 8 | 1 | |
27 | SHOW FULL COLUMNS FROM `tags` | 4 | 4 | 0 | |
28 | SHOW FULL COLUMNS FROM `articles_tags` | 2 | 2 | 0 | |
29 | SHOW FULL COLUMNS FROM `articles_services` | 3 | 3 | 0 | |
30 | SHOW FULL COLUMNS FROM `calendar_events` | 53 | 53 | 1 | |
31 | SHOW FULL COLUMNS FROM `calendar_phones` | 6 | 6 | 1 | |
32 | SHOW FULL COLUMNS FROM `calendar_notes` | 7 | 7 | 0 | |
33 | SHOW FULL COLUMNS FROM `calendar_events_services` | 3 | 3 | 0 | |
34 | SHOW FULL COLUMNS FROM `mechanic_selected` | 12 | 12 | 1 | |
35 | SHOW FULL COLUMNS FROM `mechanic_survey_users_answers` | 7 | 7 | 1 | |
36 | SHOW FULL COLUMNS FROM `mechanic_pricings` | 11 | 11 | 1 | |
37 | SHOW FULL COLUMNS FROM `mechanic_saas` | 6 | 6 | 0 | |
38 | SHOW FULL COLUMNS FROM `mechanic_contracts` | 45 | 45 | 1 | |
39 | SHOW FULL COLUMNS FROM `mechanic_contract_notes` | 8 | 8 | 0 | |
40 | SHOW FULL COLUMNS FROM `mechanics_tags` | 3 | 3 | 0 | |
41 | SELECT COUNT(*) AS `count` FROM `mechanics` AS `Mechanic` LEFT JOIN `mechanics_ranks` AS `MechanicsRanks` ON (`Mechanic`.`id` = `MechanicsRanks`.`mechanic_id` AND `MechanicsRanks`.`context` = 'max-gmv') LEFT JOIN `images` AS `Image` ON (`Mechanic`.`id` = `Image`.`mechanic_id` AND `Image`.`is_main` = 1) LEFT JOIN `mechanic_saas` AS `MechanicSaas` ON (`MechanicSaas`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`slug_city` = 'szubin' AND `Mechanic`.`state` = 1 AND (`Mechanic`.`premium` = 0 OR (SELECT COUNT(*) FROM mechanics_services AS Services WHERE `Services`.`mechanic_id` = `Mechanic`.`id`) >= 30) | 1 | 1 | 0 | |
42 | SELECT `Image`.*, `Mechanic`.`id`, `Mechanic`.`user_id`, `Mechanic`.`user_active`, `Mechanic`.`not_interested`, `Mechanic`.`warranty_flag`, `Mechanic`.`name`, `Mechanic`.`slug_name`, `Mechanic`.`city`, `Mechanic`.`slug_city`, `Mechanic`.`address`, `Mechanic`.`quarter`, `Mechanic`.`quarter_slug`, `Mechanic`.`certified_at`, `Mechanic`.`comments`, `Mechanic`.`rating_total`, `Mechanic`.`closed`, `Mechanic`.`calendar`, `Mechanic`.`phone`, `Mechanic`.`premium`, `Mechanic`.`premium_vip`, `Mechanic`.`calendar_events_confirmed`, `Mechanic`.`calendar_events_total`, `Mechanic`.`calendar_events_last`, `Mechanic`.`calendar_events_confirmed_month`, `Mechanic`.`calendar_vacation`, `Mechanic`.`calendar_vacation_from`, `Mechanic`.`calendar_vacation_to`, `Mechanic`.`additional`, `Mechanic`.`flag`, `Mechanic`.`premium_to`, `Mechanic`.`calendar_free_at`, `Mechanic`.`ranking_points`, `Mechanic`.`ranking_suggested`, `Mechanic`.`google_x`, `Mechanic`.`google_y`, `Mechanic`.`open_hours`, `MechanicSaas`.`saas_id`, `MechanicSaas`.`autobooking_enabled` FROM `mechanics` AS `Mechanic` LEFT JOIN `mechanics_ranks` AS `MechanicsRanks` ON (`Mechanic`.`id` = `MechanicsRanks`.`mechanic_id` AND `MechanicsRanks`.`context` = 'max-gmv') LEFT JOIN `images` AS `Image` ON (`Mechanic`.`id` = `Image`.`mechanic_id` AND `Image`.`is_main` = 1) LEFT JOIN `mechanic_saas` AS `MechanicSaas` ON (`MechanicSaas`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`slug_city` = 'szubin' AND `Mechanic`.`state` = 1 AND (`Mechanic`.`premium` = 0 OR (SELECT COUNT(*) FROM mechanics_services AS Services WHERE `Services`.`mechanic_id` = `Mechanic`.`id`) >= 30) ORDER BY `MechanicsRanks`.`ranking` DESC, `Mechanic`.`closed` ASC, `Mechanic`.`user_active` ASC LIMIT 25 | 10 | 10 | 1 | |
43 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (13) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
44 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (2342) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
45 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (2941) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
46 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (3148) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
47 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (11371) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
48 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (42931) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
49 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (2741) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
50 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (18340) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
51 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (31202) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 0 | 0 | 0 | |
52 | SELECT `MechanicPricing`.*, (SELECT PricingService.pricing_category_id FROM pricing_services as PricingService where id = MechanicPricing.pricing_service_id) as pricing_category_id, `MechanicPricing`.`mechanic_id` FROM `mechanic_pricings` AS `MechanicPricing` WHERE `MechanicPricing`.`promoted` = (1) AND IFNULL((SELECT `PricingService`.`surcharge` FROM pricing_services as PricingService where id = `MechanicPricing`.`pricing_service_id`), 0) = 0 AND `MechanicPricing`.`mechanic_id` = (46054) ORDER BY `MechanicPricing`.`name` ASC LIMIT 3 | 3 | 3 | 0 | |
53 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (13) LIMIT 1 | 0 | 0 | 0 | |
54 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (2342) LIMIT 1 | 0 | 0 | 0 | |
55 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (2941) LIMIT 1 | 0 | 0 | 0 | |
56 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (3148) LIMIT 1 | 0 | 0 | 0 | |
57 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (11371) LIMIT 1 | 0 | 0 | 0 | |
58 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (42931) LIMIT 1 | 0 | 0 | 0 | |
59 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (2741) LIMIT 1 | 0 | 0 | 0 | |
60 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (18340) LIMIT 1 | 0 | 0 | 0 | |
61 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (31202) LIMIT 1 | 0 | 0 | 0 | |
62 | SELECT `MechanicContract`.`last_added`, `MechanicContract`.`product`, `MechanicContract`.`mechanic_id` FROM `mechanic_contracts` AS `MechanicContract` WHERE `MechanicContract`.`last_added` = 1 AND `MechanicContract`.`mechanic_id` = (46054) LIMIT 1 | 1 | 1 | 0 | |
63 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`count`, `Tag`.`usage`, `MechanicsTag`.`id`, `MechanicsTag`.`mechanic_id`, `MechanicsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `mechanics_tags` AS `MechanicsTag` ON (`MechanicsTag`.`mechanic_id` IN (13, 2342, 2941, 3148, 11371, 42931, 2741, 18340, 31202, 46054) AND `MechanicsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`usage` IN ('public_label', 'public_badge') ORDER BY `Tag`.`name` ASC | 0 | 0 | 0 | |
64 | SELECT `Service`.`id`, `Service`.`parent_id`, `Service`.`lft`, `Service`.`rght`, `Service`.`name`, `Service`.`name_slug`, `Service`.`state`, `Service`.`has_price`, `Service`.`is_main`, `Service`.`meta_title`, `Service`.`meta_keywords`, `Service`.`meta_description`, `Service`.`seo_name`, `Service`.`seo_description`, `Service`.`seo_breadcrumb`, `Service`.`districts`, `Service`.`adwords`, `Service`.`adwords_keywords`, `Service`.`content`, `Service`.`layout`, `Service`.`thumb_name`, `Service`.`leed`, `Service`.`pattern_exp`, `Service`.`pattern_order` FROM `services` AS `Service` WHERE `Service`.`state` = 1 ORDER BY `Service`.`lft` asc | 236 | 236 | 3 | |
65 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'autoszyby-wymiana-szyb' LIMIT 1 | 1 | 1 | 0 | |
66 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 68 | 1 | 1 | 0 | |
67 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-dachu-panoramicznego' LIMIT 1 | 1 | 1 | 0 | |
68 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 262 | 1 | 1 | 0 | |
69 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'klejenie-szyb' LIMIT 1 | 1 | 1 | 0 | |
70 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 168 | 1 | 1 | 0 | |
71 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'polerowanie-szyb-samochodowych' LIMIT 1 | 1 | 1 | 0 | |
72 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 201 | 1 | 1 | 0 | |
73 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'przyciemnianie-szyb-samochodowych' LIMIT 1 | 1 | 1 | 0 | |
74 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 51 | 1 | 1 | 0 | |
75 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'szyby-do-ciagnikow' LIMIT 1 | 1 | 1 | 0 | |
76 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 171 | 1 | 1 | 0 | |
77 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-szyby-bocznej' LIMIT 1 | 1 | 1 | 0 | |
78 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 47 | 1 | 1 | 0 | |
79 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-szyby-przedniej' LIMIT 1 | 1 | 1 | 0 | |
80 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 46 | 1 | 1 | 0 | |
81 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-szyby-tylnej' LIMIT 1 | 1 | 1 | 0 | |
82 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 48 | 1 | 1 | 0 | |
83 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'blacharstwo-samochodowe' LIMIT 1 | 1 | 1 | 0 | |
84 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 60 | 1 | 1 | 0 | |
85 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-podluznic' LIMIT 1 | 1 | 1 | 0 | |
86 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 229 | 1 | 1 | 0 | |
87 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-progow' LIMIT 1 | 1 | 1 | 0 | |
88 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 224 | 1 | 1 | 0 | |
89 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'car-audio-nawigacje-samochodowe' LIMIT 1 | 1 | 1 | 0 | |
90 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 101 | 1 | 1 | 0 | |
91 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'cb-radia-montaz' LIMIT 1 | 1 | 1 | 0 | |
92 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 77 | 1 | 1 | 0 | |
93 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'rozkodowanie-radia' LIMIT 1 | 1 | 1 | 0 | |
94 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 245 | 1 | 1 | 0 | |
95 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'diesel-serwis' LIMIT 1 | 1 | 1 | 0 | |
96 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 81 | 1 | 1 | 0 | |
97 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-pomp-wtryskowych' LIMIT 1 | 1 | 1 | 0 | |
98 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 152 | 1 | 1 | 0 | |
99 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'pompowtryskiwacze-naprawa-regeneracja' LIMIT 1 | 1 | 1 | 0 | |
100 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 153 | 1 | 1 | 0 | |
101 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wtryskiwacze-common-rail-naprawa' LIMIT 1 | 1 | 1 | 0 | |
102 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 154 | 1 | 1 | 0 | |
103 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'dorabianie-kluczy-samochodowych' LIMIT 1 | 1 | 1 | 0 | |
104 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 84 | 1 | 1 | 0 | |
105 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'immobilizer-montaz-naprawa' LIMIT 1 | 1 | 1 | 0 | |
106 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 312 | 1 | 1 | 0 | |
107 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'kodowanie-kluczyka' LIMIT 1 | 1 | 1 | 0 | |
108 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 209 | 1 | 1 | 0 | |
109 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'elektromechanik' LIMIT 1 | 1 | 1 | 0 | |
110 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 65 | 1 | 1 | 0 | |
111 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-abs' LIMIT 1 | 1 | 1 | 0 | |
112 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 125 | 1 | 1 | 0 | |
113 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'adaptacja-przepustnicy' LIMIT 1 | 1 | 1 | 0 | |
114 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 253 | 1 | 1 | 0 | |
115 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-esp' LIMIT 1 | 1 | 1 | 0 | |
116 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 195 | 1 | 1 | 0 | |
117 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-licznikow-samochodowych' LIMIT 1 | 1 | 1 | 0 | |
118 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 129 | 1 | 1 | 0 | |
119 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-mechanizmu-podnoszenia-szyb' LIMIT 1 | 1 | 1 | 0 | |
120 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 257 | 1 | 1 | 0 | |
121 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-silniczka-dmuchawy' LIMIT 1 | 1 | 1 | 0 | |
122 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 226 | 1 | 1 | 0 | |
123 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'system-start-stop-naprawa-wylaczanie' LIMIT 1 | 1 | 1 | 0 | |
124 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 225 | 1 | 1 | 0 | |
125 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'elektronika-samochodowa' LIMIT 1 | 1 | 1 | 0 | |
126 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 110 | 1 | 1 | 0 | |
127 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-wyswietlaczy-samochodowych' LIMIT 1 | 1 | 1 | 0 | |
128 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 309 | 1 | 1 | 0 | |
129 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'poduszki-powietrzne' LIMIT 1 | 1 | 1 | 0 | |
130 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 128 | 1 | 1 | 0 | |
131 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'montaz-i-naprawa-tempomatu' LIMIT 1 | 1 | 1 | 0 | |
132 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 311 | 1 | 1 | 0 | |
133 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'elektryk-samochodowy' LIMIT 1 | 1 | 1 | 0 | |
134 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 59 | 1 | 1 | 0 | |
135 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'czujniki-parkowania' LIMIT 1 | 1 | 1 | 0 | |
136 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 200 | 1 | 1 | 0 | |
137 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-hamulca-recznego-elektrycznego' LIMIT 1 | 1 | 1 | 0 | |
138 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 273 | 1 | 1 | 0 | |
139 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-podgrzewania-szyby' LIMIT 1 | 1 | 1 | 0 | |
140 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 260 | 1 | 1 | 0 | |
141 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-przelacznika-zespolonego' LIMIT 1 | 1 | 1 | 0 | |
142 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 246 | 1 | 1 | 0 | |
143 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'alternatory-wymiana-naprawa' LIMIT 1 | 1 | 1 | 0 | |
144 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 116 | 1 | 1 | 0 | |
145 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'regeneracja-rozrusznika' LIMIT 1 | 1 | 1 | 0 | |
146 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 117 | 1 | 1 | 0 | |
147 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-stacyjki' LIMIT 1 | 1 | 1 | 0 | |
148 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 198 | 1 | 1 | 0 | |
149 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'swiatla-dzienne-led' LIMIT 1 | 1 | 1 | 0 | |
150 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 131 | 1 | 1 | 0 | |
151 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'test-akumulatora' LIMIT 1 | 1 | 1 | 0 | |
152 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 238 | 1 | 1 | 0 | |
153 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-bezpiecznika' LIMIT 1 | 1 | 1 | 0 | |
154 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 196 | 1 | 1 | 0 | |
155 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-czujnika-kata-skretu' LIMIT 1 | 1 | 1 | 0 | |
156 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 230 | 1 | 1 | 0 | |
157 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-przewodow-zaplonowych' LIMIT 1 | 1 | 1 | 0 | |
158 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 115 | 1 | 1 | 0 | |
159 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-swiec-zaplonowych' LIMIT 1 | 1 | 1 | 0 | |
160 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 113 | 1 | 1 | 0 | |
161 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-swiec-zarowych' LIMIT 1 | 1 | 1 | 0 | |
162 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 114 | 1 | 1 | 0 | |
163 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-zarnika-xenonowego' LIMIT 1 | 1 | 1 | 0 | |
164 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 207 | 1 | 1 | 0 | |
165 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-zarowki' LIMIT 1 | 1 | 1 | 0 | |
166 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 130 | 1 | 1 | 0 | |
167 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'centralne-zamki' LIMIT 1 | 1 | 1 | 0 | |
168 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 96 | 1 | 1 | 0 | |
169 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'kalibracja-kamer-i-radarow' LIMIT 1 | 1 | 1 | 0 | |
170 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 335 | 1 | 1 | 0 | |
171 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'hybrydy-auta-elektryczne' LIMIT 1 | 1 | 1 | 0 | |
172 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 109 | 1 | 1 | 0 | |
173 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'diagnostyka-silnika-elektrycznego' LIMIT 1 | 1 | 1 | 0 | |
174 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 326 | 1 | 1 | 0 | |
175 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'diagnostyka-silnikow-hybrydowych' LIMIT 1 | 1 | 1 | 0 | |
176 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 327 | 1 | 1 | 0 | |
177 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'mobilny-serwis-hybryd' LIMIT 1 | 1 | 1 | 0 | |
178 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 328 | 1 | 1 | 0 | |
179 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-alternatorow-hybrydowych' LIMIT 1 | 1 | 1 | 0 | |
180 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 329 | 1 | 1 | 0 | |
181 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'naprawa-hybrydowego-ukladu-napedowego' LIMIT 1 | 1 | 1 | 0 | |
182 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 330 | 1 | 1 | 0 | |
183 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'regeneracja-baterii-hybrydowych' LIMIT 1 | 1 | 1 | 0 | |
184 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 331 | 1 | 1 | 0 | |
185 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'sprawdzenie-samochodu-hybrydowego-przed-zakupem' LIMIT 1 | 1 | 1 | 0 | |
186 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 332 | 1 | 1 | 0 | |
187 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'test-akumulatora-hybrydowego' LIMIT 1 | 1 | 1 | 0 | |
188 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 333 | 1 | 1 | 0 | |
189 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'wymiana-baterii-hybrydowej' LIMIT 1 | 1 | 1 | 0 | |
190 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 334 | 1 | 1 | 0 | |
191 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'instalacje-lpg-auto-gaz' LIMIT 1 | 1 | 1 | 0 | |
192 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 64 | 1 | 1 | 0 | |
193 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'legalizacja-butli-lpg' LIMIT 1 | 1 | 1 | 0 | |
194 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 148 | 1 | 1 | 0 | |
195 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'montaz-instalacji-lpg' LIMIT 1 | 1 | 1 | 0 | |
196 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 144 | 1 | 1 | 0 | |
197 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'reduktory-lpg-czyszczenie-wymiana' LIMIT 1 | 1 | 1 | 0 | |
198 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 140 | 1 | 1 | 0 | |
199 | SELECT `Service`.`id` FROM `services` AS `Service` WHERE `Service`.`name_slug` = 'regeneracja-wtryskiwaczy-lpg' LIMIT 1 | 1 | 1 | 0 | |
200 | SELECT COUNT(*) AS `count` FROM `mechanics_services` AS `MechanicsService` LEFT JOIN `mechanics` AS `Mechanic` ON (`MechanicsService`.`mechanic_id` = `Mechanic`.`id`) WHERE `Mechanic`.`state` = 1 AND `Mechanic`.`closed` = 0 AND `Mechanic`.`slug_city` = 'szubin' AND `MechanicsService`.`service_id` = 146 | 1 | 1 | 0 |