Our world your way!

Servicing your Bike

GOTO :- Basic service | Advanced service | Standalone Jobs | Accessory fitting | Maintenance 'Podcasts'

About bike servicing


It is important that you keep your bike well maintained, so that it
• ensures that your components last longer
• performs at its best
• is a pleasure to ride

Some maintenance can be carried out at home with a workstand and the right tools and there are maintenance 'podcasts' at the bottom of the page to help you, particularly to change an inner tube or tyre. All of our mechanics are trained to the highest standards with Cytech qualifications. We can open at 8am during the week to enable you to get your bike in before you go to work and close at 8pm to give you plenty of time to collect your bike after work.

3 Services in Year 1 - Free of charge


During the first few weeks of riding, parts of the bike may work their way loose or move out of alignment. This can lead to reduced performance and possible undue wear, hence there is free service during the early weeks. This service is actaully a free basic service. In fact, there are 3 free services in the first year which give us the opportunity to guarantee the smooth running of your bike and cover any warranty issues should they arise.

Types of Service


There are two types of service, basic and advanced service. The basic service is a general check-over and, depending on use, is carried out as and when you feel performance has degraded. The enhanced service is a complete overhaul and involves stripping your bike down to the frame and its components - see below.

Suspension Servicing


Suspension servicing should be carried out regularly depending on use

Other Servicing


Finally other servicing ranges from wheel building to puncture repair fitting a cycle accessory

Workshop price list




Back to Top

Basic Service £30.00*


Recommended at least once per year, depending on use

Frame & Forks
• Wiped down and checked for alignment

Wheels
• Hubs and rims checked for damage and wear
• Bearings checked for free movement and adjusted (if applicable)
• Wheels trued and spokes retensioned

Tyres
• Tyres and sidewalls checked for wear and inflated to correct pressure

Headset
• Checked for free movement and adjusted as necessary

Bottom Bracket
• Checked for free movement and adjusted as necessary

Bolts
• Checked and tightened to correct torque

Drive Train (chainset, derailleurs, chain and cassette/block)
• Removed, cleaned, checked for wear and re-lubricated

Brakes
• Checked for effective operation and adjusted
*Excludes cost of parts

Possible Basic Service Extras

Prices applicable when booked with a Basic Service only

• FREE - Fitting single cable See 'podcast' £5.00* - Fitting one cable set See 'podcast'
• £16.00* - Fitting all cable sets
• £ 5.00* - Tyre fitting (each)
• £15.00* - Bottom Bracket fitting
• £15.00* - Headset fitting
• £10.00* - Hub servicing (each)
• £16.00* - Hub servicing (pair)
• £12.50* - Disc brake bleeding (each)
• £20.00* - Disc brake bleeding (pair)
*Excludes cost of parts


Back to Top

Advanced Service £75.00*


Full strip down to frame and forks. Recommended every 12 to 18 months, depending on use

Includes all of the above work, plus...

Frame & Forks
• Frame cleaned and checked for alignment and damage, threads cleaned and checked
• Frame and Disc mounts faced (if applicable)

Wheels
• Hubs disassembled, cleaned, inspected and reassembled

Headset
• Removed, cleaned, regreased (if applicable), refitted & checked for movement (replacement fitted if necessary)*

Bottom Bracket
• Removed, cleaned, regreased (if applicable), refitted & checked for movement (replacement fitted if necessary)*

All Other Components
• Removed, checked for wear, cleaned and re-lubricated
• New cable set fitted* See 'podcast'
• New grips/bar tape fitted*
*Excludes cost of parts
Possible Extended Service Extras Prices applicable when booked with a Extended Service only
• £ 5.00* - Tyre fitting (each) See 'podcast'
• £12.50* - Disc brake bleeding (each)
• £20.00* - Disc brake bleeding (pair)
*Exludes cost of parts

Suspension Servicing


Includes cost of seals and oil. Any other parts required will incur additional charges although no further labour charge.
**Additional £25.00 charge if fork/rear shock requires removal and refitting to the bike. If fork and rear shock are serviced together there is only the single £25.00 charge.



Back to Top

Standalone Jobs


• £ 5.00* - Replace inner tube See 'podcast'
• £ 5.00* - Replace tyre See 'podcast'
• £10.00* - Replace inner tube - Specialist wheels
• £10.00* - Wheel True (Plus £1.00 labour charge for each spoke replaced)
• £ 7.50* - Front Wheel Assembly (Fitting rim tape, tyre and tube)
• £10.00* - Front Wheel Assembly & Fitting (Fitting rim tape, tyre, tube and adjusting brakes)
• £10.00* - Rear Wheel Assembly (Fitting cassette, rim tape, tyre and tube)
• £15.00* - Rear Wheel Assembly & Fitting (Fitting cassette, rim tape, tyre, tube and adjusting brakes and gears)
• £10.00* - Hub Service (per hub)
• £27.50 - Wheel Build (per wheel) (Includes double butted spokes. Specialist spokes extra)

*** Specialist wheels - hub gears etc £20.00

Other Services
• £12.50* - Disc Brake Bleeding (each)
• £20.00* - Disc Brake Bleeding (pair)
• FREE - Safety Check
• £15.00* - Headset (Includes frame preparation)
• £15.00* - Bottom Bracket (Includes frame preparation)



Back to Top

Accessory Fitting Charges Usually free if part of new bike purchase

• £25.00* - Suspension Fork (£12.50 if fitted at the time of fork purchase)
• £10.00* - Full Mudguard Sets
• £ 7.50* - Clip-On Mudguard Sets
• £ 7.50* - Computer (£5.00 extra for Cadence/Flightdeck style)
• £ 7.50* - Lights (Individual or set)
• £ 7.50* - Rack
• £ 5.00* - Saddle/Seat Post
• £10.00* - Grips/Bar tape
• £ 5.00* - Lock
• £ 5.00* - Pump
• £5.00* - Bottle Cage
• £5.00* - Pedals
• £7.50* - Cleats
*Excludes cost of parts

