SELECT   `T1`.*, `T3`.`Key` AS `Key`, `T3`.`Type` AS `Listing_type`, `T3`.`Parent_keys`, `T3`.`Parent_IDs`, `T3`.`Path` AS `Path`, IF (`T1`.`country` = 'countries_united_kingdom' AND `T1`.`country_level1` = 'countries_united_kingdom_england' AND `T1`.`country_level2` = 'countries_united_kingdom_england_ardington' , 1, 0) AS `mf_filter_match`, IF(`T1`.`country` = 'countries_united_kingdom' AND `T1`.`country_level1` = 'countries_united_kingdom_england' AND `T1`.`country_level2` = 'countries_united_kingdom_england_ardington' , 0, (3956 * 2 * ASIN(SQRT(POWER(SIN((51.5909 - `T1`.`Loc_latitude`) * 0.0174532925 / 2), 2) + COS(51.5909 * 0.0174532925) * COS(`T1`.`Loc_latitude` * 0.0174532925) * POWER(SIN((-1.3772 - `T1`.`Loc_longitude`) * 0.0174532925 / 2), 2))))) AS `mf_distance`, IF(`T1`.`Date` != `T1`.`HighlightDate` AND `T1`.`HighlightDate` != '0000-00-00 00:00:00', '1', '0') as 'is_highlighted', IF(`T1`.`Featured_date` IS NOT NULL, '1', '0') `Featured` FROM `{db_prefix}listings` AS `T1` LEFT JOIN `{db_prefix}categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND `T3`.`Type` = 'electronic_components' AND ((`T1`.`country` = 'countries_united_kingdom' AND `T1`.`country_level1` = 'countries_united_kingdom_england' AND `T1`.`country_level2` = 'countries_united_kingdom_england_ardington') OR (3956 * 2 * ASIN(SQRT( POWER(SIN((51.5909 - `T1`.`Loc_latitude`) * 0.0174532925 / 2), 2) + COS(51.5909 * 0.0174532925) * COS(`T1`.`Loc_latitude` * 0.0174532925) * POWER(SIN((-1.3772 - `T1`.`Loc_longitude`) * 0.0174532925 / 2), 2))) <= 124.27423844747)) AND `T1`.`Sub_status` <> 'invisible' ORDER BY `mf_filter_match` DESC, `mf_distance` ASC, `Featured_date` DESC , `T1`.`date` DESC LIMIT 0, 24 Array
(
    [0] => Array
        (
            [ID] => 982994
            [Category_ID] => 7813
            [Account_ID] => 893
            [Plan_ID] => 40
            [Plan_type] => listing
            [Pay_date] => 2026-08-07 05:41:03
            [Featured_ID] => 0
            [Featured_date] => 
            [Last_show] => 2026-08-21 05:17:32
            [Last_step] => 
            [Last_type] => 
            [Crossed] => 
            [Shows] => 39
            [Main_photo] => 08-2026/ad10054044654/verisense-online-safety-app-protect-you-1333047079.webp
            [Main_photo_x2] => 08-2026/ad10054044654/verisense-online-safety-app-protect-yourse-8978844_x2.webp
            [Photos_count] => 1
            [Status] => active
            [Date] => 2026-08-07 05:40:56
            [lr_rating] => 0
            [lr_rating_votes] => 0
            [Sub_status_data] => 
            [Sub_status] => visible
            [Cron] => 0
            [Cron_notified] => 0
            [Cron_featured] => 0
            [Loc_latitude] => 51.9087035
            [Loc_longitude] => -0.2188012
            [Loc_address] => 
            [condition] => 
            [price] => 
            [country] => countries_united_kingdom
            [country_level1] => countries_united_kingdom_england
            [country_level2] => countries_united_kingdom_england_stevenage
            [address] => Suite 3 Middlesex House, Rutherford Close
            [zip] => SG1 2EF
            [additional_information] => 
            [time_frame] => 
            [title] => Online Safety App
            [description_add] => {|en|}Enjoy secure online experiences using Verisense for surfing the internet – the reliable online safety app. It prevents phishing attacks, identifies suspicious links, detects possible data breaches, and provides notifications to keep your private data safe. With Verisense, it will be easier for you to find out online threats even before they cause any trouble while browsing the internet or while banking. Browse the internet intelligently and securely with this user-friendly security app. Available online, download Verisense now.{|/en|}
            [categories] => 
            [time_frame_date_multi] => 
            [posted_by] => 
            [account_address_on_map] => 0
            [vin] => 
            [built] => 0
            [body_style] => 
            [transmission] => 
            [drive_train] => 
            [engine_cylinders] => 0
            [fuel] => 
            [mileage] => 
            [doors] => 
            [comfort] => 
            [safety] => 
            [sound_system] => 
            [windows] => 
            [other_features] => 
            [bike_type] => 
            [hours] => 0
            [gvm] => 
            [beam_lf] => 
            [length_lf] => 
            [fuel_lf] => 
            [documentation_lf] => 
            [motor_type] => 
            [engine] => 0
            [engine_make] => 
            [engine_model] => 
            [engine_power] => 
            [engine_hours] => 0
            [hull_material] => 
            [boat_name] => 
            [cruising_speed] => 
            [maximum_speed] => 
            [water_tank_capacity] => 
            [water_tank] => 0
            [electronics] => 
            [brand] => 
            [sale_rent] => 
            [bedrooms] => 0
            [bathrooms] => 0
            [square_feet] => 
            [garage] => 0
            [number_of_floors] => 0
            [property_features] => 
            [lot_size] => 
            [phone] => 
            [operating_schedule] => 
            [work_experience] => 
            [sex] => 
            [education] => 
            [job_position] => 
            [job_description] => 
            [salary] => 
            [my_work_experience] => 
            [age] => 
            [citizenship] => 
            [citizenship_level1] => 
            [citizenship_level2] => 
            [resume_doc_file] => 
            [about_me] => 
            [willingness_to_travel] => 
            [willingness_to_relocate] => 0
            [language_proficiency] => 
            [vacancy_url] => 
            [number_of_positions] => 0
            [pay_period] => 
            [lf_zoom] => 13
            [Bumped] => 0
            [HighlightDate] => 0000-00-00 00:00:00
            [Highlight_Plan] => 0
            [Monetize_using_id] => 0
            [event_title] => 
            [event_type] => 1
            [event_date] => 0000-00-00
            [event_date_multi] => 0000-00-00
            [event_desc] => 
            [event_price_type] => 0
            [ref_number] => AD1878332
            [deal_type] => 
            [communication_language] => communication_language_any_language
            [price_event] => 
            [contact_by] => 
            [website] => https://verisense.app/
            [e_mail] => support@verisense.app
            [exterior_color] => 
            [interior_color] => 
            [agency_name] => 
            [company_name] => 
            [affiliate_link] => 
            [loan_amount] => 
            [interest_rate] => 
            [approval_time] => 
            [loan_origination_fee] => 
            [loan_intended_for] => 
            [quantity] => 0
            [Key] => custom_software
            [Listing_type] => electronic_components
            [Parent_keys] => software_and_documentation,other_software_and_documentati
            [Parent_IDs] => 7800,7806
            [Path] => software-and-documentation/other-software-and-documentation/software
            [mf_filter_match] => 0
            [mf_distance] => 54.159817572145926
            [is_highlighted] => 0
            [Featured] => 0
        )

    [1] => Array
        (
            [ID] => 983001
            [Category_ID] => 7660
            [Account_ID] => 823
            [Plan_ID] => 40
            [Plan_type] => listing
            [Pay_date] => 2026-08-11 08:45:33
            [Featured_ID] => 0
            [Featured_date] => 
            [Last_show] => 2026-08-19 16:46:40
            [Last_step] => 
            [Last_type] => 
            [Crossed] => 
            [Shows] => 68
            [Main_photo] => 08-2026/ad10085863612/heat-pump-maintenance-ireland-141187589.webp
            [Main_photo_x2] => 08-2026/ad10085863612/heat-pump-maintenance-ireland-1824780694_x2.webp
            [Photos_count] => 1
            [Status] => active
            [Date] => 2026-08-11 08:45:17
            [lr_rating] => 0
            [lr_rating_votes] => 0
            [Sub_status_data] => 
            [Sub_status] => visible
            [Cron] => 0
            [Cron_notified] => 0
            [Cron_featured] => 0
            [Loc_latitude] => 52.0600343
            [Loc_longitude] => -0.347478
            [Loc_address] => Tullow Street, Carlow, Carlow Urban ED, The Municipal District of Carlow, County Carlow, Leinster, R93 PP79, Ireland
            [condition] => 
            [price] => 00|dollar
            [country] => countries_ireland
            [country_level1] => countries_ireland_leinster
            [country_level2] => countries_ireland_leinster_carlow
            [address] => 5 Tullow Street
            [zip] => R93 F2P7
            [additional_information] => 
            [time_frame] => 
            [title] => Heat pump maintenance Ireland
            [description_add] => {|en|}Many homeowners only require heating during the winter season. Heat pump maintenance Ireland helps ensure the system is ready before then. A heat pump works hard throughout the year. It provides heating when temperatures drop. Many systems also supply hot water daily. That is a lot of work for one system. Over time, dust and wear can affect performance. Small issues may start to appear. The system may take longer to respond. It may also work harder than necessary. Have you noticed any changes recently? Is the system making unusual sounds? Does it seem less effective? These signs are worth noticing. Regular maintenance will identify problems early. It allows homeowners to address issues beforehand. This helps avoid unwanted disruptions later. A proper system is more likely to deliver reliable comfort throughout the year.{|/en|}
            [categories] => 
            [time_frame_date_multi] => 
            [posted_by] => 
            [account_address_on_map] => 0
            [vin] => 
            [built] => 0
            [body_style] => 
            [transmission] => 
            [drive_train] => 
            [engine_cylinders] => 0
            [fuel] => 
            [mileage] => 
            [doors] => 
            [comfort] => 
            [safety] => 
            [sound_system] => 
            [windows] => 
            [other_features] => 
            [bike_type] => 
            [hours] => 0
            [gvm] => 
            [beam_lf] => 
            [length_lf] => 
            [fuel_lf] => 
            [documentation_lf] => 
            [motor_type] => 
            [engine] => 0
            [engine_make] => 
            [engine_model] => 
            [engine_power] => 
            [engine_hours] => 0
            [hull_material] => 
            [boat_name] => 
            [cruising_speed] => 
            [maximum_speed] => 
            [water_tank_capacity] => 
            [water_tank] => 0
            [electronics] => 
            [brand] => 
            [sale_rent] => 
            [bedrooms] => 0
            [bathrooms] => 0
            [square_feet] => 
            [garage] => 0
            [number_of_floors] => 0
            [property_features] => 
            [lot_size] => 
            [phone] => 
            [operating_schedule] => 
            [work_experience] => 
            [sex] => 
            [education] => 
            [job_position] => 
            [job_description] => 
            [salary] => 
            [my_work_experience] => 
            [age] => 
            [citizenship] => 
            [citizenship_level1] => 
            [citizenship_level2] => 
            [resume_doc_file] => 
            [about_me] => 
            [willingness_to_travel] => 
            [willingness_to_relocate] => 0
            [language_proficiency] => 
            [vacancy_url] => 
            [number_of_positions] => 0
            [pay_period] => 
            [lf_zoom] => 13
            [Bumped] => 0
            [HighlightDate] => 0000-00-00 00:00:00
            [Highlight_Plan] => 0
            [Monetize_using_id] => 0
            [event_title] => 
            [event_type] => 1
            [event_date] => 0000-00-00
            [event_date_multi] => 0000-00-00
            [event_desc] => 
            [event_price_type] => 0
            [ref_number] => AD1130956
            [deal_type] => 
            [communication_language] => communication_language_any_language
            [price_event] => 
            [contact_by] => 
            [website] => https://premierheat.ie/heat-pump-maintenance-ireland/
            [e_mail] => info@premierheat.ie
            [exterior_color] => 
            [interior_color] => 
            [agency_name] => 
            [company_name] => 
            [affiliate_link] => 
            [loan_amount] => 
            [interest_rate] => 
            [approval_time] => 
            [loan_origination_fee] => 
            [loan_intended_for] => 
            [quantity] => 0
            [Key] => specialty_cooling_and_heating
            [Listing_type] => electronic_components
            [Parent_keys] => fans_cooling_a_heating_system
            [Parent_IDs] => 6788
            [Path] => fans-cooling-and-heating-systems/specialty-cooling-and-heating-systems
            [mf_filter_match] => 0
            [mf_distance] => 54.58979669943902
            [is_highlighted] => 0
            [Featured] => 0
        )

    [2] => Array
        (
            [ID] => 982939
            [Category_ID] => 7660
            [Account_ID] => 823
            [Plan_ID] => 40
            [Plan_type] => listing
            [Pay_date] => 2026-07-22 08:44:09
            [Featured_ID] => 0
            [Featured_date] => 
            [Last_show] => 2026-08-20 02:05:38
            [Last_step] => 
            [Last_type] => 
            [Crossed] => 
            [Shows] => 60
            [Main_photo] => 07-2026/ad10007309910/seai-heat-pump-installation-ireland-345045542.webp
            [Main_photo_x2] => 07-2026/ad10007309910/seai-heat-pump-installation-ireland-2063463706_x2.webp
            [Photos_count] => 1
            [Status] => active
            [Date] => 2026-07-22 08:44:05
            [lr_rating] => 0
            [lr_rating_votes] => 0
            [Sub_status_data] => 
            [Sub_status] => visible
            [Cron] => 0
            [Cron_notified] => 1
            [Cron_featured] => 0
            [Loc_latitude] => 52.0600343
            [Loc_longitude] => -0.347478
            [Loc_address] => Tullow Street, Carlow, Carlow Urban ED, The Municipal District of Carlow, County Carlow, Leinster, R93 PP79, Ireland
            [condition] => 
            [price] => 00|dollar
            [country] => countries_ireland
            [country_level1] => countries_ireland_leinster
            [country_level2] => countries_ireland_leinster_carlow
            [address] => 5 Tullow Street
            [zip] => R93 F2P7
            [additional_information] => 
            [time_frame] => 
            [title] => SEAI heat pump installation Ireland
            [description_add] => {|en|}Many people want a better way to heat their homes. SEAI heat pump installation Ireland is gaining attention for that reason. Heat pumps are efficient. They are very easy to use. They take heat from the air outside. The system then warms the home when needed. Many homeowners also look at available grants. This can help lower installation costs. As a result, more people consider making the switch. Choosing the right installer is important. They can explain the process clearly. They also help select a suitable system. A heat pump that has proper installation will perform better any day. Energy costs still continue to be a concern for many families. People are looking for reliable heating. Heat pumps help meet that need. They offer comfort, efficiency, and long-term value. {|/en|}
            [categories] => 
            [time_frame_date_multi] => 0000-00-00 00:00:00
            [posted_by] => 
            [account_address_on_map] => 0
            [vin] => 
            [built] => 0
            [body_style] => 
            [transmission] => 
            [drive_train] => 
            [engine_cylinders] => 0
            [fuel] => 
            [mileage] => 
            [doors] => 
            [comfort] => 
            [safety] => 
            [sound_system] => 
            [windows] => 
            [other_features] => 
            [bike_type] => 
            [hours] => 0
            [gvm] => 
            [beam_lf] => 
            [length_lf] => 
            [fuel_lf] => 
            [documentation_lf] => 
            [motor_type] => 
            [engine] => 0
            [engine_make] => 
            [engine_model] => 
            [engine_power] => 
            [engine_hours] => 0
            [hull_material] => 
            [boat_name] => 
            [cruising_speed] => 
            [maximum_speed] => 
            [water_tank_capacity] => 
            [water_tank] => 0
            [electronics] => 
            [brand] => 
            [sale_rent] => 
            [bedrooms] => 0
            [bathrooms] => 0
            [square_feet] => 
            [garage] => 0
            [number_of_floors] => 0
            [property_features] => 
            [lot_size] => 
            [phone] => 
            [operating_schedule] => 
            [work_experience] => 
            [sex] => 
            [education] => 
            [job_position] => 
            [job_description] => 
            [salary] => 
            [my_work_experience] => 
            [age] => 
            [citizenship] => 
            [citizenship_level1] => 
            [citizenship_level2] => 
            [resume_doc_file] => 
            [about_me] => 
            [willingness_to_travel] => 
            [willingness_to_relocate] => 0
            [language_proficiency] => 
            [vacancy_url] => 
            [number_of_positions] => 0
            [pay_period] => 
            [lf_zoom] => 13
            [Bumped] => 0
            [HighlightDate] => 0000-00-00 00:00:00
            [Highlight_Plan] => 0
            [Monetize_using_id] => 0
            [event_title] => 
            [event_type] => 1
            [event_date] => 0000-00-00
            [event_date_multi] => 0000-00-00
            [event_desc] => 
            [event_price_type] => 0
            [ref_number] => AD1226166
            [deal_type] => 
            [communication_language] => communication_language_any_language
            [price_event] => 
            [contact_by] => 
            [website] => https://premierheat.ie/seai-grants/
            [e_mail] => info@premierheat.ie
            [exterior_color] => 
            [interior_color] => 
            [agency_name] => 
            [company_name] => 
            [affiliate_link] => 
            [loan_amount] => 
            [interest_rate] => 
            [approval_time] => 
            [loan_origination_fee] => 
            [loan_intended_for] => 
            [quantity] => 0
            [Key] => specialty_cooling_and_heating
            [Listing_type] => electronic_components
            [Parent_keys] => fans_cooling_a_heating_system
            [Parent_IDs] => 6788
            [Path] => fans-cooling-and-heating-systems/specialty-cooling-and-heating-systems
            [mf_filter_match] => 0
            [mf_distance] => 54.58979669943902
            [is_highlighted] => 0
            [Featured] => 0
        )

)