2011 Ariel Atom

14 people viewing

Price Change Notification

2011 Ariel Atom

14 people viewing

Live enquiries in the past 24 hours

Price Change Notification

Our Price

€123

Monthly from

n/a

0.7 Bio gas

Manual

Panel Van

123 km / 76 mi

Test Drive Delivery

Closed today!

Make an Enquiry

Apply for Finance

No finance available on this vehicle

Pay for this vehicle using a credit or debit card securely through our payment partner Stripe.

€123

Buy Online Now

The above quote is for illustrative purposes only. Your monthly repayments, rates and fees will be confirmed after your finance application has been accepted and approved by our lending partner(s). All applications are subject to lender verification.

REF376134

Fuel Type

Bio gas

Engine Size

0.7

Bodytype

Panel Van

Year

2011

Mileage

123 km / 76 mi

Transmission

Manual

Colour

Brown

Make: Ariel
Model: Atom
Year: 2011
Price: €123
Monthly Price From: n/a
Engine Size: 0.7
Mileage: 123 km / 76 mi
Gearbox: Manual
Fuel Type: Bio gas
Body Type:Panel Van
Colour: Brown
Last Updated: 27/08/2026

More Information

123

REF376134


    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
   [CACHED]

#33.63ms


   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
   [CACHED]

#41.21ms


    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
   [CACHED]

#51.21ms


    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
   [CACHED]

#62.37ms


    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

#74.66ms


      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 = 376134
        and a.deleted_at is null
        and a.paused_at is null
        and a.status = 'live'
       and  a.dealer_id = 544 
      limit 1

#81.99ms

select max(term) from c_ad_finance_calc_results where ad_id = 376134

#91.74ms

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

#101.86ms

select min(term) from c_ad_finance_calc_results where ad_id = 376134

#113.03ms


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

#121.21ms


        select
          d.payment_publishable_key_enc,
          d.payment_secret_key_enc,
          d.square_access_token_enc,
          d.square_refresh_token_enc,
          d.square_access_token_expire,
          d.square_location_id
        from c_dealers d
        where d.id = 544 [CACHED]

#133.27ms


    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 = 376134
      and ai.deleted_at is null
    order by ai.sort_key

#141.95ms


      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 = 376134
      and is_default_term
      order by is_dealer_default desc, deposit_and_trade_in limit 1

#151.31ms


  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]

#163.01ms


      select a.finance_price_per_month from c_ads a where id = 376134

#171.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 1 [CACHED]

#181.17ms


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

#191.29ms


  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.21ms

select display_name, email from c_dealers where id = 544 [CACHED]

#216.99ms

