2017 Alfa Romeo Giulia

2017 Alfa Romeo Giulia

2.2 TD Speciale 180BHP 4DR AUT

2017 Alfa Romeo Giulia

2017 Alfa Romeo Giulia

2017 Alfa Romeo Giulia

2017 Alfa Romeo Giulia

Fuel Type

Diesel

Engine Size

2.1

Bodytype

Saloon

Owners

1

Year

2017

Mileage

60,000 km / 37,283 mi

Transmission

Automatic

Seats

5

Doors

4

Colour

Grey

Make: Alfa Romeo
Model: Giulia
Year: 2017
Price: €37,373
Monthly Price From: €675
Engine Size: 2.1
Mileage: 60,000 km / 37,283 mi
Gearbox: Automatic
Fuel Type: Diesel
Previous Owners: 1
Body Type: Saloon
Seats: 5
Doors: 4
Colour: Grey
Engine Power: 180 BHP
0-62mph: 7.10 seconds
Top Speed: 143 mph
Engine Econ Urban: 53.00 mpg
Engine Econ Rural: 81.00 mpg
Engine Econ Combined: 67.00 mpg
Road Tax: €190
Ratings
Child Occupant:
Adult Occupant:
Overall:
Environmental:
Last Updated: 27/08/2026
172WW1160

More Information

11 Timing belt changed this year. Tan leather interior. Sound driver. Features: Air Conditioning, Alloy Wheels, Anti-Theft System, Automatic Wipers, Bluetooth, Brake Assist System, Central Locking, Climate Control, Cruise Control, Daytime Running Lights, Dual Zone Climate Control, EBD, Electric Seats, Electric Windows, Electronic handbrake, Fog Lamps, Folding rear seats, Heated Front Seats, Heated Seats, Hill-Start Assist, Multi-Function Steering Wheel, Parking Sensors, Remote Central Locking, Sat Nav, Selectable Drive Mode, Sports Seats, Stop/Start Button, Traction Control

Contact Information

Phone

Sales:

Business Address

Milltown Lane, Rathnew,
Co. Wicklow,

Sales Opening Hours

Mon - Sun:

Closed

Aftersales Opening Hours & Contact

Mon:	9:30am - 4:30pm
Tue - Thu:	9:30am - 5:30pm
Fri:	9:30am - 4:30pm
Sat - Sun:	Closed

Aftersales is Closed for Lunch from 1pm to 2pm.
Aftersales does not operate on any Bank Holidays.

Debug Bar(errors: 0, warnings: 69, notices: 20, queries: 28, includes: 2, time: 176.29ms)▲

No errors

Warning: Undefined array key 1

e144146edecc31057ee7f47faad3df90e2bf1088.php:68

Warning: Undefined array key 3

e144146edecc31057ee7f47faad3df90e2bf1088.php:434

Warning: Undefined array key 8

opening-hours.php:57

Warning: Undefined array key 1

130b35c85b854d0d8de6fc3f8ab0675bdbdb62c8.php:13

Warning: Undefined array key 2

nav-bar.php:13

Warning: Undefined variable $is_new_cars_page

nav-bar.php:119

Warning: Undefined array key 3

nav-bar.php:330

Warning: Undefined variable $filter

nav-bar.php:485

Warning: Undefined array key 1

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:11

Warning: Undefined array key 2

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:12

Warning: Undefined variable $whatsapp_phone

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Undefined array key 3

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 4

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 5

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 8

opening-hours.php:57

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:327

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:327

Deprecated: mtd_makes(): Optional parameter $filter declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1127

Deprecated: mtd_makes(): Optional parameter $extra_filters declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1127

Deprecated: Jenssegers\Blade\Blade::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Blade.php:34

Deprecated: Illuminate\Container\Container::beforeResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1114

Deprecated: Illuminate\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1134

Deprecated: Illuminate\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1154

