Our world your way!

Assembly tips


After watching the appropriate 'Podcast' below, please take a few moments to review the notes for further clarification
















Our bikes are supplied 95% assembled. I have therefore provided some assistance, by way of basic instructional videos, to help you complete the final assembly of your new bike. These videos are in the form of an overview to get you started and do not represent a direct movie representation of the complete manual. There are 3 videos ranging from budget infant/junior, budget junior/adult and better quality which will hopefully cover the majority of requirements.

There are a few things to remember.

1. There is always someone at the end of our telephone line to lend a hand if you're stuck.
2. When removing packaging, please be careful not to damage paintwork or saddle.
3. There is no need to apply maximum force when tightening nuts, bolts or skewers.
4. There is seldom comprehensive assembly instructions available both before you order a bike and after its purchase, however, reading the manual or watching the 'bikecasts' will help. That said, if you're nor sure, get somebody to build the bike on your behalf who is capable.
5. Re-install handlebars / stem.
a. The forks must face in the correct direction, i.e. the brakes are at the front of the forks.
There are 2 types of stem system:-
a. the A-head set system. Remove top nut and A-head cap. Install handlebar and stem onto top of the fork steerer tube, replace A-head cap and tighten bolt. Adjust handlebars to correct vertical position and align with forks, then tighten side bolts on handlebar stem. If the stem is already in place, you will need to remove the front securing plate by loosening the allen bolts, fit the handlebars and repace the securing plate.
b. on most budget bikes, the stem is of the quill type. Remove the plastic cover from the bottom of the stem and insert the stem into the fork steerer tube. Adjust the handlebars to correct vertical position, align with forks and tighten the allen bolt on the top of the stem.
6.Re-install front wheel.
As usual there are 2 ways to complete this:-
Locate the wheel into the forks and
a. tighten the nuts with a 14mm spanner ( infant bike ) or 15 mm spanner ( junior / adult budget bike ).
OR
b. ensure that the quick release skewer is in the wheel axle. Hold the lever end of the quick release skewer, and turn the other end clockwise until finger tight. Lock the skewer by pushing it up or down to the closed position securing the wheel (you should feel resistance when locking the skewer). If it is too difficult to lock, unwind the non-lever end slightly and try again or if not enough resistance, tighten the non-lever end slightly and try again.
7.Re-install Pedals
Ideally, like the pedal threads, the seat post should be greased first. Then tightly screw the pedals in with a 15mm spanner. Please note the right hand pedal screws in clockwise, and the left hand pedal screws in anti clock wise and are usually labeled L and R respectively on the end of the screw thread. Ensure that they are screwed in squarely - no odd angles please and do not force the pedals in place - cross threaded pedals will not be covered under warranty. N.B. Currently replacement pedals and chainset will cost in excess of £40
8. Disc brake bedding-in period.
If your bike has disc brakes, it is normal for them to make a scraping sound until bedded in which is usually about 8-10 hours of continuous use.

Please take care when installing the front wheel into a bike with hydraulic disc brakes because if the brake lever is squeezed before the wheel is in place, the pads will close and there will be no space for the disc rotor. To push the pads back, insert a lever / skrewdriver between the pads taking care not to damage the pads or caliper.

Make sure that all cables are running free ( brakes and gears ) i.e. not wrapped awkwardly around the handlebars nor gear cables trapped by a prop stand.

A word of advice
Whilst you may want to wash / clean your bike, DO NOT use a jet wash as this will remove all of the grease from any area with moving parts and prevent smooth running.

And finally, take a look at our maintenance series of 'bikecasts'.

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 (
					'867e0a10eca993d90a8330ee9263a22f',
					'18.207.102.38',
					'1604119531',
					'1604119531',
					'1',
					'',
					'',
					':1280:Yes:No:Medium:Yes:No:No:No:Yes',
					'/control/assembly_tips/',
					'',
					'0',
					'0',
					'0',
					'1',
					'-1',
					'UNITED STATES',
					'1',
				'ec2-18-207-102-38.compute-1.amazonaws.com',
				'cdI3ySl6rIJLjJk1'
					)

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