Our world your way!

Terms and Conditions

Making your Payment
We accept all normal forms of payment, cash, credit/debit cards etc.

We also offer finance on many purchases available throughout the store, see our finance page for details.


How to Contact Us
A full set of contact details is included on our Contact us including a simple form for you to use to email us.


Shipping and Handling
There is a set fee fully insured Carriage Policy.

Bikes / cycles - ?12.50 unless item value exceeds ?400.00.

Cycle accessories - ?5.00 unless value exceeds ?50.00.

The above holds true except where product prices are further reduced and the item is placed on offer where a carriage charge may be applied.

Delivery is UK only and usually within 2-3 working days, Mon - Fri only.

It is preferable to also leave a delivery address e.g. workplace, where there will be someone present at all times during working hours. It does cause frustration both for customers and carriers if a product has to be redelivered.

Items Damaged in Transit - If any items were damaged in transit, you must report it to us within 3 working days to qualify for a replacement.

If the item is visibly damaged on receipt, please sign the carrier's delivery note accordingly, i.e. write 'damaged / goods unchecked / box damaged' on the the carriers manifest. Contact us and, in most cases, we will arrange for the item to be collected. Items should be returned in their original packaging complete with all accessories and documentation.

If possible take digital photos of damage and email those images to me. Please remember not to get too close for some images so that I may apply a perspective to the problem.


Your Security, Privacy and Credit Card Security
We value your security and as such have done our utmost to ensure that none of your personal information is at risk while you are visiting our site.

For specific information regarding our privacy policy, please refer to the Privacy Policy page.


VAT
...


Order cancellation
Your order may be cancelled at any time however there may be resulting costs as follows:-

If the goods have not left our premises, there is a ?25 administration charge.

If the goods have left the premises but not delivered, an administration and restocking charge of ?50 is applicable.

If the goods have been delivered, an administration, collection and restocking charge of ?75 is applicable.


Back Orders
Once you have placed an order with us, we will be in contact with you soon after, primarily to confirm your preferred payment method, but also to confirm the availability of your chosen products.

If we do NOT have any of the products that you require, you will be told at the point that we contact you. At anytime you will be under no obligation to proceed with the purchase of those goods.

You will be offered the option to Back-Order the items and should you choose to do this, we will endeavour to give you a true indication of the date upon which you should expect to receive said goods. We will request a deposit for ordering specific goods on your behalf where relevant (these details will be given to you at the point when we contact you). If we fail to secure the goods you have back ordered within a reasonable (the estimated) time, you will be under no obligation to proceed further with that order. This is extremely rare. Should you choose to cancel a back ordered item BEFORE our expected delivery date, we reserve the right to withhold a reasonable proportion of any deposits already paid.


If you wish to complain
Should you need to complain, please contact the store either by telephone on 01924 420100 or by mail (contact details as per our contacts page) and address your complaint directly to the Managing Director.


Returns
We want you to be 100% satisfied with any product that you buy from Junction 27 Cycle Centre Ltd..

If, in the unlikely event, you are not 100% happy with your purchase, Junction 27 Cycle Centre Ltd. will refund the retail cost* of the product, provided that it is returned in a perfect saleable condition within 7 days.

Any item bought in error will be exchanged*, eg where you buy the wrong size, provided that it is returned in a perfect saleable condition within 7 days.

All goods that we sell are covered by a warranty. Most items have a warranty provided by their respective manufacturer BUT this warranty must be carried out by us. If you feel that you have an item which is faulty, please return it to us with a copy of your original proof of purchase. If it is found to be a genuine fault of manufacture we will of course repair or replace it free of charge and return it to you with no postage charges. However, if the item is found not to have a genuine fault covered by it's warranty we will advise you of this. If you subsequently require the product to be returned back to you, we will have to make a charge for carriage.

*unfortunately we cannot refund actual expenses e.g. postage and packing. You will also be charged for postage on any replacement items we send out where the original mistake was not ours.

PLEASE REMEMBER TO INCLUDE A COPY OF YOUR ORIGINAL SALES RECEIPT AND YOUR FULL CONTACT DETAILS ETC.

Junction 27 Cycle Centre Ltd. will refund the retail cost* of the product, provided that it is returned in a perfect saleable condition within 7 days.

