enterpristore.com Our Line Card Events Shop by Brand Store Locator

Language:

EnglishEspañol

My Cart (0)

My Shopping Cart

Your shopping cart is empty

Need help? Reach us at 1800.325.9708 Live Support

more search options

Access &
Intercom
- Gate Operator
- Credentials
  - Smart
  - Barcode
  - Mobile
  - Accessories
  - Prox
  - RFID
- Door Controllers & Software
  - Panels
  - Accessories
  - Kits
  - Software
- Exit Devices
  - Motion
  - Accessories
  - Push Bar
  - Key Switch
  - Push Buttons
  - Non-Touch
- Intercoms
- Keypads
  - Stand Alone
- Locking Devices
- Metal Detectors
  - Hanheld Devices
- Readers
  - Accessories
  - Smart
  - UHF / RFID
  - Biometrics
  - Prox
  - Laser
- Tele-Entry
  - Accessories
  - Panels
- Voice over IP
  - IP Phones
- Accessories
  - Custom Buttons
Audio &
Video
CCTV
- Analog Cameras
  - Specialty
  - Turret
  - Dome
  - Fisheye
  - Box
  - Bullet
  - Eyeball
  - PTZ
- Analog Kits
- DVR
  - Hybrid
- Encoders & Decoders
  - Encoders
  - Decoders
- IP Cameras
  - PTZ
  - Bullet
  - Dome
  - Turret
  - Modular
  - Specialty
  - Eyeball
  - Fisheye
  - Panoramic
  - Thermal
- IP Kits
- NVR
- Software
- Accessories
  - Lens
  - Baluns & Receivers
  - Mounts
  - Monitors
  - Servers
  - Hard Drives
  - Workstations
  - Extenders
  - Microphones
Fire
Home Automation
Infrastructure
Power &
Batteries
- Batteries
- Power Accessories
- Power Supplies
  - Wall
  - Board Only
  - Plug-In
  - Laptop Style
  - Modules
  - Din-Rail
  - Rack Mount
- Surge Suppression
  - Surge Accessories
  - Intrusion
  - Fire
  - General
  - Data
  - CCTV
- Transformers
  - Bare
  - Plug-In
- UPS
  - Stand By
  - On-Line
Security
- Communication
  - Communicators
  - Central Station
- Contacts
  - Tampers
  - Accessories
  - Recessed
  - Overhead
  - Surface
  - Hold Up
- Control Panels & Keypads
  - Numeric
  - Panels
  - Icon Keypads
  - LCD Keypads
  - Touch Keypads
  - Kits
  - Gateway
- Intrusion Modules
  - Audio
  - Status
  - Translator
  - Expanders
  - Receivers
  - Repeaters
  - Wired to Wireless
- Panic
  - Hold Up
- Sensors
  - Motion & Glass
  - Glass & Shock
  - Heat
  - Motion
  - Door & Windows
  - Glass
  - Carbon Monoxide
  - Smoke
  - Flood
  - Environmental
  - Pool Alarm
  - Smoke & Heat
  - Temperature
  - Shock
  - Specialty
- Visual / Sounding Devices
  - Sirens
  - Speakers
  - Buzzer
  - Strobes
- Wireless Panic & Keyfobs
- Accessories
Tools &
Hardware

Home » Brands » Rokonet | Risco Group

Rokonet | Risco Group

select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '7' and ptpef2.products_extra_fields_value = '4') and p.manufacturers_id = 5026 and p.products_id in (146681) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")

Sorting

Category

Brand

Price

Channels

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price

from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id , products_description pd, categories c, products_to_categories p2c

where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and m.manufacturers_id = '5026' and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")

group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name

Kewords:

Plural keywords:

1 items

VUpoint 4-Channel NVR
# RVNVR040020A

Rokonet | Risco Group

1 items

About Us

About Us
Store Locator
Silmar Team
Line Card
Webinars
Events
Site Map

Customer Care

Financing for Dealers
My Account
Shop by Brand
Express Order
Our Catalog
Technical Library
Contact Us

Our Policies

FAQs
Silmar Electronics Terms of Use
General Terms and conditions
Website support
Returns & Exchanges

Distributor of Security, Fire, Access, CCTV, IP Products, Commercial & Residential Sound Systems and Accessories.

Silmar Electronics, Inc 3405 NW 113th Ct, Miami, FL 33178, United States

305.513.0484 Toll Free: 1.800.325.9708

[email protected]

Please note that some areas of this site are password protected and all material contained in these areas is designed for and available ONLY to professional security installation companies.

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again