1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '50'%' or `model` like '%~50'%' or `model` like '%~50'') and (`model`='cable' ...' at line 4
in:
[(select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `model` is not null and ( ((`model`='50\'' or `model` like '50\'%' or `model` like '%~50\'%' or `model` like '%~50\'' or `model`='50ft' or `model` like '50ft%' or `model` like '%~50ft%' or `model` like '%~50ft' or `model`='50'' or `model` like '50'%' or `model` like '%~50'%' or `model` like '%~50'') and (`model`='cable' or `model` like 'cable%' or `model` like '%~cable%' or `model` like '%~cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `default_model` is not null and ( ((`default_model`='50\'' or `default_model` like '50\'%' or `default_model` like '%~50\'%' or `default_model` like '%~50\'' or `default_model`='50ft' or `default_model` like '50ft%' or `default_model` like '%~50ft%' or `default_model` like '%~50ft' or `default_model`='50'' or `default_model` like '50'%' or `default_model` like '%~50'%' or `default_model` like '%~50'') and (`default_model`='cable' or `default_model` like 'cable%' or `default_model` like '%~cable%' or `default_model` like '%~cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `manuf_model` is not null and ( ((`manuf_model`='50\'' or `manuf_model` like '50\'%' or `manuf_model` like '%~50\'%' or `manuf_model` like '%~50\'' or `manuf_model`='50ft' or `manuf_model` like '50ft%' or `manuf_model` like '%~50ft%' or `manuf_model` like '%~50ft' or `manuf_model`='50'' or `manuf_model` like '50'%' or `manuf_model` like '%~50'%' or `manuf_model` like '%~50'') and (`manuf_model`='cable' or `manuf_model` like 'cable%' or `manuf_model` like '%~cable%' or `manuf_model` like '%~cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `search_terms` is not null and ( ((`search_terms`='50\'' or `search_terms` like '50\'%' or `search_terms` like '%~50\'%' or `search_terms` like '%~50\'' or `search_terms`='50ft' or `search_terms` like '50ft%' or `search_terms` like '%~50ft%' or `search_terms` like '%~50ft' or `search_terms`='50'' or `search_terms` like '50'%' or `search_terms` like '%~50'%' or `search_terms` like '%~50'') and (`search_terms`='cable' or `search_terms` like 'cable%' or `search_terms` like '%~cable%' or `search_terms` like '%~cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `search_terms` is not null and ( ((`search_terms`='50\'' or `search_terms` like '50\'%' or `search_terms` like '%~50\'%' or `search_terms` like '%~50\'' or `search_terms`='50ft' or `search_terms` like '50ft%' or `search_terms` like '%~50ft%' or `search_terms` like '%~50ft' or `search_terms`='50'' or `search_terms` like '50'%' or `search_terms` like '%~50'%' or `search_terms` like '%~50'') and (`search_terms`='cable' or `search_terms` like 'cable%' or `search_terms` like '%~cable%' or `search_terms` like '%~cable'))) and status=1 and prevent_from_search=1 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `3g_4g_support` is not null and ( ((`3g_4g_support`='50\'' or `3g_4g_support` like '50\'%' or `3g_4g_support` like '%~50\'%' or `3g_4g_support` like '%~50\'' or `3g_4g_support`='50ft' or `3g_4g_support` like '50ft%' or `3g_4g_support` like '%~50ft%' or `3g_4g_support` like '%~50ft' or `3g_4g_support`='50'' or `3g_4g_support` like '50'%' or `3g_4g_support` like '%~50'%' or `3g_4g_support` like '%~50'') and (`3g_4g_support`='cable' or `3g_4g_support` like 'cable%' or `3g_4g_support` like '%~cable%' or `3g_4g_support` like '%~cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `upc` is not null and ( ((`upc`='50\'' or `upc` like '50\'%' or `upc` like '% 50\'%' or `upc` like '% 50\'' or `upc`='50ft' or `upc` like '50ft%' or `upc` like '% 50ft%' or `upc` like '% 50ft' or `upc`='50'' or `upc` like '50'%' or `upc` like '% 50'%' or `upc` like '% 50'') and (`upc`='cable' or `upc` like 'cable%' or `upc` like '% cable%' or `upc` like '% cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `name` is not null and ( ((REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50\'' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50\'%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50ft' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50ft%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50'' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50'%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'') and (REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','')='cable' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like 'cable%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable%' or REGEXP_REPLACE(REPLACE(`name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `products_name` is not null and ( ((REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50\'' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50\'%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50ft' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50ft%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50'' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50'%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'') and (REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='cable' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like 'cable%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable%' or REGEXP_REPLACE(REPLACE(`products_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `invoice_name` is not null and ( ((REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50\'' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50\'%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50ft' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50ft%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50'' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50'%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'') and (REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='cable' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like 'cable%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable%' or REGEXP_REPLACE(REPLACE(`invoice_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable'))) and status=1 and prevent_from_search=0 and 1=1) union (select pid,name,model,SUBSTR(description,1,100) as description,image,url,product_url,prevent_from_search,service_item,price,was_price,slob_price,IF(was_price is not null and was_price>0,was_price,price) as base_price,stock,stock_class,button,top_product,top_product_image,special_bundle_offer, hide_price,rating,reviews,sale_total,manufacturers_id,types_id,peplink_category,is_router,is_cband_router,group_id,group_master,group_min_price,group_max_price,hits,popularity,created,0 as sorter,manufacturers_id,manufacturers_name,types_id,types_name,parent_types_id,parent_types_name,home_links_ids,home_links_names,antenna_frequency_keys,antenna_frequency_names, amplifier_solution_keys,amplifier_solution_names,networking_features,wifi_features,mobile_features,supported_form_factors,frequency_bands,accessories_ids,accessories_names, routers_ids,routers_names,antennas_ids,antennas_names,amplifiers_ids,amplifiers_names,repeaters_ids,repeaters_names from ksearch where `short_name` is not null and ( ((REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50\'' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50\'%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50\'' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50ft' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50ft%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50ft' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='50'' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '50'%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% 50'') and (REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','')='cable' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like 'cable%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable%' or REGEXP_REPLACE(REPLACE(`short_name`,'/',' '),'[^a-zA-Z0-9- ]+','') like '% cable'))) and status=1 and prevent_from_search=0 and 1=1) order by sorter desc,service_item asc,popularity desc,hits desc,name asc]