N.B. Should you find that a minor part, nut bolt reflector is missing, please advise Junction 27 Cycle Centre Ltd. and these items will be sent to you FREE OF CHARGE next working day.


Warranty Issues
In all cases written details of a failure are required along with digital images. A brief summary of what happened will also be useful. Can I recommend, at this stage, that you keep a copy of what you send to me, by using either Microsoft Outlook or Outlook Express to customer_care@factorydirectbikes.com

Replacement parts are chargeable until faulty parts are returned. I would be grateful if you would forward digital photos of damaged parts - please send some photos showing the perspective of the damage / fault i.e. don't get too close.

In cases where a refund is due, we will reimburse you within 30 days of our receipt of the returned goods.

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 (
					'e029a5e37a8aac6dbe26ea70f7611046',
					'3.237.71.23',
					'1600411079',
					'1600411079',
					'1',
					'',
					'',
					':1280:Yes:No:Medium:Yes:No:No:No:Yes',
					'/control/terms_and_conditions/',
					'',
					'0',
					'0',
					'0',
					'1',
					'-1',
					'UNITED STATES',
					'1',
				'ec2-3-237-71-23.compute-1.amazonaws.com',
				'B5edvxwwve8rWE1d'
					)

/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/terms_and_conditions/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 ( '320401', '0', '±M~script_open_start~1600411078.8811±±/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/terms_and_conditions/index.php:37 ±SELECT * from mobile_agents ;  - UPDATE Record count 22±± start DB1600411078.8828±±/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/terms_and_conditions/index.php:37 ±SELECT * from master_config where id = 0  - UPDATE Record count 1±' ), ( '320401', '1', '' ), ( '320401', '2', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '3', '/home/factorydirectbik/public_html/modules/script_open_start.php:147 ' ), ( '320401', '4', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '5', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '6', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '7', 'SELECT * from configs where id = '3' - UPDATE Record count 1' ), ( '320401', '8', '' ), ( '320401', '9', '' ), ( '320401', '10', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '11', '/home/factorydirectbik/public_html/modules/script_open_start.php:169 ' ), ( '320401', '12', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '13', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '14', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '15', 'SELECT * FROM `factorydirectbik_db`.`html` ; - UPDATE Record count 28' ), ( '320401', '16', '' ), ( '320401', '17', '' ), ( '320401', '18', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '19', '/home/factorydirectbik/public_html/modules/script_open_start.php:203 ' ), ( '320401', '20', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '21', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '22', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '23', 'SELECT * from users WHERE deleted = 0 ; - UPDATE Record count 1' ), ( '320401', '24', '' ), ( '320401', '25', ' globals1600411078.885' ), ( '320401', '26', 'ENV Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '320401', '27', 'ENV Key TEMP : Value /tmp' ), ( '320401', '28', 'ENV Key TMP : Value /tmp' ), ( '320401', '29', 'ENV Key TMPDIR : Value /tmp' ), ( '320401', '30', 'ENV Key PWD : Value /' ), ( '320401', '31', 'SERVER Key PATH : Value /usr/local/bin:/usr/bin:/bin' ), ( '320401', '32', 'SERVER Key TEMP : Value /tmp' ), ( '320401', '33', 'SERVER Key TMP : Value /tmp' ), ( '320401', '34', 'SERVER Key TMPDIR : Value /tmp' ), ( '320401', '35', 'SERVER Key PWD : Value /' ), ( '320401', '36', 'SERVER Key HTTP_ACCEPT : Value text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' ), ( '320401', '37', 'SERVER Key HTTP_ACCEPT_LANGUAGE : Value en-US,en;q=0.5' ), ( '320401', '38', 'SERVER Key CONTENT_LENGTH : Value 0' ), ( '320401', '39', 'SERVER Key HTTP_HOST : Value www.factorydirectbikes.com' ), ( '320401', '40', 'SERVER Key HTTP_USER_AGENT : Value CCBot/2.0 (https://commoncrawl.org/faq/)' ), ( '320401', '41', 'SERVER Key HTTP_X_FORWARDED_FOR : Value ::ffff:3.237.71.23' ), ( '320401', '42', 'SERVER Key HTTP_X_FORWARDED_HOST : Value www.factorydirectbikes.com' ), ( '320401', '43', 'SERVER Key HTTP_X_FORWARDED_PORT : Value 80' ), ( '320401', '44', 'SERVER Key HTTP_X_FORWARDED_PROTO : Value http' ), ( '320401', '45', 'SERVER Key HTTP_X_FORWARDED_SERVER : Value www.factorydirectbikes.com' ), ( '320401', '46', 'SERVER Key HTTP_GEOIP_ADDR : Value 3.237.71.23' ), ( '320401', '47', 'SERVER Key HTTP_GEOIP_CONTINENT_CODE : Value NA' ), ( '320401', '48', 'SERVER Key HTTP_GEOIP_COUNTRY_CODE : Value US' ), ( '320401', '49', 'SERVER Key HTTP_GEOIP_COUNTRY_NAME : Value United States' ), ( '320401', '50', 'SERVER Key UNIQUE_ID : Value X2RVxnAm8L9@gWxcyJcLSAAAAMM' ), ( '320401', '51', 'SERVER Key GEOIP_ADDR : Value 3.237.71.23' ), ( '320401', '52', 'SERVER Key GEOIP_CONTINENT_CODE : Value NA' ), ( '320401', '53', 'SERVER Key GEOIP_COUNTRY_CODE : Value US' ), ( '320401', '54', 'SERVER Key GEOIP_COUNTRY_NAME : Value United States' ), ( '320401', '55', 'SERVER Key SCRIPT_URL : Value /control/terms_and_conditions/' ), ( '320401', '56', 'SERVER Key SCRIPT_URI : Value http://www.factorydirectbikes.com/control/terms_and_conditions/' ), ( '320401', '57', 'SERVER Key SERVER_SIGNATURE : Value ' ), ( '320401', '58', 'SERVER Key SERVER_SOFTWARE : Value Apache' ), ( '320401', '59', 'SERVER Key SERVER_NAME : Value www.factorydirectbikes.com' ), ( '320401', '60', 'SERVER Key SERVER_ADDR : Value 89.187.86.8' ), ( '320401', '61', 'SERVER Key SERVER_PORT : Value 80' ), ( '320401', '62', 'SERVER Key REMOTE_ADDR : Value 3.237.71.23' ), ( '320401', '63', 'SERVER Key DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '320401', '64', 'SERVER Key REQUEST_SCHEME : Value http' ), ( '320401', '65', 'SERVER Key CONTEXT_PREFIX : Value ' ), ( '320401', '66', 'SERVER Key CONTEXT_DOCUMENT_ROOT : Value /home/factorydirectbik/public_html' ), ( '320401', '67', 'SERVER Key SERVER_ADMIN : Value webmaster@factorydirectbikes.com' ), ( '320401', '68', 'SERVER Key SCRIPT_FILENAME : Value /home/factorydirectbik/public_html/control/terms_and_conditions/index.php' ), ( '320401', '69', 'SERVER Key REMOTE_PORT : Value 40092' ), ( '320401', '70', 'SERVER Key SERVER_PROTOCOL : Value HTTP/1.1' ), ( '320401', '71', 'SERVER Key REQUEST_METHOD : Value GET' ), ( '320401', '72', 'SERVER Key QUERY_STRING : Value ' ), ( '320401', '73', 'SERVER Key REQUEST_URI : Value /control/terms_and_conditions/' ), ( '320401', '74', 'SERVER Key SCRIPT_NAME : Value /control/terms_and_conditions/index.php' ), ( '320401', '75', 'SERVER Key PHP_SELF : Value /control/terms_and_conditions/index.php' ), ( '320401', '76', 'SERVER Key REQUEST_TIME_FLOAT : Value 1600411078.8697' ), ( '320401', '77', 'SERVER Key REQUEST_TIME : Value 1600411078' ), ( '320401', '78', 'F~identify_ip_location~1600411078.8851' ), ( '320401', '79', '' ), ( '320401', '80', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '81', '/home/factorydirectbik/public_html/modules/script_open_start.php:495 ' ), ( '320401', '82', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '83', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '84', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '85', 'SELECT[crnl]				a.iso3,[crnl]				b.iso2,[crnl]				b.country,[crnl]				c.allow[crnl]			   FROM[crnl]				ip_country AS a[crnl]				LEFT OUTER JOIN ip_country_codes AS b	ON a.iso3 = b.iso3[crnl]				LEFT OUTER JOIN ecomm_countries AS c	ON b.iso2 = c.abrev_name[crnl]			   WHERE[crnl]				a.ip_start <= '65881879' AND a.ip_end >= '65881879'[crnl]				 - UPDATE Record count 1' ), ( '320401', '86', '' ), ( '320401', '87', ' ip_tracker1600411078.8988' ), ( '320401', '88', '' ), ( '320401', '89', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '90', '/home/factorydirectbik/public_html/modules/script_open_start.php:543 ' ), ( '320401', '91', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '92', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '93', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '94', 'SELECT ipt_id, created, updated, hits, strike, banned_until FROM ip_tracker WHERE ip_address = '3.237.71.23'  - UPDATE Record count 0' ), ( '320401', '95', '' ), ( '320401', '96', '' ), ( '320401', '97', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '98', '/home/factorydirectbik/public_html/modules/script_open_start.php:575 ' ), ( '320401', '99', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '100', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '101', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '102', 'INSERT INTO ip_tracker ( ip_address, created, updated, hits ) VALUES ( '3.237.71.23', '1600411078', '1600411078', '1' ) ; - UPDATE Record count 1' ), ( '320401', '103', ' get all ip_recs1600411078.8995' ), ( '320401', '104', '' ), ( '320401', '105', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '106', '/home/factorydirectbik/public_html/modules/script_open_start.php:616 ' ), ( '320401', '107', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '108', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '109', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '110', 'SELECT[crnl]					t.created,[crnl]					b.ip_id AS banned_id,	b.hits AS banned_hits,[crnl]					u.ip_id AS uk_id,		u.hits AS uk_hits, 		u.cookies_allowed AS uk_cookies_allowed, u.who AS uk_who, u.notes AS uk_notes,[crnl]					n.ip_id AS non_uk_id,	n.hits AS non_uk_hits,	n.cookies_allowed AS non_uk_cookies_allowed, n.who AS non_uk_who, n.notes AS non_uk_notes,[crnl]					r.ip_id AS robot_id,	r.hits AS robot_hits,	r.cookies_allowed AS robot_cookies_allowed,[crnl]					s.ip_id AS scraper_id,	s.hits AS scraper_hits,	s.cookies_allowed AS scraper_cookies_allowed, s.price_adjustment[crnl]					FROM ip_tracker	AS t[crnl]					LEFT OUTER JOIN banned_ip_addresses	AS b	on t.ip_address	= b.ip_address[crnl]					LEFT OUTER JOIN ip_addresses		AS u	on t.ip_address	= u.ip_address[crnl]					LEFT OUTER JOIN non_uk_ip_addresses	AS n	on t.ip_address	= n.ip_address[crnl]					LEFT OUTER JOIN robot_ip_addresses	AS r	on t.ip_address	= r.ip_address[crnl]					LEFT OUTER JOIN scraper_ip_addresses	AS s	on t.ip_address	= s.ip_address[crnl]					WHERE t.ip_address = '3.237.71.23'  - UPDATE Record count 1' ), ( '320401', '111', '' ), ( '320401', '112', ' ip_robot' ), ( '320401', '113', ' Screen shot processing1600411078.9004 whos_online' ), ( '320401', '114', '' ), ( '320401', '115', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '116', '/home/factorydirectbik/public_html/modules/script_open_start.php:957 ' ), ( '320401', '117', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '118', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '119', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '120', 'SELECT * FROM whos_online WHERE session_id = 'e029a5e37a8aac6dbe26ea70f7611046' ; - UPDATE Record count 0' ), ( '320401', '121', '' ), ( '320401', '122', '' ), ( '320401', '123', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '124', '/home/factorydirectbik/public_html/modules/script_open_start.php:1066 ' ), ( '320401', '125', '/home/factorydirectbik/public_html/p_include/script_open.php:5 ' ), ( '320401', '126', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '127', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '128', 'SELECT session_id FROM whos_online WHERE ext_sess_id = 'B5edvxwwve8rWE1d' - UPDATE Record count 0' ), ( '320401', '129', '' ), ( '320401', '130', ' read_cookies read_cookies =  check_cookies = -1 cookies_accepted =  screen_width = 1600411078.901' ), ( '320401', '131', ' set_screen_width1600411078.901' ), ( '320401', '132', 'P~initialize_script~1600411078.881~' ), ( '320401', '133', '' ), ( '320401', '134', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '135', '/home/factorydirectbik/public_html/p_include/script_open.php:143 ' ), ( '320401', '136', '/home/factorydirectbik/public_html/index.php:35 ' ), ( '320401', '137', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '138', 'SELECT * from html where page_id = '302'  - UPDATE Record count 1' ), ( '320401', '139', '' ), ( '320401', '140', 'T~/control/terms_and_conditions/index.php~1600411078.9014' ), ( '320401', '141', 'M~display_nav_tabs_3~1600411078.9021' ), ( '320401', '142', '' ), ( '320401', '143', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '144', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:34 ' ), ( '320401', '145', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320401', '146', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '148', '' ), ( '320401', '149', '' ), ( '320401', '150', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '151', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:100 ' ), ( '320401', '152', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320401', '153', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '155', '' ), ( '320401', '156', '' ), ( '320401', '157', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '158', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:161 ' ), ( '320401', '159', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320401', '160', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '161', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21  - UPDATE Record count 14' ), ( '320401', '162', '' ), ( '320401', '163', '' ), ( '320401', '164', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '165', '/home/factorydirectbik/public_html/p_include/display_nav_tabs_3.php:204 ' ), ( '320401', '166', '/home/factorydirectbik/public_html/index.php:54 ' ), ( '320401', '167', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '169', '' ), ( '320401', '170', '' ), ( '320401', '171', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '172', '/home/factorydirectbik/public_html/index.php:103 ' ), ( '320401', '173', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '174', 'SELECT * from site_pages WHERE deleted = 0 AND display = 0 AND site_page_id < 21 ;  - UPDATE Record count 14' ), ( '320401', '175', 'IF~display_site_page~1600411078.9447' ), ( '320401', '176', '' ), ( '320401', '177', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '178', '/home/factorydirectbik/public_html/index.php:258 ' ), ( '320401', '179', '/home/factorydirectbik/public_html/index.php:122 ' ), ( '320401', '180', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '181', 'SELECT title, heading, content from site_pages where site_page_id = '10'  - UPDATE Record count 1' ), ( '320401', '182', '' ), ( '320401', '183', 'M~setup_stepcarousel_old~1600411078.9468' ), ( '320401', '184', '' ), ( '320401', '185', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '186', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:29 ' ), ( '320401', '187', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '188', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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 > '1600411078' ) AND ( promo_starts = 0 OR promo_starts < '1600411078' ) [crnl]			   ORDER BY[crnl]				promo_ends ASC  - UPDATE Record count 32' ), ( '320401', '190', '' ), ( '320401', '191', '' ), ( '320401', '192', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '193', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:93 ' ), ( '320401', '194', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '195', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '197', '' ), ( '320401', '198', '' ), ( '320401', '199', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '200', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:136 ' ), ( '320401', '201', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '202', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '204', '' ), ( '320401', '205', '' ), ( '320401', '206', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '207', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:139 ' ), ( '320401', '208', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '209', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '210', 'CREATE TEMPORARY TABLE  `zq99_e029a5e37a8aac6dbe26ea70f7611046` ( `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' ), ( '320401', '211', '' ), ( '320401', '212', '' ), ( '320401', '213', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '214', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:188 ' ), ( '320401', '215', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '216', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '217', 'INSERT INTO `zq99_e029a5e37a8aac6dbe26ea70f7611046` ( `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' ), ( '320401', '218', '' ), ( '320401', '219', '' ), ( '320401', '220', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '221', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:194 ' ), ( '320401', '222', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '223', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '224', 'SELECT * FROM `zq99_e029a5e37a8aac6dbe26ea70f7611046` ORDER BY saving DESC LIMIT 0, 20 - UPDATE Record count 20' ), ( '320401', '225', '' ), ( '320401', '226', '' ), ( '320401', '227', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '228', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:233 ' ), ( '320401', '229', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '230', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '232', '' ), ( '320401', '233', '' ), ( '320401', '234', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '235', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:271 ' ), ( '320401', '236', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '237', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '239', '' ), ( '320401', '240', '' ), ( '320401', '241', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '242', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:314 ' ), ( '320401', '243', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '244', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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' ), ( '320401', '246', '' ), ( '320401', '247', '' ), ( '320401', '248', '/home/factorydirectbik/public_html/modules/script_open_start.php:3589 ' ), ( '320401', '249', '/home/factorydirectbik/public_html/modules/setup_stepcarousel_new.php:455 ' ), ( '320401', '250', '/home/factorydirectbik/public_html/index.php:127 ' ), ( '320401', '251', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '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 > '1600411078' ) AND ( pp.promo_starts = 0 OR pp.promo_starts < '1600411078' ) [crnl]			   ORDER BY [crnl]				p.updated DESC  [crnl]			   LIMIT 0, 5  - UPDATE Record count 0' ), ( '320401', '253', '' ), ( '320401', '254', 'P~close_script~1600411079.0001' ), ( '320401', '255', 'update_sceen_shot = false' ), ( '320401', '256', 'create_screen_shot = false' ), ( '320401', '257', 'create_screen_shot_contents = false' ), ( '320401', '258', 'update_screen_shot_contents = false' ), ( '320401', '259', 'screen_shot_activity = false' ), ( '320401', '260', 'public = true' ), ( '320401', '261', 'epos = false' ), ( '320401', '262', 'management = false' ), ( '320401', '263', 'P~finalize_output~1600411079.0008' ), ( '320401', '264', 'F~get_image~1600411079.0021' ), ( '320401', '265', 'no more official output~1600411079.0024' ), ( '320401', '266', '' ), ( '320401', '267', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '268', '/home/factorydirectbik/public_html/p_include/script_close.php:276 ' ), ( '320401', '269', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '270', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '271', 'LOCK TABLE `whos_online` WRITE ; - UPDATE Record count 0' ), ( '320401', '272', '' ), ( '320401', '273', '' ), ( '320401', '274', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '275', '/home/factorydirectbik/public_html/p_include/script_close.php:284 ' ), ( '320401', '276', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '277', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '278', 'DELETE FROM whos_online WHERE time_last_click < '1600407479' - UPDATE Record count 0' ), ( '320401', '279', '' ), ( '320401', '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]					'e029a5e37a8aac6dbe26ea70f7611046',[crnl]					'3.237.71.23',[crnl]					'1600411079',[crnl]					'1600411079',[crnl]					'1',[crnl]					'',[crnl]					'',[crnl]					':1280:Yes:No:Medium:Yes:No:No:No:Yes',[crnl]					'/control/terms_and_conditions/',[crnl]					'',[crnl]					'0',[crnl]					'0',[crnl]					'0',[crnl]					'1',[crnl]					'-1',[crnl]					'UNITED STATES',[crnl]					'1',[crnl]				'ec2-3-237-71-23.compute-1.amazonaws.com',[crnl]				'B5edvxwwve8rWE1d'[crnl]					)' ), ( '320401', '281', '' ), ( '320401', '282', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '283', '/home/factorydirectbik/public_html/p_include/script_close.php:340 ' ), ( '320401', '284', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '285', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '286', '* * * * Insert into whos_online - session e029a5e37a8aac6dbe26ea70f7611046 ip_address 3.237.71.23 failed' ), ( '320401', '287', '' ), ( '320401', '288', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '289', '/home/factorydirectbik/public_html/p_include/script_close.php:400 ' ), ( '320401', '290', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '291', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '292', 'LOCK TABLE `ip_tracker` WRITE ; - UPDATE Record count 0' ), ( '320401', '293', '' ), ( '320401', '294', '' ), ( '320401', '295', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '296', '/home/factorydirectbik/public_html/p_include/script_close.php:409 ' ), ( '320401', '297', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '298', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '299', 'DELETE FROM ip_tracker WHERE updated < 1595227079 ; - UPDATE Record count 0' ), ( '320401', '300', '' ), ( '320401', '301', '' ), ( '320401', '302', '/home/factorydirectbik/public_html/modules/script_open_start.php:3600 ' ), ( '320401', '303', '/home/factorydirectbik/public_html/p_include/script_close.php:570 ' ), ( '320401', '304', '/home/factorydirectbik/public_html/index.php:225 ' ), ( '320401', '305', '/home/factorydirectbik/public_html/control/terms_and_conditions/index.php:37 ' ), ( '320401', '306', 'LOCK TABLE `error_log_master` WRITE, `error_log_detail` WRITE ; - UPDATE Record count 0' ), ( '320401', '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/terms_and_conditions/index.php:37