Deprecated: Illuminate\Container\Container::setInstance(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1393

Deprecated: Illuminate\Contracts\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:173

Deprecated: Illuminate\Contracts\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:182

Deprecated: Illuminate\View\FileViewFinder::__construct(): Implicitly marking parameter $extensions as nullable is deprecated, the explicit nullable type must be used instead

FileViewFinder.php:53

Deprecated: Illuminate\Events\Dispatcher::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Dispatcher.php:65

Deprecated: Illuminate\Support\Str::createUuidsUsing(): Implicitly marking parameter $factory as nullable is deprecated, the explicit nullable type must be used instead

Str.php:1007

Deprecated: Illuminate\View\View::render(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

View.php:88

Deprecated: Illuminate\Support\Arr::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:183

Deprecated: Illuminate\Support\Arr::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:212

Deprecated: Illuminate\View\Engines\CompilerEngine::__construct(): Implicitly marking parameter $files as nullable is deprecated, the explicit nullable type must be used instead

CompilerEngine.php:33

Deprecated: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated

mtd.inc:1213

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Total: 28 queries in 143.66ms

#161.44ms

select text_key, value from c_dealer_site_texts where dealer_id = 544

#23.42ms


    select
      d.display_name,
      d.id,
      d.use_display_name_for_consent,
      d.group_id,
      g.name as group_name,
      d.facebook_id,
      d.facebook_url,
      d.youtube_id,
      d.youtube_link,
      d.twitter_link,
      d.instagram_link,
      d.linkedin_link,
      d.tiktok_url,
      d.is_simi,
  	  d.use_km,
      d.email_enquiries,
      d.opening_hours_extra_text,
      d.reservation_days,
      d.reservation_option,
      d.finance_default_deposit_pct,
      d.use_google_reviews,
      d.google_reviews_link,
      d.google_reviews_avg_rating,
      d.google_reviews_total,
      d.finance_start_with_personal_details,
  	  d.principal,
  	  d.principal_title,
      d.slug,
      d.allow_html_description,
      d.finance_default_hp_rate,
      d.finance_default_pcp_rate,
      d.payment_provider,
      d.payment_secret_key_enc,
      d.square_access_token_enc,
      d.square_location_id,
      da.address1,
      da.address2,
      da.address3,
      da.address4,
      da.address5,
      da.postcode,
      da.map_lat,
      da.map_long,
      da.map_zoom,
      r.country_code,
      r.region,
      if (d.reservation_new_option = 0, null,  rp.cost_to_reserve) as cost_to_reserve_new
    from c_dealers d
    left join c_groups g on g.id = d.group_id
    left join c_dealer_addresses da on da.dealer_id = d.id
    left join c_country_regions r on da.region_id = r.id
    left join c_reservation_prices rp on d.reservation_new_price_id = rp.id
    where d.id = 544

#32.89ms


   select
     name,
     phone,
     email,
     is_primary_contact
   from c_dealer_website_contacts
   where dealer_id = 544
    and hide_on_website = 0
   order by sort_key

#42.93ms


    select
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_hours h
    where h.dealer_id = 544
    and h.department_id is null
    order by 1

#55.54ms


    select
    d.slug,
    d.name,
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_departments d
    left join c_dealer_hours h on h.department_id = d.id
    where d.dealer_id = 544
    order by d.sort_order, d.id, h.dow

#62.15ms


    select
    a.id,
    a.s3_image,
    a.main_image_id,
    ai.template_id,
    a.reg_year,
    a.price,
    a.mileage,
    mk.make,
    md.model
    from c_ads a
    inner join c_makes mk on a.make_id = mk.id
    inner join c_models md on a.model_id = md.id
    left join c_ad_images ai on a.main_image_id = ai.id
    where dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      and is_dealer_special = 1

#75.36ms


      select
        a.id,
        a.s3_image,
        a.is_commercial,
        a.external_ad_id,
        a.mileage,
        a.kilometres,
        a.odo_units,
        a.make_id,
        a.model_id,
        a.make_text,
        a.model_text,
        a.reg_year,
        a.price,
		    a.previous_price,
        a.trade_in_price,
        /* a.vrt, */
        /* round(a.vrt_estimate) as vrt_estimate, */
      /* round(a.omsp_for_vrt) as omsp_for_vrt, */
        a.description,
        a.dealer_id,
        a.created_at,
        date_format(a.created_at, '%Y%m%d%H%i%s') as creation_date_fmt,
        date_format(a.expires_at, '%Y%m%d%H%i%s') as expiry_date_fmt,
        /* using dealer updated date not ad updated date */
        d.stock_updated_at as updated_at,
        a.main_image_id,
        ai.template_id as main_template_id,
        /* ifnull(a.email_enquiries_p,0) as email_enquiries_p, */
        d.email,
        a.engine_cc,
        a.hide_extra_info_on_dealer_website,
        /* a.review_id, */
        r.region,
        mk.make,
        mk.category_id,
        md.model,
        /* a.commercial_p, */
        d.display_name,
        d.phone,
        /* d.email_enquiries_p as dealer_enquiries_p, */
        d.group_id,
        /* d.show_web_link_p, */
        d.web,
        /* d.disable_map_p, */
        /* d.simi_p, */
        d.opening_hours_extra_text,
        da.address1,
        da.address2,
        da.address3,
        da.address4,
        da.address5,
        da.postcode,
        da.map_lat,
        da.map_long,
        /* d.youtube_id AS dealer_youtube_id, */
        d.reservation_option as dealer_reservation_option,
        rpd.cost_to_reserve as dealer_cost_to_reserve,
        a.reservation_option as ad_reservation_option,
        rpa.cost_to_reserve as ad_cost_to_reserve,
        a.fuel_type_id,
        fu.fuel_type,
        a.colour_id,
        cl.colour,
        a.colour_description,
        a.body_type_id,
        bd.body_type,
        a.variant,
        a.owners,
        a.transmission_type_id,
        tr.transmission_type,
        a.reg_number,
        /* ifnull(a.contact_name_public_p,0) as contact_name_public_p, */
        /* a.contact_name, */
        if(a.tax_due_date > now(), a.tax_due_date, null) as tax_due_date,
        if(a.test_due_date > now(), a.test_due_date, null) as test_due_date,
        a.co2,
        a.max_power_bhp,
        a.road_tax_cost,
        a.fuel_cons_combined,
        a.doors,
        a.seats,
        a.stock_number,
        d.location_name,
        ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
        a.accel_0_to_62,
        /* a.email_public_p, */
        /* a.phone_no_public_p, */
        a.youtube_id,
        a.video_type,
        a.video_id,
        a.finance_flat_rate_apr,
        a.finance_option,
        a.finance_max_term,
        a.finance_max_deposit,
        if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
        aei.max_power_hp,
        aei.max_power_revs,
        aei.max_torque_nm,
        aei.max_torque_revs,
        aei.fuel_cons_urban,
        aei.fuel_cons_extra_urban,
        aei.max_speed_mph,
        aei.ncap_overall,
        aei.ncap_adult_occupant,
        aei.ncap_child_occupant,
        aei.ncap_adult_pct,
        aei.ncap_child_pct,
        aei.gross_weight_kg,
        aei.unladen_weight_kg,
        aei.wheelbase_mm,
        fbr.balance_remaining_over,
        fbr.balance_remaining_under,
        fbr.over_apr,
        fbr.under_apr,
        a.is_dealer_special,
        a.interior_360_url,
        a.exterior_360_url,
        w.period_months,
        d.use_custom_warranty,
        wt.title as warranty_term,
        a.key_location,
        a.grade,
        a.eta,
        a.turntable_images_count,
        a.licence_type,
        a.colour_interior_description,
        if (d.allow_public_vins = 1, a.vin, null) as vin_encrypted,
        ct.display as cylinders, 
        finoff.label as finance_offer
        /* ad extra info in here if needed */
      from
        c_ads a
      inner join c_models md on a.model_id = md.id
      inner join c_makes mk on a.make_id = mk.id
      left join c_ad_extra_info aei on a.id = aei.ad_id
      left join c_ad_images ai on a.main_image_id = ai.id
      left join c_dealers d on a.dealer_id = d.id
      left join c_dealer_addresses da on d.id = da.dealer_id
      left join c_country_regions r on d.region_id = r.id
      left join c_fuel_types fu on a.fuel_type_id = fu.id
      left join c_colours cl on a.colour_id = cl.id
      left join c_body_types bd on a.body_type_id = bd.id
      left join c_transmission_types tr on a.transmission_type_id = tr.id
      left join c_ad_finance_balance_rates fbr on a.id = fbr.ad_id
      left join c_reservation_prices rpd on d.reservation_price_id = rpd.id
      left join c_reservation_prices rpa on a.reservation_price_id = rpa.id
      left join c_ad_warranties w on a.warranty_id = w.id
      left join c_warranty_terms wt on a.warranty_term_id = wt.id
      left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
      left join c_dealer_finance_offers finoff on a.finance_offer_id = finoff.id
      where a.id = 149931
        and a.deleted_at is null
        and a.paused_at is null
        and a.status = 'live'
       and  a.dealer_id = 544 
      limit 1

#83.01ms

select max(term) from c_ad_finance_calc_results where ad_id = 149931

#92.76ms

select f.deposit_and_trade_in from c_ad_finance_calc_results f where f.ad_id = 149931 order by f.deposit_and_trade_in asc limit 1

#102.95ms

select min(term) from c_ad_finance_calc_results where ad_id = 149931

#112.82ms


      select name, value
      from c_ad_extra_properties aep
      where aep.ad_id = 149931

#126.09ms


    select
      ai.id as image_id,
      ai.template_id,
      a.dealer_id as ad_dealer_id,
      a.main_image_id
    from c_ad_images ai
    inner join c_ads a on a.id = ai.ad_id
    where a.id = 149931
      and ai.deleted_at is null
    order by ai.sort_key

#133.15ms


      select
        ceil(price) as price,
        ceil(deposit_and_trade_in) as deposit_and_trade_in,
        term,
        ceil(loan_amount) as loan_amount,
        apr,
        irr,
        ceil(monthly_payments) as monthly_payments,
        ceil(total_cost_of_credit) as total_cost_of_credit,
        ceil(documentation_fee) as documentation_fee,
        ceil(completion_fee) as completion_fee,
        reg_year
      from c_ad_finance_calc_results
      where ad_id = 149931
      and is_default_term
      order by is_dealer_default desc, deposit_and_trade_in limit 1

#143.09ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1

#152.78ms


      select a.finance_price_per_month from c_ads a where id = 149931

#161.17ms

	
          SELECT	
            r.reviewer_name,	
            r.review,	
            date_format(ifnull(r.updated_at, r.created_at), '%d %b %Y') as date,	
            r.reviewer_location,	
            r.rating	
          FROM c_dealer_reviews r	
          WHERE status = 'live' 	
          AND r.dealer_id = '544'  	
          ORDER BY r.created_at DESC limit 3 [CACHED]

#171.16ms


    SELECT
      id,
      COUNT(rating) total_num,
      SUM(rating) total_sum
    FROM c_dealer_reviews
    WHERE STATUS = 'live'
      AND dealer_id = 544 [CACHED]

#181.27ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#191.21ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#201.2ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#213.55ms

select -- mtd_makes 544
    mk.id, mk.make 
    from c_makes mk
    inner join c_ads a on a.make_id = mk.id
    inner join c_dealers d on a.dealer_id = d.id
    where  a.dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
    
    GROUP BY mk.id, mk.make
    order by mk.make

#223.53ms


select -- mtd_body_types 544
t.id,t.body_type
from c_body_types t
inner join c_ads a on a.body_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id
 
  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.body_type
order by t.body_type

#233.48ms


select -- mtd_fuel_types 544
t.id,t.fuel_type
from c_fuel_types t
inner join c_ads a on a.fuel_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
 where  a.dealer_id = 544
  
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.fuel_type
order by t.sort_key

#243.78ms


select -- mtd_transmission_types 544
t.id,t.transmission_type
from c_transmission_types t
inner join c_ads a on a.transmission_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id 

  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.transmission_type
order by t.transmission_type

#252.9ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit

#263.35ms


    SELECT max(price)
    FROM c_ads a
    INNER JOIN c_dealers d on a.dealer_id = d.id
    
    WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      AND  a.dealer_id = 544

#273.32ms


    SELECT min(price)
    FROM c_ads a
    INNER JOIN c_dealers d on a.dealer_id = d.id
    
    WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      AND  a.dealer_id = 544

#283.35ms

select show_legal_guarantee_notice from c_dealers where id = 544

Project: Modular DealersMemory: 5.31MBTime: 176.29ms