Our world your way!

ABOUT US

Where we are and directions

Junction 27 Cycle Centre Ltd.


131 Westgate,
Cleckheaton,
West Yorkshire

BD19 5EJ

Tel: - 01924 420100
Fax: - 01924 420100

Opening Times
10:00 - 17:30 Monday - Friday
09:30 - 17:30 Saturday
10:00 - 16:00 Sunday and band holidays

We are 8 miles from Huddersfield, 5 miles from Leeds, 3 miles from Dewsbury, 7 miles from Brighouse, 8 miles from Wakefield, 10 miles from Halifax.

We are an expanding family run company whose ethos is a fair pricing policy, to give the very best value for money and a 'second to none' after sales service. We will beat any proven price.

• Established 1996
• Cater for all the family
• Family run business
• Quality and after sales care does matter
• Nearly 7000 sq ft of space
• Hundreds of bikes on display
• Extensive range of good value for money bikes - prices range from £25 to £7,500.00

Shop purchases only:-
Test ride a bike before you buy
3 FREE services in first year
Guaranteed part exchange on your old bike ( from Factory Direct Bikes ) - allowance is between 25% and 40% of what you paid (Terms apply)

NEW BIKE WARRANTY


3 Free Basic Services / Tune-Ups in Year One
• includes brakes • gears • bearing adjustments • general lubrication

This is the same as a basic service costing £30.00.
A well tuned bicycle will bring many hours of enjoyment so all we ask is that you

• You bring the bicycle in for its first free tune-up service after approximately 20 hours of riding.
• You bring your bicycle in for a tune-up service at least every six (6) months.
• You bring your bicycle in as soon as you notice something not working properly.

Full Lifetime Warranty


Every bicycle purchased from Junction 27 Cycle Centre includes, for the original owner, a FULL LIFETIME WARRANTY against manufacturers' defects on the bicycle frame and rigid fork. There are a few exceptions of which you will be advised. Also included is a One Year Warranty on all mechanical components of the bicycle. Junction 27 Cycle Centre's warranty includes repair or replacement, at our discretion of any item deemed to be defective. There will be no cost to you for parts or labour on any item deemed defective. Consumables are not covered by any warranty and these would include, pedals, saddle, handlebar grips, cables, chain, tyres, inner tubes and brake blocks unless defective when new, i.e never used.

To clarify


• Normal wear and tear is excluded ( a crack in the frame would be covered, brake pads wearing out or a flat tyre would not ).
•Suspension components are covered by a one (1) year warranty against defects.
• Damage to the bicycle caused by accidents or while being used in competitive events is not covered.
• Custom bicycle frames are covered by their respective manufacturers frame and fork warranty.
• This warranty is non-transferrable and applies only to the original purchaser of a new bicycle.

Ride Satisfaction Guarantee


Buy your new bicycle with confidence! At Junction 27 Cycle Centre, we're only happy when you are! We want to GUARANTEE that you are totally satisfied with your new bicycle purchase. So, if you are not completely satisfied, return your bicycle in new condition within 14 days and we will gladly exchange it for another model or refund the amount you paid. If the bike is not in its new condition, Junction 27 Cycle Centre will refund the full resale value which is the maximum that we will resell the bicycle for on our showroom floor.

How to find us


Conveniently located within 1 mile of Junction 27 of the M62, we can be reached by following the A62 toward Huddersfield from the M62. Continue on the A62 past IKEA and follow it down the hill towards Birstall. We are located on the ground floor of a converted mill, where there is a large free car park available outside the door.
Whilst we are primarily based in West Yorkshire and our catchment area is predominently Leeds, Huddersfield, Wakefield, Bradford, Halifax and Harrogate as the main city centres, we supply MAIL ORDER to the whole of the UK, Europe and the USA.


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 (
					'023372561fb18dd0d8f12066e0253a2d',
					'18.207.102.38',
					'1604116792',
					'1604116792',
					'1',
					'',
					'',
					':1280:Yes:No:Medium:Yes:No:No:No:Yes',
					'/control/about_us/',
					'',
					'0',
					'0',
					'0',
					'1',
					'-1',
					'UNITED STATES',
					'1',
				'ec2-18-207-102-38.compute-1.amazonaws.com',
				'gTtfKZx0tswI7k17'
					)

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

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