File: /var/www/cache/mjmotors/394fa2c77912584daa2e16786c810a006d56f582.php
Line: 102
Undefined constant "NEW_MERCEDES_PAGE" (View: /var/www/templates/BOC2/www/home-page-stock-and-search.blade.php)
File: /var/www/cache/mjmotors/394fa2c77912584daa2e16786c810a006d56f582.php
Line: 102
#0 /var/www/vendor/illuminate/view/Engines/PhpEngine.php(60): Illuminate\View\Engines\CompilerEngine->handleViewException(Object(Illuminate\View\ViewException), 1)
#1 /var/www/vendor/illuminate/view/Engines/CompilerEngine.php(61): Illuminate\View\Engines\PhpEngine->evaluatePath('cache/mjmotors/...', Array)
#2 /var/www/vendor/illuminate/view/View.php(139): Illuminate\View\Engines\CompilerEngine->get('/var/www/templa...', Array)
#3 /var/www/vendor/illuminate/view/View.php(122): Illuminate\View\View->getContents()
#4 /var/www/vendor/illuminate/view/View.php(91): Illuminate\View\View->renderContents()
#5 /var/www/handle-request.php(302): Illuminate\View\View->render()
#6 /var/www/handle-request.php(424): {closure:/var/www/handle-request.php:148}()
#7 {main}
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
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
select
h.dow,
h.open,
h.closed,
h.optional_text
from c_dealer_hours h
where h.dealer_id = 544
order by 1
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
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 1SELECT -- featured cars 544
a.id,
a.description,
a.price,
a.s3_image,
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,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
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,
d.location_name,
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_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.highlighted_sort_key IS NOT NULL
ORDER BY highlighted_sort_key
LIMIT 8SELECT -- featured cars 544
a.id,
a.description,
a.price,
a.s3_image,
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,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
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,
d.location_name,
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_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.highlighted_sort_key IS NULL
AND a.main_image_id IS NOT NULL
AND a.reg_year < 2025
and a.dealer_id = 544
ORDER BY price DESC
LIMIT 8
SELECT
r.id,
r.review,
r.reviewer_name,
r.reviewer_location,
DATE_FORMAT(r.created_at, '%d/%m/%Y') AS created_at,
DATE_FORMAT(r.updated_at, '%d/%m/%Y') AS updated_at,
r.rating,
r.dealer_id
FROM c_dealer_reviews r
WHERE r.STATUS = 'live'
AND r.dealer_id = 544
ORDER BY r.created_at DESC LIMIT 0,3
SELECT
id,
COUNT(rating) total_num,
SUM(rating) total_sum
FROM c_dealer_reviews
WHERE STATUS = 'live'
AND dealer_id = 544SELECT DISTINCT
mk.make,
mk.id AS make_id
FROM c_ads a
INNER JOIN c_makes mk ON a.make_id = mk.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'
ORDER BY mk.make;SELECT
year(now()) - trading_since as years_in_business,
trading_since_date,
total_cars_sold,
total_reviews,
total_cars_for_sale,
youtube_id
from c_dealers
where id = 544Select * from c_body_typesselect -- 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
select distinct -- mtd_prices 544
FLOOR (a.price) price
from c_ads a
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.price is not null
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 price > 0
order by a.price
select distinct -- mtd_prices 544
FLOOR (a.price) price
from c_ads a
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.price is not null
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 price > 0
order by a.price
[CACHED]/var/www/core/www/index.php/var/www/templates/BOC2/www/index.php/var/www/templates/BOC2/www/index.blade.php{
"X-Amz-Cf-Id": "S_3JAiHQMARi61N3UbWe3bVYxa-aZol6jdNTdAMOYcSfQpF_1vHLLw==",
"Via": "2.0 d250acc8f0df4d0f6cf0c8da374c8b8e.cloudfront.net (CloudFront)",
"User-Agent": "Amazon CloudFront",
"Accept-Encoding": "gzip",
"X-Amzn-Trace-Id": "Root=1-6908757d-7429269102365dbb3056b9fa",
"Host": "preview2rmbi7.happydealer.ie",
"X-Forwarded-Port": "443",
"X-Forwarded-Proto": "https",
"X-Forwarded-For": "216.73.216.55, 64.252.114.86",
"X-Hd-Debug": "",
"Content-Length": "",
"Content-Type": ""
}