Our world your way!

Maintenance tips


The below 'podcasts' are intended to provide some advice, guidance and confidence when attempting bicycle maintenance.

The first in the series is changing a bicycle tyre or inner tube.





Setting up the gears on your bike.




Changing a bicycle chain.




Changing a brake or gear cable.




Changing a cassette / gears.




Also, lookout for our advanced maintenance series of 'bikecasts' coming soon.

Or

our basic Basic assembly tips.

Back to top.

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 (
					'88d87f8aa8ddcc0a7d5a1e28b81215cd',
					'18.207.102.38',
					'1604120776',
					'1604120776',
					'1',
					'',
					'',
					':1280:Yes:No:Medium:Yes:No:No:No:Yes',
					'/control/maintenance_tips/',
					'',
					'0',
					'0',
					'0',
					'1',
					'-1',
					'UNITED STATES',
					'1',
				'ec2-18-207-102-38.compute-1.amazonaws.com',
				'quyBf6XUyQ1gUbOh'
					)

/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/maintenance_tips/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 ( '350189', '0', '±M~script_open_start~1604120776.5936±±/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/maintenance_tips/index.php:37 ±SELECT * from mobile_agents ;  - UPDATE Record count 22±± start DB1604120776.5962±±/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/maintenance_tips/index.php:37 ±SELECT * from master_config where id = 0  - UPDATE Record count 1±' ), ( '350189', '1', '' ), ( '350189', '2', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '3', '/home/factorydirectbik/public_html/modules/script_open_start.php:147 ' ), ( '350189', '4', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '5', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '6', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '7', 'SELECT * from configs where id = '3' - UPDATE Record count 1' ), ( '350189', '8', '' ), ( '350189', '9', '' ), ( '350189', '10', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '11', '/home/factorydirectbik/public_html/modules/script_open_start.php:169 ' ), ( '350189', '12', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '13', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '14', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '15', 'SELECT * FROM `factorydirectbik_db`.`html` ; - UPDATE Record count 28' ), ( '350189', '16', '' ), ( '350189', '17', '' ), ( '350189', '18', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '19', '/home/factorydirectbik/public_html/modules/script_open_start.php:203 ' ), ( '350189', '20', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '21', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '22', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '23', 'SELECT * from users WHERE deleted = 0 ; - UPDATE Record count 1' ), ( '350189', '24', '' ), ( '350189', '25', ' globals1604120776.5992' ), ( '350189', '26', 'ENV Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '350189', '27', 'ENV Key TEMP : Value /tmp' ), ( '350189', '28', 'ENV Key TMP : Value /tmp' ), ( '350189', '29', 'ENV Key TMPDIR : Value /tmp' ), ( '350189', '30', 'ENV Key PWD : Value /' ), ( '350189', '31', 'SERVER Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '350189', '32', 'SERVER Key TEMP : Value /tmp' ), ( '350189', '33', 'SERVER Key TMP : Value /tmp' ), ( '350189', '34', 'SERVER Key TMPDIR : Value /tmp' ), ( '350189', '35', 'SERVER Key PWD : Value /' ), ( '350189', '36', 'SERVER Key HTTP_ACCEPT : Value text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' ), ( '350189', '37', 'SERVER Key HTTP_ACCEPT_LANGUAGE : Value en-US,en;q=0.5' ), ( '350189', '38', 'SERVER Key CONTENT_LENGTH : Value 0' ), ( '350189', '39', 'SERVER Key HTTP_HOST : Value www.factorydirectbikes.com' ), ( '350189', '40', 'SERVER Key HTTP_USER_AGENT : Value CCBot/2.0 (https://commoncrawl.org/faq/)' ), ( '350189', '41', 'SERVER Key HTTP_X_FORWARDED_FOR : Value ::ffff:18.207.102.38' ), ( '350189', '42', 'SERVER Key HTTP_X_FORWARDED_HOST : Value www.factorydirectbikes.com' ), ( '350189', '43', 'SERVER Key HTTP_X_FORWARDED_PORT : Value 80' ), ( '350189', '44', 'SERVER Key HTTP_X_FORWARDED_PROTO : Value http' ), ( '350189', '45', 'SERVER Key HTTP_X_FORWARDED_SERVER : Value www.factorydirectbikes.com' ), ( '350189', '46', 'SERVER Key HTTP_GEOIP_ADDR : Value 18.207.102.38' ), ( '350189', '47', 'SERVER Key HTTP_GEOIP_CONTINENT_CODE : Value NA' ), ( '350189', '48', 'SERVER Key HTTP_GEOIP_COUNTRY_CODE : Value US' ), ( '350189', '49', 'SERVER Key HTTP_GEOIP_COUNTRY_NAME : Value United States' ), ( '350189', '50', 'SERVER Key UNIQUE_ID : Value X5zwyDcoSTJaxw5zGD3wpgAAAAM' ), ( '350189', '51', 'SERVER Key GEOIP_ADDR : Value 18.207.102.38' ), ( '350189', '52', 'SERVER Key GEOIP_CONTINENT_CODE : Value NA' ), ( '350189', '53', 'SERVER Key GEOIP_COUNTRY_CODE : Value US' ), ( '350189', '54', 'SERVER Key GEOIP_COUNTRY_NAME : Value United States' ), ( '350189', '55', 'SERVER Key SCRIPT_URL : Value /control/maintenance_tips/' ), ( '350189', '56', 'SERVER Key SCRIPT_URI : Value http://www.factorydirectbikes.com/control/maintenance_tips/' ), ( '350189', '57', 'SERVER Key SERVER_SIGNATURE : Value ' ), ( '350189', '58', 'SERVER Key SERVER_SOFTWARE : Value Apache' ), ( '350189', '59', 'SERVER Key SERVER_NAME : Value www.factorydirectbikes.com' ), ( '350189', '60', 'SERVER Key SERVER_ADDR : Value 89.187.86.8' ), ( '350189', '61', 'SERVER Key SERVER_PORT : Value 80' ), ( '350189', '62', 'SERVER Key REMOTE_ADDR : Value 18.207.102.38' ), ( '350189', '63', 'SERVER Key DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '350189', '64', 'SERVER Key REQUEST_SCHEME : Value http' ), ( '350189', '65', 'SERVER Key CONTEXT_PREFIX : Value ' ), ( '350189', '66', 'SERVER Key CONTEXT_DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '350189', '67', 'SERVER Key SERVER_ADMIN : Value webmaster@factorydirectbikes.com' ), ( '350189', '68', 'SERVER Key SCRIPT_FILENAME : Value /home/factorydirectbik/public_html/control/maintenance_tips/index.php' ), ( '350189', '69', 'SERVER Key REMOTE_PORT : Value 40782' ), ( '350189', '70', 'SERVER Key SERVER_PROTOCOL : Value HTTP/1.1' ), ( '350189', '71', 'SERVER Key REQUEST_METHOD : Value GET' ), ( '350189', '72', 'SERVER Key QUERY_STRING : Value ' ), ( '350189', '73', 'SERVER Key REQUEST_URI : Value /control/maintenance_tips/' ), ( '350189', '74', 'SERVER Key SCRIPT_NAME : Value /control/maintenance_tips/index.php' ), ( '350189', '75', 'SERVER Key PHP_SELF : Value /control/maintenance_tips/index.php' ), ( '350189', '76', 'SERVER Key REQUEST_TIME_FLOAT : Value 1604120776.5667' ), ( '350189', '77', 'SERVER Key REQUEST_TIME : Value 1604120776' ), ( '350189', '78', 'F~identify_ip_location~1604120776.5993' ), ( '350189', '79', '' ), ( '350189', '80', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '81', '/home/factorydirectbik/public_html/modules/script_open_start.php:495 ' ), ( '350189', '82', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '83', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '84', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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 <= '315581990' AND a.ip_end >= '315581990'[crnl]				 - UPDATE Record count 1' ), ( '350189', '86', '' ), ( '350189', '87', ' ip_tracker1604120776.62' ), ( '350189', '88', '' ), ( '350189', '89', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '90', '/home/factorydirectbik/public_html/modules/script_open_start.php:543 ' ), ( '350189', '91', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '92', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '93', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '94', 'SELECT ipt_id, created, updated, hits, strike, banned_until FROM ip_tracker WHERE ip_address = '18.207.102.38'  - UPDATE Record count 1' ), ( '350189', '95', '' ), ( '350189', '96', '' ), ( '350189', '97', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '98', '/home/factorydirectbik/public_html/modules/script_open_start.php:575 ' ), ( '350189', '99', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '100', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '101', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '102', 'UPDATE ip_tracker SET updated = '1604120776', hits = '21'  WHERE ipt_id = '20988'  - UPDATE Record count 1' ), ( '350189', '103', ' get all ip_recs1604120776.6209' ), ( '350189', '104', '' ), ( '350189', '105', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '106', '/home/factorydirectbik/public_html/modules/script_open_start.php:616 ' ), ( '350189', '107', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '108', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '109', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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 = '18.207.102.38'  - UPDATE Record count 1' ), ( '350189', '111', '' ), ( '350189', '112', ' ip_robot' ), ( '350189', '113', ' Screen shot processing1604120776.6216 whos_online' ), ( '350189', '114', '' ), ( '350189', '115', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '116', '/home/factorydirectbik/public_html/modules/script_open_start.php:957 ' ), ( '350189', '117', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '118', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '119', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '120', 'SELECT * FROM whos_online WHERE session_id = '88d87f8aa8ddcc0a7d5a1e28b81215cd' ; - UPDATE Record count 0' ), ( '350189', '121', '' ), ( '350189', '122', '' ), ( '350189', '123', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '124', '/home/factorydirectbik/public_html/modules/script_open_start.php:1066 ' ), ( '350189', '125', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '350189', '126', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '127', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '128', 'SELECT session_id FROM whos_online WHERE ext_sess_id = 'quyBf6XUyQ1gUbOh' - UPDATE Record count 0' ), ( '350189', '129', '' ), ( '350189', '130', ' read_cookies read_cookies =  check_cookies = -1 cookies_accepted =  screen_width = 1604120776.6223' ), ( '350189', '131', ' set_screen_width1604120776.6223' ), ( '350189', '132', 'P~initialize_script~1604120776.5936~' ), ( '350189', '133', '' ), ( '350189', '134', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '135', '/home/factorydirectbik/public_html/p_include/script_open.php:143 ' ), ( '350189', '136', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '350189', '137', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '138', 'SELECT * from html where page_id = '302'  - UPDATE Record count 1' ), ( '350189', '139', '' ), ( '350189', '140', 'T~/control/maintenance_tips/index.php~1604120776.6228' ), ( '350189', '141', 'M~display_nav_tabs_3~1604120776.6238' ), ( '350189', '142', '' ), ( '350189', '143', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '144', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:34 ' ), ( '350189', '145', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '350189', '146', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '148', '' ), ( '350189', '149', '' ), ( '350189', '150', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '151', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:100 ' ), ( '350189', '152', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '350189', '153', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '155', '' ), ( '350189', '156', '' ), ( '350189', '157', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '158', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:161 ' ), ( '350189', '159', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '350189', '160', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '161', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21  - UPDATE Record count 14' ), ( '350189', '162', '' ), ( '350189', '163', '' ), ( '350189', '164', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '165', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:204 ' ), ( '350189', '166', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '350189', '167', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '169', '' ), ( '350189', '170', '' ), ( '350189', '171', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '172', '/home/factorydirectbik/public_html/index.php:103 ' ), ( '350189', '173', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '174', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21 ;  - UPDATE Record count 14' ), ( '350189', '175', 'IF~display_site_page~1604120776.6841' ), ( '350189', '176', '' ), ( '350189', '177', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '178', '/home/factorydirectbik/public_html/index.php:258 ' ), ( '350189', '179', '/home/factorydirectbik/public_html/index.php:122 ' ), ( '350189', '180', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '181', 'SELECT title, heading, content from site_pages where site_page_id = '12'  - UPDATE Record count 1' ), ( '350189', '182', '' ), ( '350189', '183', 'M~setup_stepcarousel_old~1604120776.6869' ), ( '350189', '184', '' ), ( '350189', '185', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '186', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:29 ' ), ( '350189', '187', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '188', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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 > '1604120776' ) AND ( promo_starts = 0 OR promo_starts < '1604120776' ) [crnl]			   ORDER BY[crnl]				promo_ends ASC  - UPDATE Record count 32' ), ( '350189', '190', '' ), ( '350189', '191', '' ), ( '350189', '192', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '193', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:93 ' ), ( '350189', '194', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '195', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '197', '' ), ( '350189', '198', '' ), ( '350189', '199', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '200', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:136 ' ), ( '350189', '201', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '202', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '204', '' ), ( '350189', '205', '' ), ( '350189', '206', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '207', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:139 ' ), ( '350189', '208', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '209', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '210', 'CREATE TEMPORARY TABLE  `zq99_88d87f8aa8ddcc0a7d5a1e28b81215cd` ( `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' ), ( '350189', '211', '' ), ( '350189', '212', '' ), ( '350189', '213', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '214', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:188 ' ), ( '350189', '215', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '216', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '217', 'INSERT INTO `zq99_88d87f8aa8ddcc0a7d5a1e28b81215cd` ( `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' ), ( '350189', '218', '' ), ( '350189', '219', '' ), ( '350189', '220', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '221', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:194 ' ), ( '350189', '222', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '223', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '224', 'SELECT * FROM `zq99_88d87f8aa8ddcc0a7d5a1e28b81215cd` ORDER BY saving DESC LIMIT 0, 20 - UPDATE Record count 20' ), ( '350189', '225', '' ), ( '350189', '226', '' ), ( '350189', '227', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '228', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:233 ' ), ( '350189', '229', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '230', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '232', '' ), ( '350189', '233', '' ), ( '350189', '234', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '235', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:271 ' ), ( '350189', '236', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '237', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '239', '' ), ( '350189', '240', '' ), ( '350189', '241', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '242', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:314 ' ), ( '350189', '243', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '244', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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' ), ( '350189', '246', '' ), ( '350189', '247', '' ), ( '350189', '248', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '249', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:455 ' ), ( '350189', '250', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '350189', '251', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '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 > '1604120776' ) AND ( pp.promo_starts = 0 OR pp.promo_starts < '1604120776' ) [crnl]			   ORDER BY [crnl]				p.updated DESC  [crnl]			   LIMIT 0, 5  - UPDATE Record count 0' ), ( '350189', '253', '' ), ( '350189', '254', 'P~close_script~1604120776.763' ), ( '350189', '255', 'update_sceen_shot = false' ), ( '350189', '256', 'create_screen_shot = false' ), ( '350189', '257', 'create_screen_shot_contents = false' ), ( '350189', '258', 'update_screen_shot_contents = false' ), ( '350189', '259', 'screen_shot_activity = false' ), ( '350189', '260', 'public = true' ), ( '350189', '261', 'epos = false' ), ( '350189', '262', 'management = false' ), ( '350189', '263', 'P~finalize_output~1604120776.764' ), ( '350189', '264', 'F~get_image~1604120776.7657' ), ( '350189', '265', '' ), ( '350189', '266', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '350189', '267', '/home/factorydirectbik/public_html/functions/get_image.php:44 ' ), ( '350189', '268', '/home/factorydirectbik/public_html/p_include/script_close.php:82 ' ), ( '350189', '269', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '270', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '271', 'SELECT * FROM external_videos WHERE ext_vid_id = '12' OR ext_vid_id = '16' OR ext_vid_id = '13' OR ext_vid_id = '14' OR ext_vid_id = '15' ; - UPDATE Record count 5' ), ( '350189', '272', '' ), ( '350189', '273', 'no more official output~1604120776.7677' ), ( '350189', '274', '' ), ( '350189', '275', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '276', '/home/factorydirectbik/public_html/p_include/script_close.php:276 ' ), ( '350189', '277', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '278', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '279', 'LOCK TABLE `whos_online` WRITE ; - UPDATE Record count 0' ), ( '350189', '280', '' ), ( '350189', '281', '' ), ( '350189', '282', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '283', '/home/factorydirectbik/public_html/p_include/script_close.php:284 ' ), ( '350189', '284', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '285', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '286', 'DELETE FROM whos_online WHERE time_last_click < '1604117176' - UPDATE Record count 0' ), ( '350189', '287', '' ), ( '350189', '288', '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]					'88d87f8aa8ddcc0a7d5a1e28b81215cd',[crnl]					'18.207.102.38',[crnl]					'1604120776',[crnl]					'1604120776',[crnl]					'1',[crnl]					'',[crnl]					'',[crnl]					':1280:Yes:No:Medium:Yes:No:No:No:Yes',[crnl]					'/control/maintenance_tips/',[crnl]					'',[crnl]					'0',[crnl]					'0',[crnl]					'0',[crnl]					'1',[crnl]					'-1',[crnl]					'UNITED STATES',[crnl]					'1',[crnl]				'ec2-18-207-102-38.compute-1.amazonaws.com',[crnl]				'quyBf6XUyQ1gUbOh'[crnl]					)' ), ( '350189', '289', '' ), ( '350189', '290', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '291', '/home/factorydirectbik/public_html/p_include/script_close.php:340 ' ), ( '350189', '292', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '293', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '294', '* * * * Insert into whos_online - session 88d87f8aa8ddcc0a7d5a1e28b81215cd ip_address 18.207.102.38 failed' ), ( '350189', '295', '' ), ( '350189', '296', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '297', '/home/factorydirectbik/public_html/p_include/script_close.php:400 ' ), ( '350189', '298', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '299', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '300', 'LOCK TABLE `ip_tracker` WRITE ; - UPDATE Record count 0' ), ( '350189', '301', '' ), ( '350189', '302', '' ), ( '350189', '303', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '304', '/home/factorydirectbik/public_html/p_include/script_close.php:409 ' ), ( '350189', '305', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '306', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '307', 'DELETE FROM ip_tracker WHERE updated < 1598936776 ; - UPDATE Record count 0' ), ( '350189', '308', '' ), ( '350189', '309', '' ), ( '350189', '310', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '350189', '311', '/home/factorydirectbik/public_html/p_include/script_close.php:570 ' ), ( '350189', '312', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '350189', '313', '/home/factorydirectbik/public_html/control/maintenance_tips/index.php:37 ' ), ( '350189', '314', 'LOCK TABLE `error_log_master` WRITE, `error_log_detail` WRITE ; - UPDATE Record count 0' ), ( '350189', '315', '' ) ;

/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/maintenance_tips/index.php:37