SELECT
  a.id,
  a.s3_image,
  a.description,
  a.price,
  a.previous_price,
  a.reg_year,
  if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
  if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
  a.variant,
  a.owners,
  a.test_due_date,
  a.mileage,
  a.kilometres,
  a.updated_at,
  a.engine_cc,
  a.key_location,
  d.location_name,
  ct.display as cylinders, 
  ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
  fin.apr as apr,
  DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
  f.fuel_type,
  t.transmission_type,
  b.body_type,
  c.rgb_hex,
  c.colour,
  a.main_image_id,
  ai.template_id,
  a.youtube_id,
  a.video_type,
  a.video_id,
  ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
  a.dealer_id as ad_dealer_id,
  if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
  exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
  (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
  
  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
  INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
  INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
  INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
  INNER JOIN c_dealers d on a.dealer_id = d.id
  left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
  
  left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
  LEFT JOIN c_body_types b ON a.body_type_id = b.id
  LEFT JOIN c_colours c ON a.colour_id = c.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 
   and a.model_id = 2026 and a.id not in (376134) 
  order by a.updated_at desc 
  LIMIT 8

#224.31ms

SELECT
  a.id,
  a.s3_image,
  a.description,
  a.price,
  a.previous_price,
  a.reg_year,
  if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
  if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
  a.variant,
  a.owners,
  a.test_due_date,
  a.mileage,
  a.kilometres,
  a.updated_at,
  a.engine_cc,
  a.key_location,
  d.location_name,
  ct.display as cylinders, 
  ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
  fin.apr as apr,
  DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
  f.fuel_type,
  t.transmission_type,
  b.body_type,
  c.rgb_hex,
  c.colour,
  a.main_image_id,
  ai.template_id,
  a.youtube_id,
  a.video_type,
  a.video_id,
  ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
  a.dealer_id as ad_dealer_id,
  if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
  exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
  (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
  
  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
  INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
  INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
  INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
  INNER JOIN c_dealers d on a.dealer_id = d.id
  left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
  
  left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
  LEFT JOIN c_body_types b ON a.body_type_id = b.id
  LEFT JOIN c_colours c ON a.colour_id = c.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 
   and a.make_id = 157 and a.id not in (376134) 
  order by a.updated_at desc 
  LIMIT 8

#234.45ms

SELECT
  a.id,
  a.s3_image,
  a.description,
  a.price,
  a.previous_price,
  a.reg_year,
  if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
  if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
  a.variant,
  a.owners,
  a.test_due_date,
  a.mileage,
  a.kilometres,
  a.updated_at,
  a.engine_cc,
  a.key_location,
  d.location_name,
  ct.display as cylinders, 
  ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
  fin.apr as apr,
  DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
  f.fuel_type,
  t.transmission_type,
  b.body_type,
  c.rgb_hex,
  c.colour,
  a.main_image_id,
  ai.template_id,
  a.youtube_id,
  a.video_type,
  a.video_id,
  ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
  a.dealer_id as ad_dealer_id,
  if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
  exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
  (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
  
  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
  INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
  INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
  INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
  INNER JOIN c_dealers d on a.dealer_id = d.id
  left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
  
  left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
  LEFT JOIN c_body_types b ON a.body_type_id = b.id
  LEFT JOIN c_colours c ON a.colour_id = c.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 
   and a.body_type_id = 19 and a.id not in (376134) 
  order by a.updated_at desc 
  LIMIT 8

#244.29ms

SELECT
  a.id,
  a.s3_image,
  a.description,
  a.price,
  a.previous_price,
  a.reg_year,
  if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
  if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
  a.variant,
  a.owners,
  a.test_due_date,
  a.mileage,
  a.kilometres,
  a.updated_at,
  a.engine_cc,
  a.key_location,
  d.location_name,
  ct.display as cylinders, 
  ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
  fin.apr as apr,
  DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
  f.fuel_type,
  t.transmission_type,
  b.body_type,
  c.rgb_hex,
  c.colour,
  a.main_image_id,
  ai.template_id,
  a.youtube_id,
  a.video_type,
  a.video_id,
  ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
  a.dealer_id as ad_dealer_id,
  if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
  exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
  (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
  
  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
  INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
  INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
  INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
  INNER JOIN c_dealers d on a.dealer_id = d.id
  left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
  
  left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
  LEFT JOIN c_body_types b ON a.body_type_id = b.id
  LEFT JOIN c_colours c ON a.colour_id = c.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 
   and a.reg_year = 2011 and a.id not in (376134) 
  order by a.updated_at desc 
  LIMIT 8

#254.3ms

SELECT
  a.id,
  a.s3_image,
  a.description,
  a.price,
  a.previous_price,
  a.reg_year,
  if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
  if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
  a.variant,
  a.owners,
  a.test_due_date,
  a.mileage,
  a.kilometres,
  a.updated_at,
  a.engine_cc,
  a.key_location,
  d.location_name,
  ct.display as cylinders, 
  ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
  fin.apr as apr,
  DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
  f.fuel_type,
  t.transmission_type,
  b.body_type,
  c.rgb_hex,
  c.colour,
  a.main_image_id,
  ai.template_id,
  a.youtube_id,
  a.video_type,
  a.video_id,
  ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
  a.dealer_id as ad_dealer_id,
  if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
  exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
  (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
  
  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
  INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
  INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
  INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
  INNER JOIN c_dealers d on a.dealer_id = d.id
  left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
  
  left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
  LEFT JOIN c_body_types b ON a.body_type_id = b.id
  LEFT JOIN c_colours c ON a.colour_id = c.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 
   and a.reg_year = 2010 and a.id not in (376134) 
  order by a.updated_at desc 
  LIMIT 8

#261.26ms


        select
          d.payment_publishable_key_enc,
          d.payment_secret_key_enc,
          d.square_access_token_enc,
          d.square_refresh_token_enc,
          d.square_access_token_expire,
          d.square_location_id
        from c_dealers d
        where d.id = 544 [CACHED]

#273.26ms


  SELECT deposit_and_trade_in
  FROM c_ad_finance_calc_results
  WHERE ad_id = 376134
  ORDER BY deposit_and_trade_in

#281.19ms


  SELECT deposit_and_trade_in
  FROM c_ad_finance_calc_results
  WHERE ad_id = 376134
  ORDER BY deposit_and_trade_in
   [CACHED]

#291.23ms


  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]

#301.22ms


  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]

#311.24ms

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 [CACHED]

#321.2ms


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
   [CACHED]

#331.2ms


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
 [CACHED]

#341.22ms


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
   [CACHED]

#351.74ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#361.26ms


    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 [CACHED]

#371.25ms


    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 [CACHED]

#381.23ms

select show_legal_guarantee_notice from c_dealers where id = 544 [CACHED]

Project: Modular DealersMemory: 6.23MBTime: 175.06ms

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

€123

n/a

2011 Ariel Atom

€123

n/a

2011 Ariel Atom

Car Details

Fuel Type

Engine Size

Bodytype

Year

Mileage

Transmission

Colour

More Information

You may also like

Get in Touch

Find us

Sales Opening Hours

Aftersales Opening Hours & Contact

€123

n/a

2011 Ariel Atom

€123

n/a

2011 Ariel Atom

Car Details

Fuel Type

Engine Size

Bodytype

Year

Mileage

Transmission

Colour

More Information

You may also like

Apply for Finance

Finance This Car

Get in Touch

Find us

Sales Opening Hours

Aftersales Opening Hours & Contact