Notice: Incorrect integer value: '' for column `factorydirectbik_db`.`whos_online`.`cookies_allowed` at row 1 in /home/factorydirectbik/public_html/modules/script_open_start.php on line 3648
INSERT INTO whos_online (
					session_id,
					ip_address,
					time_started,
					time_last_click,
					no_of_clicks,
					q_ref,
					cookies_allowed,
					cookie_prefs,
					last_page_url,
					referer,
					email_id,
					customer_id,
					cart_id,
					uk_client,
					user_type,
					ecomm_country,
					allowed_to_trade,
				hostname,
				ext_sess_id
					)
				VALUES (
					'a216901249871022347e5611f8fb6c7d',
					'3.237.71.23',
					'1600417847',
					'1600417847',
					'1',
					'',
					'',
					':1280:Yes:No:Medium:Yes:No:No:No:Yes',
					'/control/bicycle_maintenance/',
					'',
					'0',
					'0',
					'0',
					'1',
					'-1',
					'UNITED STATES',
					'1',
				'ec2-3-237-71-23.compute-1.amazonaws.com',
				'umpI55vvxRHrvqnx'
					)

/home/factorydirectbik/public_html/modules/script_open_start.php:3600
/home/factorydirectbik/public_html/p_include/script_close.php:340
/home/factorydirectbik/public_html/index.php:225
/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37
Notice: Out of range value for column 'error_log_master_id' at row 1 in /home/factorydirectbik/public_html/modules/script_open_start.php on line 3648
INSERT INTO error_log_detail ( error_log_id, segment, details ) VALUES ( '320453', '0', '±M~script_open_start~1600417847.0057±±/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ±/home/factorydirectbik/public_html/modules/script_open_start.php:40 ±/home/factorydirectbik/public_html/p_include/script_open.php:5 ±/home/factorydirectbik/public_html/index.php:35 ±/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ±SELECT * from mobile_agents ;  - UPDATE Record count 22±± start DB1600417847.0081±±/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ±/home/factorydirectbik/public_html/modules/script_open_start.php:132 ±/home/factorydirectbik/public_html/p_include/script_open.php:5 ±/home/factorydirectbik/public_html/index.php:35 ±/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ±SELECT * from master_config where id = 0  - UPDATE Record count 1±' ), ( '320453', '1', '' ), ( '320453', '2', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '3', '/home/factorydirectbik/public_html/modules/script_open_start.php:147 ' ), ( '320453', '4', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '5', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '6', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '7', 'SELECT * from configs where id = '3' - UPDATE Record count 1' ), ( '320453', '8', '' ), ( '320453', '9', '' ), ( '320453', '10', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '11', '/home/factorydirectbik/public_html/modules/script_open_start.php:169 ' ), ( '320453', '12', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '13', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '14', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '15', 'SELECT * FROM `factorydirectbik_db`.`html` ; - UPDATE Record count 28' ), ( '320453', '16', '' ), ( '320453', '17', '' ), ( '320453', '18', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '19', '/home/factorydirectbik/public_html/modules/script_open_start.php:203 ' ), ( '320453', '20', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '21', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '22', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '23', 'SELECT * from users WHERE deleted = 0 ; - UPDATE Record count 1' ), ( '320453', '24', '' ), ( '320453', '25', ' globals1600417847.0139' ), ( '320453', '26', 'ENV Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '320453', '27', 'ENV Key TEMP : Value /tmp' ), ( '320453', '28', 'ENV Key TMP : Value /tmp' ), ( '320453', '29', 'ENV Key TMPDIR : Value /tmp' ), ( '320453', '30', 'ENV Key PWD : Value /' ), ( '320453', '31', 'SERVER Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '320453', '32', 'SERVER Key TEMP : Value /tmp' ), ( '320453', '33', 'SERVER Key TMP : Value /tmp' ), ( '320453', '34', 'SERVER Key TMPDIR : Value /tmp' ), ( '320453', '35', 'SERVER Key PWD : Value /' ), ( '320453', '36', 'SERVER Key HTTP_ACCEPT : Value text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' ), ( '320453', '37', 'SERVER Key HTTP_ACCEPT_LANGUAGE : Value en-US,en;q=0.5' ), ( '320453', '38', 'SERVER Key CONTENT_LENGTH : Value 0' ), ( '320453', '39', 'SERVER Key HTTP_HOST : Value www.factorydirectbikes.com' ), ( '320453', '40', 'SERVER Key HTTP_USER_AGENT : Value CCBot/2.0 (https://commoncrawl.org/faq/)' ), ( '320453', '41', 'SERVER Key HTTP_X_FORWARDED_FOR : Value ::ffff:3.237.71.23' ), ( '320453', '42', 'SERVER Key HTTP_X_FORWARDED_HOST : Value www.factorydirectbikes.com' ), ( '320453', '43', 'SERVER Key HTTP_X_FORWARDED_PORT : Value 80' ), ( '320453', '44', 'SERVER Key HTTP_X_FORWARDED_PROTO : Value http' ), ( '320453', '45', 'SERVER Key HTTP_X_FORWARDED_SERVER : Value www.factorydirectbikes.com' ), ( '320453', '46', 'SERVER Key HTTP_GEOIP_ADDR : Value 3.237.71.23' ), ( '320453', '47', 'SERVER Key HTTP_GEOIP_CONTINENT_CODE : Value NA' ), ( '320453', '48', 'SERVER Key HTTP_GEOIP_COUNTRY_CODE : Value US' ), ( '320453', '49', 'SERVER Key HTTP_GEOIP_COUNTRY_NAME : Value United States' ), ( '320453', '50', 'SERVER Key UNIQUE_ID : Value X2RwNrnqQwJRGjwEE6PI7gAAAUs' ), ( '320453', '51', 'SERVER Key GEOIP_ADDR : Value 3.237.71.23' ), ( '320453', '52', 'SERVER Key GEOIP_CONTINENT_CODE : Value NA' ), ( '320453', '53', 'SERVER Key GEOIP_COUNTRY_CODE : Value US' ), ( '320453', '54', 'SERVER Key GEOIP_COUNTRY_NAME : Value United States' ), ( '320453', '55', 'SERVER Key SCRIPT_URL : Value /control/bicycle_maintenance/' ), ( '320453', '56', 'SERVER Key SCRIPT_URI : Value http://www.factorydirectbikes.com/control/bicycle_maintenance/' ), ( '320453', '57', 'SERVER Key SERVER_SIGNATURE : Value ' ), ( '320453', '58', 'SERVER Key SERVER_SOFTWARE : Value Apache' ), ( '320453', '59', 'SERVER Key SERVER_NAME : Value www.factorydirectbikes.com' ), ( '320453', '60', 'SERVER Key SERVER_ADDR : Value 89.187.86.8' ), ( '320453', '61', 'SERVER Key SERVER_PORT : Value 80' ), ( '320453', '62', 'SERVER Key REMOTE_ADDR : Value 3.237.71.23' ), ( '320453', '63', 'SERVER Key DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '320453', '64', 'SERVER Key REQUEST_SCHEME : Value http' ), ( '320453', '65', 'SERVER Key CONTEXT_PREFIX : Value ' ), ( '320453', '66', 'SERVER Key CONTEXT_DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '320453', '67', 'SERVER Key SERVER_ADMIN : Value webmaster@factorydirectbikes.com' ), ( '320453', '68', 'SERVER Key SCRIPT_FILENAME : Value /home/factorydirectbik/public_html/control/bicycle_maintenance/index.php' ), ( '320453', '69', 'SERVER Key REMOTE_PORT : Value 51464' ), ( '320453', '70', 'SERVER Key SERVER_PROTOCOL : Value HTTP/1.1' ), ( '320453', '71', 'SERVER Key REQUEST_METHOD : Value GET' ), ( '320453', '72', 'SERVER Key QUERY_STRING : Value ' ), ( '320453', '73', 'SERVER Key REQUEST_URI : Value /control/bicycle_maintenance/' ), ( '320453', '74', 'SERVER Key SCRIPT_NAME : Value /control/bicycle_maintenance/index.php' ), ( '320453', '75', 'SERVER Key PHP_SELF : Value /control/bicycle_maintenance/index.php' ), ( '320453', '76', 'SERVER Key REQUEST_TIME_FLOAT : Value 1600417846.9845' ), ( '320453', '77', 'SERVER Key REQUEST_TIME : Value 1600417846' ), ( '320453', '78', 'F~identify_ip_location~1600417847.014' ), ( '320453', '79', '' ), ( '320453', '80', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '81', '/home/factorydirectbik/public_html/modules/script_open_start.php:495 ' ), ( '320453', '82', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '83', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '84', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '85', 'SELECT[crnl]				a.iso3,[crnl]				b.iso2,[crnl]				b.country,[crnl]				c.allow[crnl]			   FROM[crnl]				ip_country AS a[crnl]				LEFT OUTER JOIN ip_country_codes AS b	ON a.iso3 = b.iso3[crnl]				LEFT OUTER JOIN ecomm_countries AS c	ON b.iso2 = c.abrev_name[crnl]			   WHERE[crnl]				a.ip_start <= '65881879' AND a.ip_end >= '65881879'[crnl]				 - UPDATE Record count 1' ), ( '320453', '86', '' ), ( '320453', '87', ' ip_tracker1600417847.0335' ), ( '320453', '88', '' ), ( '320453', '89', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '90', '/home/factorydirectbik/public_html/modules/script_open_start.php:543 ' ), ( '320453', '91', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '92', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '93', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '94', 'SELECT ipt_id, created, updated, hits, strike, banned_until FROM ip_tracker WHERE ip_address = '3.237.71.23'  - UPDATE Record count 1' ), ( '320453', '95', '' ), ( '320453', '96', '' ), ( '320453', '97', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '98', '/home/factorydirectbik/public_html/modules/script_open_start.php:575 ' ), ( '320453', '99', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '100', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '101', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '102', 'UPDATE ip_tracker SET updated = '1600417847', hits = '6'  WHERE ipt_id = '26083'  - UPDATE Record count 1' ), ( '320453', '103', ' get all ip_recs1600417847.0342' ), ( '320453', '104', '' ), ( '320453', '105', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '106', '/home/factorydirectbik/public_html/modules/script_open_start.php:616 ' ), ( '320453', '107', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '108', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '109', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '110', 'SELECT[crnl]					t.created,[crnl]					b.ip_id AS banned_id,	b.hits AS banned_hits,[crnl]					u.ip_id AS uk_id,		u.hits AS uk_hits, 		u.cookies_allowed AS uk_cookies_allowed, u.who AS uk_who, u.notes AS uk_notes,[crnl]					n.ip_id AS non_uk_id,	n.hits AS non_uk_hits,	n.cookies_allowed AS non_uk_cookies_allowed, n.who AS non_uk_who, n.notes AS non_uk_notes,[crnl]					r.ip_id AS robot_id,	r.hits AS robot_hits,	r.cookies_allowed AS robot_cookies_allowed,[crnl]					s.ip_id AS scraper_id,	s.hits AS scraper_hits,	s.cookies_allowed AS scraper_cookies_allowed, s.price_adjustment[crnl]					FROM ip_tracker	AS t[crnl]					LEFT OUTER JOIN banned_ip_addresses	AS b	on t.ip_address	= b.ip_address[crnl]					LEFT OUTER JOIN ip_addresses		AS u	on t.ip_address	= u.ip_address[crnl]					LEFT OUTER JOIN non_uk_ip_addresses	AS n	on t.ip_address	= n.ip_address[crnl]					LEFT OUTER JOIN robot_ip_addresses	AS r	on t.ip_address	= r.ip_address[crnl]					LEFT OUTER JOIN scraper_ip_addresses	AS s	on t.ip_address	= s.ip_address[crnl]					WHERE t.ip_address = '3.237.71.23'  - UPDATE Record count 1' ), ( '320453', '111', '' ), ( '320453', '112', ' ip_robot' ), ( '320453', '113', ' Screen shot processing1600417847.0348 whos_online' ), ( '320453', '114', '' ), ( '320453', '115', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '116', '/home/factorydirectbik/public_html/modules/script_open_start.php:957 ' ), ( '320453', '117', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '118', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '119', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '120', 'SELECT * FROM whos_online WHERE session_id = 'a216901249871022347e5611f8fb6c7d' ; - UPDATE Record count 0' ), ( '320453', '121', '' ), ( '320453', '122', '' ), ( '320453', '123', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '124', '/home/factorydirectbik/public_html/modules/script_open_start.php:1066 ' ), ( '320453', '125', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320453', '126', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '127', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '128', 'SELECT session_id FROM whos_online WHERE ext_sess_id = 'umpI55vvxRHrvqnx' - UPDATE Record count 0' ), ( '320453', '129', '' ), ( '320453', '130', ' read_cookies read_cookies =  check_cookies = -1 cookies_accepted =  screen_width = 1600417847.0355' ), ( '320453', '131', ' set_screen_width1600417847.0356' ), ( '320453', '132', 'P~initialize_script~1600417847.0056~' ), ( '320453', '133', '' ), ( '320453', '134', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '135', '/home/factorydirectbik/public_html/p_include/script_open.php:143 ' ), ( '320453', '136', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320453', '137', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '138', 'SELECT * from html where page_id = '302'  - UPDATE Record count 1' ), ( '320453', '139', '' ), ( '320453', '140', 'T~/control/bicycle_maintenance/index.php~1600417847.036' ), ( '320453', '141', 'M~display_nav_tabs_3~1600417847.0372' ), ( '320453', '142', '' ), ( '320453', '143', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '144', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:34 ' ), ( '320453', '145', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320453', '146', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '147', 'SELECT s.showroom_id, b.brand_id, s.name	AS showroom_name, s.description	AS showroom_description, s.ranking	AS showroom_ranking, b.name	AS brand_name, b.description	AS brand_description, b.hover_title	AS brand_hover_title, i.image_id	AS brand_image_id, i.file_type, i.original	AS brand_image_name, i.sub_folder, i.description, b.ranking FROM showrooms	AS s LEFT OUTER JOIN brand_showroom_matrix	AS bsm	ON s.showroom_id = bsm.showroom_id LEFT OUTER JOIN brands	AS b	ON bsm.brand_id = b.brand_id LEFT OUTER JOIN images	AS i	ON b.image_id = i.image_id WHERE s.deleted = 0 AND b.deleted = 0 AND bsm.deleted = 0 AND s.display = 1 and b.display = 1 ORDER BY s.ranking ASC, b.ranking ASC  - UPDATE Record count 4' ), ( '320453', '148', '' ), ( '320453', '149', '' ), ( '320453', '150', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '151', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:100 ' ), ( '320453', '152', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320453', '153', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '154', 'SELECT s.showroom_id, s.name					AS showroom_name, s.description		AS description, s.display				AS display, c.category_id, c.name					AS category_name, c.description		AS category_description, c.hover_title		AS category_hover_title, c.ranking				AS category_ranking, sc.sub_category_id, sc.name					AS sub_category_name, sc.description	AS sub_category_description, sc.hover_title	AS sub_category_hover_title FROM showrooms AS s LEFT OUTER JOIN categories AS c				ON s.showroom_id = c.showroom_id LEFT OUTER JOIN sub_categories AS sc	ON c.category_id = sc.category_id WHERE s.deleted = 0 AND s.display = 1 AND c.deleted = 0 ORDER BY s.ranking ASC, c.ranking ASC  - UPDATE Record count 41' ), ( '320453', '155', '' ), ( '320453', '156', '' ), ( '320453', '157', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '158', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:161 ' ), ( '320453', '159', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320453', '160', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '161', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21  - UPDATE Record count 14' ), ( '320453', '162', '' ), ( '320453', '163', '' ), ( '320453', '164', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '165', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:204 ' ), ( '320453', '166', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320453', '167', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '168', 'SELECT m.showroom_id		AS showroom_id, sp.brand_id			AS brand_id, m.category_id		AS category_id, m.sub_category_id	AS sub_category_id, p.offer_price		AS offer_price, p.offer_starts	AS offer_starts, p.offer_ends		AS offer_ends, s.showroom_id		AS showroom_id, s.name					AS showroom_name, s.ranking				AS showroom_ranking, b.name					AS brand_name, b.ranking				AS ranking, c.name					AS category_name, c.ranking				AS category_ranking, sc.name					AS sub_category_name FROM product_category_matrix			AS m LEFT OUTER JOIN stub_products	AS sp	ON sp.product_id = m.product_id LEFT OUTER JOIN products		AS p	ON sp.product_id = p.product_id LEFT OUTER JOIN showrooms		AS s	ON sp.showroom_id = s.showroom_id LEFT OUTER JOIN brands			AS b	ON sp.brand_id = b.brand_id LEFT OUTER JOIN categories	AS c	ON m.category_id = c.category_id LEFT OUTER JOIN sub_categories	AS sc	ON m.sub_category_id = sc.sub_category_id WHERE sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND m.deleted = 0 ORDER BY  s.ranking ASC, b.ranking ASC, c.category_id ASC, sc.sub_category_id ASC - UPDATE Record count 1905' ), ( '320453', '169', '' ), ( '320453', '170', '' ), ( '320453', '171', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '172', '/home/factorydirectbik/public_html/index.php:103 ' ), ( '320453', '173', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '174', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21 ;  - UPDATE Record count 14' ), ( '320453', '175', 'IF~display_site_page~1600417847.1254' ), ( '320453', '176', '' ), ( '320453', '177', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '178', '/home/factorydirectbik/public_html/index.php:258 ' ), ( '320453', '179', '/home/factorydirectbik/public_html/index.php:122 ' ), ( '320453', '180', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '181', 'SELECT title, heading, content from site_pages where site_page_id = '4'  - UPDATE Record count 1' ), ( '320453', '182', '' ), ( '320453', '183', 'M~setup_stepcarousel_old~1600417847.1282' ), ( '320453', '184', '' ), ( '320453', '185', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '186', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:29 ' ), ( '320453', '187', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '188', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '189', 'SELECT [crnl]				product_promo_id,[crnl]				product_id,[crnl]				promo_code,[crnl]				promo_price,[crnl]				promo_starts,[crnl]				promo_ends[crnl]			   FROM[crnl]				product_promotions[crnl]			   WHERE[crnl]				deleted = 0 AND promo_code != '' AND promo_price > 0 AND ( promo_ends = 0 OR promo_ends > '1600417847' ) AND ( promo_starts = 0 OR promo_starts < '1600417847' ) [crnl]			   ORDER BY[crnl]				promo_ends ASC  - UPDATE Record count 32' ), ( '320453', '190', '' ), ( '320453', '191', '' ), ( '320453', '192', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '193', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:93 ' ), ( '320453', '194', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '195', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '196', 'SELECT [crnl]			pcm.showroom_id,[crnl]			pcm.category_id,[crnl]			pcm.sub_category_id,[crnl]			sp.brand_id,[crnl]			sp.new_old_2nd,[crnl]			sp.year,[crnl]			sp.enhance_viewings,[crnl]			sp.name,[crnl]			sp.gender,[crnl]			sp.status,[crnl]			sp.vat_rate_code,[crnl]			sp.finance_scheme,[crnl]			sp.red_star,[crnl]			sp.weekend_madness,[crnl]			p.viewed_count,[crnl]			p.average_cost,[crnl]			p.supplier_rrp,[crnl]			p.our_price,[crnl]			p.our_price_1,[crnl]			p.our_price_2,[crnl]			p.our_price_3,[crnl]			p.offer_price,[crnl]			p.offer_starts,[crnl]			p.offer_ends,[crnl]			p.product_id,[crnl]			p.viewed_count,[crnl]			p.comments,[crnl]			ps.gen_spec,[crnl]			i.image_id,[crnl]			i.file_type,[crnl]			i.original,[crnl]			i.original_size,[crnl]			i.standard_size,[crnl]			i.mobile_size,[crnl]			i.thumbnail_size,[crnl]			i.thumbnail_width,[crnl]			i.thumbnail_height,[crnl]			i.description,[crnl]			i.sub_folder,[crnl]			s.name						AS showroom_name,[crnl]			b.name						AS brand_name,[crnl]			c.name						AS category_name,[crnl]			sc.name						AS sub_category_name[crnl]		   FROM[crnl]			product_category_matrix AS pcm[crnl]			JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]			JOIN products AS p 				ON sp.product_id = p.product_id[crnl]			JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]			JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]			JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]			JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]			LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]			JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]			JOIN images AS i				ON pi.image_id = i.image_id[crnl]		   WHERE[crnl]			pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND status = 0 AND shop_sale_only = 0 AND pcm.priority_category = 1 AND pi.deleted = 0 AND pi.ranking = 0  AND p.offer_price > 0  - UPDATE Record count 47' ), ( '320453', '197', '' ), ( '320453', '198', '' ), ( '320453', '199', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '200', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:136 ' ), ( '320453', '201', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '202', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '203', 'SELECT [crnl]			pcm.showroom_id,[crnl]			pcm.category_id,[crnl]			pcm.sub_category_id,[crnl]			sp.brand_id,[crnl]			sp.new_old_2nd,[crnl]			sp.year,[crnl]			sp.enhance_viewings,[crnl]			sp.name,[crnl]			sp.gender,[crnl]			sp.status,[crnl]			sp.vat_rate_code,[crnl]			sp.finance_scheme,[crnl]			sp.red_star,[crnl]			sp.weekend_madness,[crnl]			p.viewed_count,[crnl]			p.average_cost,[crnl]			p.supplier_rrp,[crnl]			p.our_price,[crnl]			p.our_price_1,[crnl]			p.our_price_2,[crnl]			p.our_price_3,[crnl]			p.offer_price,[crnl]			p.offer_starts,[crnl]			p.offer_ends,[crnl]			p.product_id,[crnl]			p.viewed_count,[crnl]			p.comments,[crnl]			ps.gen_spec,[crnl]			i.image_id,[crnl]			i.file_type,[crnl]			i.original,[crnl]			i.original_size,[crnl]			i.standard_size,[crnl]			i.mobile_size,[crnl]			i.thumbnail_size,[crnl]			i.thumbnail_width,[crnl]			i.thumbnail_height,[crnl]			i.description,[crnl]			i.sub_folder,[crnl]			s.name						AS showroom_name,[crnl]			b.name						AS brand_name,[crnl]			c.name						AS category_name,[crnl]			sc.name						AS sub_category_name[crnl]		   FROM[crnl]			product_category_matrix AS pcm[crnl]			JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]			JOIN products AS p 				ON sp.product_id = p.product_id[crnl]			JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]			JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]			JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]			JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]			LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]			JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]			JOIN images AS i				ON pi.image_id = i.image_id[crnl]		   WHERE[crnl]			pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND status = 0 AND shop_sale_only = 0 AND pcm.priority_category = 1 AND pi.deleted = 0 AND pi.ranking = 0  - UPDATE Record count 83' ), ( '320453', '204', '' ), ( '320453', '205', '' ), ( '320453', '206', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '207', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:139 ' ), ( '320453', '208', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '209', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '210', 'CREATE TEMPORARY TABLE  `zq99_a216901249871022347e5611f8fb6c7d` ( `p_key` MEDIUMINT( 6 ) UNSIGNED NOT NULL DEFAULT  '0', `saving` DECIMAL( 8, 2 ) UNSIGNED NOT NULL , PRIMARY KEY ( `p_key` ) ) ENGINE = MEMORY ;  - UPDATE Record count 0' ), ( '320453', '211', '' ), ( '320453', '212', '' ), ( '320453', '213', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '214', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:188 ' ), ( '320453', '215', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '216', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '217', 'INSERT INTO `zq99_a216901249871022347e5611f8fb6c7d` ( `p_key` , `saving` ) VALUES ( '9',  '109.99' ) , ( '10',  '109.99' ) , ( '11',  '89.99' ) , ( '12',  '89.99' ) , ( '13',  '119.99' ) , ( '14',  '119.99' ) , ( '15',  '99.99' ) , ( '16',  '99.99' ) , ( '17',  '149.99' ) , ( '18',  '149.99' ) , ( '19',  '119.99' ) , ( '20',  '119.99' ) , ( '21',  '129.99' ) , ( '22',  '159.99' ) , ( '23',  '159.99' ) , ( '24',  '799.99' ) , ( '25',  '599.99' ) , ( '26',  '499.99' ) , ( '27',  '399.99' ) , ( '28',  '399.99' ) , ( '29',  '349.99' ) , ( '30',  '349.99' ) , ( '31',  '349.99' ) , ( '32',  '269.99' ) , ( '33',  '269.99' ) , ( '34',  '219.99' ) , ( '35',  '219.99' ) , ( '36',  '999.99' ) , ( '37',  '349.99' ) , ( '38',  '349.99' ) , ( '39',  '899.99' ) , ( '40',  '699.99' ) , ( '41',  '579.99' ) , ( '42',  '579.99' ) , ( '43',  '429.99' ) , ( '44',  '429.99' ) , ( '45',  '349.99' ) , ( '46',  '349.99' ) , ( '47',  '299.99' ) , ( '48',  '299.99' ) , ( '49',  '249.99' ) , ( '50',  '249.99' ) , ( '51',  '999.99' ) , ( '52',  '699.99' ) , ( '53',  '649.99' ) , ( '54',  '1699.99' ) , ( '55',  '1399.99' ) , ( '56',  '1199.99' ) , ( '57',  '799.99' ) , ( '58',  '899.99' ) , ( '59',  '189.99' ) , ( '60',  '124.99' ) , ( '61',  '159.99' ) , ( '62',  '174.99' ) , ( '63',  '159.99' ) , ( '64',  '144.99' ) , ( '65',  '139.99' ) , ( '66',  '154.99' ) , ( '67',  '149.99' ) , ( '68',  '159.99' ) , ( '69',  '169.99' ) , ( '70',  '149.99' ) , ( '71',  '154.99' ) , ( '72',  '149.99' ) , ( '73',  '179.99' ) , ( '74',  '199.99' ) , ( '75',  '189.99' ) , ( '76',  '129.99' ) , ( '77',  '129.99' ) , ( '78',  '175' ) , ( '80',  '219.99' ) , ( '81',  '219.99' ) ; - UPDATE Record count 72' ), ( '320453', '218', '' ), ( '320453', '219', '' ), ( '320453', '220', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '221', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:194 ' ), ( '320453', '222', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '223', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '224', 'SELECT * FROM `zq99_a216901249871022347e5611f8fb6c7d` ORDER BY saving DESC LIMIT 0, 20 - UPDATE Record count 20' ), ( '320453', '225', '' ), ( '320453', '226', '' ), ( '320453', '227', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '228', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:233 ' ), ( '320453', '229', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '230', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '231', 'SELECT [crnl]			pcm.showroom_id,[crnl]			pcm.category_id,[crnl]			pcm.sub_category_id,[crnl]			sp.brand_id,[crnl]			sp.new_old_2nd,[crnl]			sp.year,[crnl]			sp.enhance_viewings,[crnl]			sp.name,[crnl]			sp.gender,[crnl]			sp.status,[crnl]			sp.vat_rate_code,[crnl]			sp.finance_scheme,[crnl]			sp.red_star,[crnl]			sp.weekend_madness,[crnl]			p.viewed_count,[crnl]			p.average_cost,[crnl]			p.supplier_rrp,[crnl]			p.our_price,[crnl]			p.our_price_1,[crnl]			p.our_price_2,[crnl]			p.our_price_3,[crnl]			p.offer_price,[crnl]			p.offer_starts,[crnl]			p.offer_ends,[crnl]			p.product_id,[crnl]			p.viewed_count,[crnl]			p.comments,[crnl]			ps.gen_spec,[crnl]			i.image_id,[crnl]			i.file_type,[crnl]			i.original,[crnl]			i.original_size,[crnl]			i.standard_size,[crnl]			i.mobile_size,[crnl]			i.thumbnail_size,[crnl]			i.thumbnail_width,[crnl]			i.thumbnail_height,[crnl]			i.description,[crnl]			i.sub_folder,[crnl]			s.name						AS showroom_name,[crnl]			b.name						AS brand_name,[crnl]			c.name						AS category_name,[crnl]			sc.name						AS sub_category_name[crnl]		   FROM[crnl]			product_category_matrix AS pcm[crnl]			JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]			JOIN products AS p 				ON sp.product_id = p.product_id[crnl]			JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]			JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]			JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]			JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]			LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]			JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]			JOIN images AS i				ON pi.image_id = i.image_id[crnl]		   WHERE[crnl]			pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND status = 0 AND shop_sale_only = 0 AND pcm.priority_category = 1 AND pi.deleted = 0 AND pi.ranking = 0  - UPDATE Record count 83' ), ( '320453', '232', '' ), ( '320453', '233', '' ), ( '320453', '234', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '235', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:271 ' ), ( '320453', '236', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '237', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '238', 'SELECT [crnl]			pcm.showroom_id,[crnl]			pcm.category_id,[crnl]			pcm.sub_category_id,[crnl]			sp.brand_id,[crnl]			sp.new_old_2nd,[crnl]			sp.year,[crnl]			sp.enhance_viewings,[crnl]			sp.name,[crnl]			sp.gender,[crnl]			sp.status,[crnl]			sp.vat_rate_code,[crnl]			sp.finance_scheme,[crnl]			sp.red_star,[crnl]			sp.weekend_madness,[crnl]			p.viewed_count,[crnl]			p.average_cost,[crnl]			p.supplier_rrp,[crnl]			p.our_price,[crnl]			p.our_price_1,[crnl]			p.our_price_2,[crnl]			p.our_price_3,[crnl]			p.offer_price,[crnl]			p.offer_starts,[crnl]			p.offer_ends,[crnl]			p.product_id,[crnl]			p.viewed_count,[crnl]			p.comments,[crnl]			ps.gen_spec,[crnl]			i.image_id,[crnl]			i.file_type,[crnl]			i.original,[crnl]			i.original_size,[crnl]			i.standard_size,[crnl]			i.mobile_size,[crnl]			i.thumbnail_size,[crnl]			i.thumbnail_width,[crnl]			i.thumbnail_height,[crnl]			i.description,[crnl]			i.sub_folder,[crnl]			s.name						AS showroom_name,[crnl]			b.name						AS brand_name,[crnl]			c.name						AS category_name,[crnl]			sc.name						AS sub_category_name[crnl]		   FROM[crnl]			product_category_matrix AS pcm[crnl]			JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]			JOIN products AS p 				ON sp.product_id = p.product_id[crnl]			JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]			JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]			JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]			JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]			LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]			JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]			JOIN images AS i				ON pi.image_id = i.image_id[crnl]		   WHERE[crnl]			pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND status = 0 AND shop_sale_only = 0 AND pcm.priority_category = 1 AND pi.deleted = 0 AND pi.ranking = 0 			   ORDER BY [crnl]				p.viewed_count DESC  [crnl]			   LIMIT 0, 5  - UPDATE Record count 5' ), ( '320453', '239', '' ), ( '320453', '240', '' ), ( '320453', '241', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '242', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:314 ' ), ( '320453', '243', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '244', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '245', 'SELECT [crnl]			pcm.showroom_id,[crnl]			pcm.category_id,[crnl]			pcm.sub_category_id,[crnl]			sp.brand_id,[crnl]			sp.new_old_2nd,[crnl]			sp.year,[crnl]			sp.enhance_viewings,[crnl]			sp.name,[crnl]			sp.gender,[crnl]			sp.status,[crnl]			sp.vat_rate_code,[crnl]			sp.finance_scheme,[crnl]			sp.red_star,[crnl]			sp.weekend_madness,[crnl]			p.viewed_count,[crnl]			p.average_cost,[crnl]			p.supplier_rrp,[crnl]			p.our_price,[crnl]			p.our_price_1,[crnl]			p.our_price_2,[crnl]			p.our_price_3,[crnl]			p.offer_price,[crnl]			p.offer_starts,[crnl]			p.offer_ends,[crnl]			p.product_id,[crnl]			p.viewed_count,[crnl]			p.comments,[crnl]			ps.gen_spec,[crnl]			i.image_id,[crnl]			i.file_type,[crnl]			i.original,[crnl]			i.original_size,[crnl]			i.standard_size,[crnl]			i.mobile_size,[crnl]			i.thumbnail_size,[crnl]			i.thumbnail_width,[crnl]			i.thumbnail_height,[crnl]			i.description,[crnl]			i.sub_folder,[crnl]			s.name						AS showroom_name,[crnl]			b.name						AS brand_name,[crnl]			c.name						AS category_name,[crnl]			sc.name						AS sub_category_name[crnl]		   FROM[crnl]			product_category_matrix AS pcm[crnl]			JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]			JOIN products AS p 				ON sp.product_id = p.product_id[crnl]			JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]			JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]			JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]			JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]			LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]			JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]			JOIN images AS i				ON pi.image_id = i.image_id[crnl]		   WHERE[crnl]			pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND status = 0 AND shop_sale_only = 0 AND pcm.priority_category = 1 AND pi.deleted = 0 AND pi.ranking = 0 				   ORDER BY [crnl]				sp.created DESC  [crnl]			   LIMIT 0, 5  - UPDATE Record count 5' ), ( '320453', '246', '' ), ( '320453', '247', '' ), ( '320453', '248', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320453', '249', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:455 ' ), ( '320453', '250', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320453', '251', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '252', 'SELECT 				sp.product_id,[crnl]				pcm.showroom_id,[crnl]				pcm.category_id,[crnl]				pcm.sub_category_id,[crnl]				sp.brand_id,[crnl]				sp.new_old_2nd,[crnl]				sp.year,[crnl]				sp.enhance_viewings,[crnl]				sp.name,[crnl]				sp.gender,[crnl]				sp.status,[crnl]				sp.vat_rate_code,[crnl]				sp.finance_scheme			AS a2b_scheme,[crnl]				sp.red_star,[crnl]				sp.weekend_madness,[crnl]				p.viewed_count,[crnl]				p.sold_count,[crnl]				p.average_cost,[crnl]				p.supplier_rrp,[crnl]				p.our_price,[crnl]				p.our_price_1,[crnl]				p.our_price_2,[crnl]				p.our_price_3,[crnl]				p.item_extra_cost_1			AS product_item_extra_cost_1,[crnl]				p.item_extra_cost_2			AS product_item_extra_cost_2,[crnl]				p.item_extra_cost_3			AS product_item_extra_cost_3,[crnl]				p.item_extra_cost_4			AS product_item_extra_cost_4,[crnl]				p.item_extra_cost_5			AS product_item_extra_cost_5,[crnl]				p.offer_price,[crnl]				p.offer_starts,[crnl]				p.offer_ends,[crnl]				p.wm_pc_off,[crnl]				p.comments,[crnl]				ps.gen_spec,[crnl]				ps.spec_data,[crnl]				i.image_id,[crnl]				i.file_type,[crnl]				i.original,[crnl]				i.original_size,[crnl]				i.standard_size,[crnl]				i.mobile_size,[crnl]				i.thumbnail_size,[crnl]				i.thumbnail_width,[crnl]				i.thumbnail_height,[crnl]				i.description,[crnl]				i.sub_folder,[crnl]				s.name						AS showroom_name,[crnl]				s.alternative_names			AS alternative_showroom_names,[crnl]				s.description				AS showroom_description,[crnl]				s.usual_display_panel,[crnl]				s.accessory_showroom,[crnl]				s.use_condition,[crnl]				s.item_extra_cost_1			AS showroom_item_extra_cost_1,[crnl]				s.item_extra_cost_2			AS showroom_item_extra_cost_2,[crnl]				s.item_extra_cost_3			AS showroom_item_extra_cost_3,[crnl]				s.item_extra_cost_4			AS showroom_item_extra_cost_4,[crnl]				s.item_extra_cost_5			AS showroom_item_extra_cost_5,[crnl]				s.item_ec_description_1		AS showroom_item_ec_description_1,[crnl]				s.item_ec_description_2		AS showroom_item_ec_description_2,[crnl]				s.item_ec_description_3		AS showroom_item_ec_description_3,[crnl]				s.item_ec_description_4		AS showroom_item_ec_description_4,[crnl]				s.item_ec_description_5		AS showroom_item_ec_description_5,[crnl]				s.item_ec_setting_1			AS showroom_item_ec_setting_1,[crnl]				s.item_ec_setting_2			AS showroom_item_ec_setting_2,[crnl]				s.item_ec_setting_3			AS showroom_item_ec_setting_3,[crnl]				s.item_ec_setting_4			AS showroom_item_ec_setting_4,[crnl]				s.item_ec_setting_5			AS showroom_item_ec_setting_5,[crnl]				s.des_carriage,[crnl]				b.name						AS brand_name,[crnl]				b.description				AS brand_description,[crnl]				b.type						AS brand_type,[crnl]				c.name						AS category_name,[crnl]				c.alternative_names			AS alternative_category_names,[crnl]				c.description				AS category_description,[crnl]				c.ride2work_available,[crnl]				c.usual_panel_display,[crnl]				sc.name						AS sub_category_name,[crnl]				sc.alternative_names		AS alternative_sub_category_names,[crnl]				sc.description				AS sub_category_description,[crnl]				pp.product_promo_id,[crnl]				pp.promo_code,[crnl]				pp.promo_price,[crnl]				pp.promo_starts,[crnl]				pp.promo_ends[crnl]			   FROM[crnl]				product_category_matrix AS pcm[crnl]				JOIN stub_products AS sp		ON pcm.product_id = sp.product_id[crnl]				JOIN products AS p 				ON sp.product_id = p.product_id[crnl]				JOIN product_specs AS ps		ON sp.product_id = ps.product_id[crnl]				JOIN showrooms AS s				ON sp.showroom_id = s.showroom_id[crnl]				JOIN brands AS b				ON sp.brand_id = b.brand_id[crnl]				JOIN categories AS c			ON pcm.category_id = c.category_id[crnl]				LEFT OUTER JOIN sub_categories AS sc	ON pcm.sub_category_id = sc.sub_category_id[crnl]				JOIN product_image_matrix AS pi	ON sp.product_id = pi.product_id[crnl]				JOIN images AS i				ON pi.image_id = i.image_id[crnl]				LEFT OUTER JOIN product_promotions AS pp	ON sp.product_id = pp.product_id[crnl]			   WHERE[crnl]				pcm.deleted = 0 AND sp.deleted = 0 AND s.display = 1 AND b.display = 1 AND shop_sale_only = 0 AND pi.deleted = 0 AND pi.ranking = 0 AND sp.status = 0 AND pcm.priority_category = 1 AND pp.deleted = 0 AND pp.promo_code != '' AND pp.promo_price > 0 AND ( pp.promo_ends = 0 OR pp.promo_ends > '1600417847' ) AND ( pp.promo_starts = 0 OR pp.promo_starts < '1600417847' ) [crnl]			   ORDER BY [crnl]				p.updated DESC  [crnl]			   LIMIT 0, 5  - UPDATE Record count 0' ), ( '320453', '253', '' ), ( '320453', '254', 'P~close_script~1600417847.2136' ), ( '320453', '255', 'update_sceen_shot = false' ), ( '320453', '256', 'create_screen_shot = false' ), ( '320453', '257', 'create_screen_shot_contents = false' ), ( '320453', '258', 'update_screen_shot_contents = false' ), ( '320453', '259', 'screen_shot_activity = false' ), ( '320453', '260', 'public = true' ), ( '320453', '261', 'epos = false' ), ( '320453', '262', 'management = false' ), ( '320453', '263', 'P~finalize_output~1600417847.215' ), ( '320453', '264', 'F~get_image~1600417847.2172' ), ( '320453', '265', 'no more official output~1600417847.2177' ), ( '320453', '266', '' ), ( '320453', '267', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '268', '/home/factorydirectbik/public_html/p_include/script_close.php:276 ' ), ( '320453', '269', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '270', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '271', 'LOCK TABLE `whos_online` WRITE ; - UPDATE Record count 0' ), ( '320453', '272', '' ), ( '320453', '273', '' ), ( '320453', '274', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '275', '/home/factorydirectbik/public_html/p_include/script_close.php:284 ' ), ( '320453', '276', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '277', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '278', 'DELETE FROM whos_online WHERE time_last_click < '1600414247' - UPDATE Record count 0' ), ( '320453', '279', '' ), ( '320453', '280', 'INSERT INTO whos_online ([crnl]					session_id,[crnl]					ip_address,[crnl]					time_started,[crnl]					time_last_click,[crnl]					no_of_clicks,[crnl]					q_ref,[crnl]					cookies_allowed,[crnl]					cookie_prefs,[crnl]					last_page_url,[crnl]					referer,[crnl]					email_id,[crnl]					customer_id,[crnl]					cart_id,[crnl]					uk_client,[crnl]					user_type,[crnl]					ecomm_country,[crnl]					allowed_to_trade,[crnl]				hostname,[crnl]				ext_sess_id[crnl]					)[crnl]				VALUES ([crnl]					'a216901249871022347e5611f8fb6c7d',[crnl]					'3.237.71.23',[crnl]					'1600417847',[crnl]					'1600417847',[crnl]					'1',[crnl]					'',[crnl]					'',[crnl]					':1280:Yes:No:Medium:Yes:No:No:No:Yes',[crnl]					'/control/bicycle_maintenance/',[crnl]					'',[crnl]					'0',[crnl]					'0',[crnl]					'0',[crnl]					'1',[crnl]					'-1',[crnl]					'UNITED STATES',[crnl]					'1',[crnl]				'ec2-3-237-71-23.compute-1.amazonaws.com',[crnl]				'umpI55vvxRHrvqnx'[crnl]					)' ), ( '320453', '281', '' ), ( '320453', '282', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '283', '/home/factorydirectbik/public_html/p_include/script_close.php:340 ' ), ( '320453', '284', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '285', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '286', '* * * * Insert into whos_online - session a216901249871022347e5611f8fb6c7d ip_address 3.237.71.23 failed' ), ( '320453', '287', '' ), ( '320453', '288', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '289', '/home/factorydirectbik/public_html/p_include/script_close.php:400 ' ), ( '320453', '290', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '291', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '292', 'LOCK TABLE `ip_tracker` WRITE ; - UPDATE Record count 0' ), ( '320453', '293', '' ), ( '320453', '294', '' ), ( '320453', '295', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '296', '/home/factorydirectbik/public_html/p_include/script_close.php:409 ' ), ( '320453', '297', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '298', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '299', 'DELETE FROM ip_tracker WHERE updated < 1595233847 ; - UPDATE Record count 0' ), ( '320453', '300', '' ), ( '320453', '301', '' ), ( '320453', '302', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320453', '303', '/home/factorydirectbik/public_html/p_include/script_close.php:570 ' ), ( '320453', '304', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320453', '305', '/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37 ' ), ( '320453', '306', 'LOCK TABLE `error_log_master` WRITE, `error_log_detail` WRITE ; - UPDATE Record count 0' ), ( '320453', '307', '' ) ;

/home/factorydirectbik/public_html/modules/script_open_start.php:3600
/home/factorydirectbik/public_html/p_include/script_close.php:619
/home/factorydirectbik/public_html/index.php:225
/home/factorydirectbik/public_html/control/bicycle_maintenance/index.php:37