Systémové upozornění
Hlavní informace

Svítidla

23W

14,4W

9W

4,5W

Array
(
    [0] => Array
        (
            [virtuemart_category_id] => 2
            [virtuemart_vendor_id] => 1
            [category_name] => Produkty
            [slug] => produkty
            [category_description] => 
            [category_template] => 0
            [category_layout] => 0
            [category_product_layout] => 0
            [products_per_row] => 6
            [ordering] => 0
            [shared] => 0
            [limit_list_step] => 10
            [limit_list_initial] => 0
            [metadesc] => 
            [customtitle] => Produkty
            [metakey] => Produkty
            [metarobot] => 
            [metaauthor] => 
            [published] => 1
            [VmTable_lhash] => dc6c518f524ef85cffd646e9e4e44df5
            [*_tbl] => #__virtuemart_categories
            [*_tbl_lang] => #__virtuemart_categories_cs_cz
            [*_tbl_key] => virtuemart_category_id
            [*_tbl_keys] => Array
                (
                    [0] => virtuemart_category_id
                )

            [*_pkey] => virtuemart_category_id
            [*_pkeyForm] => cid
            [*_obkeys] => Array
                (
                    [category_name] => 1
                    [slug] => 1
                )

            [*_unique] => 1
            [*_unique_name] => Array
                (
                    [slug] => 1
                )

            [*_orderingKey] => ordering
            [*_slugAutoName] => category_name
            [*_slugName] => slug
            [*_db] => JDatabaseDriverMysqli Object
                (
                    [name] => mysqli
                    [serverType] => mysql
                    [connection:protected] => mysqli Object
                        (
                            [affected_rows] => 1
                            [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
                            [client_version] => 50011
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 0
                            [error] => 
                            [error_list] => Array
                                (
                                )

                            [field_count] => 1
                            [host_info] => 127.0.0.1 via TCP/IP
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.6.33
                            [server_version] => 50633
                            [stat] => Uptime: 54189479  Threads: 8  Questions: 130213797982  Slow queries: 85766  Opens: 672402485  Flush tables: 1  Open tables: 1000  Queries per second avg: 2402.935
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 284376204
                            [warning_count] => 0
                        )

                    [nameQuote:protected] => `
                    [nullDate:protected] => 0000-00-00 00:00:00
                    [_database:JDatabaseDriver:private] => alumiacz1
                    [count:protected] => 289
                    [cursor:protected] => 
                    [debug:protected] => 
                    [limit:protected] => 1000
                    [log:protected] => Array
                        (
                        )

                    [timings:protected] => Array
                        (
                        )

                    [callStacks:protected] => Array
                        (
                        )

                    [offset:protected] => 0
                    [options:protected] => Array
                        (
                            [driver] => mysqli
                            [host] => 127.0.0.1
                            [user] => alumia.cz.1
                            [password] => hUhatej45*akJel
                            [database] => alumiacz1
                            [prefix] => ej30_
                            [select] => 1
                            [port] => 3306
                            [socket] => 
                        )

                    [sql:protected] => SELECT  p.`virtuemart_product_id` FROM `#__virtuemart_products` as p  
 LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28  
 LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
 LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14 
 WHERE ( `pc`.`virtuemart_category_id` = 88 AND  `c`.`published` = 1  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND  p.`published`="1"  AND  cfl.`customfield_value` = "1" ) 
 group by p.`virtuemart_product_id` 
 ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
                    [tablePrefix:protected] => ej30_
                    [utf:protected] => 1
                    [utf8mb4:protected] => 1
                    [errorNum:protected] => 0
                    [errorMsg:protected] => 
                    [transactionDepth:protected] => 0
                    [disconnectHandlers:protected] => Array
                        (
                        )

                )

            [*_rules] => 
            [*_trackAssets] => 
            [*_locked] => 
            [*_loggable] => 1
            [_xParams] => 0
            [_varsToPushParam] => Array
                (
                )

            [_translatable] => 1
            [*_translatableFields] => Array
                (
                    [0] => category_name
                    [1] => category_description
                    [2] => metadesc
                    [3] => metakey
                    [4] => customtitle
                    [slug] => slug
                )

            [_cryptedFields] => 
            [*_langTag] => cs_cz
            [_ltmp] => 
            [_loaded] => 
            [*_updateNulls] => 
            [_tablePreFix] => c.
            [_autoincrement] => 1
            [_observers] => JObserverUpdater Object
                (
                    [observers:protected] => Array
                        (
                        )

                    [doCallObservers:protected] => 1
                )

            [created_on] => 2016-04-13 12:17:27
            [created_by] => 0
            [modified_on] => 2020-07-05 09:34:29
            [modified_by] => 0
            [id] => 68840581
        )

    [1] => Array
        (
            [virtuemart_category_id] => 27
            [virtuemart_vendor_id] => 1
            [category_name] => LED pásky
            [slug] => led-pasky
            [category_description] => 
            [category_template] => 0
            [category_layout] => 0
            [category_product_layout] => 0
            [products_per_row] => 6
            [ordering] => 0
            [shared] => 0
            [limit_list_step] => 10
            [limit_list_initial] => 0
            [metadesc] => 
            [customtitle] => LED pásky
            [metakey] => LED pásky
            [metarobot] => 
            [metaauthor] => 
            [published] => 1
            [VmTable_lhash] => 226724392b246c0164b503f4fa9da68e
            [*_tbl] => #__virtuemart_categories
            [*_tbl_lang] => #__virtuemart_categories_cs_cz
            [*_tbl_key] => virtuemart_category_id
            [*_tbl_keys] => Array
                (
                    [0] => virtuemart_category_id
                )

            [*_pkey] => virtuemart_category_id
            [*_pkeyForm] => cid
            [*_obkeys] => Array
                (
                    [category_name] => 1
                    [slug] => 1
                )

            [*_unique] => 1
            [*_unique_name] => Array
                (
                    [slug] => 1
                )

            [*_orderingKey] => ordering
            [*_slugAutoName] => category_name
            [*_slugName] => slug
            [*_db] => JDatabaseDriverMysqli Object
                (
                    [name] => mysqli
                    [serverType] => mysql
                    [connection:protected] => mysqli Object
                        (
                            [affected_rows] => -1
                            [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
                            [client_version] => 50011
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 0
                            [error] => 
                            [error_list] => Array
                                (
                                )

                            [field_count] => 1
                            [host_info] => 127.0.0.1 via TCP/IP
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.6.33
                            [server_version] => 50633
                            [stat] => Uptime: 54189479  Threads: 8  Questions: 130213797988  Slow queries: 85766  Opens: 672402485  Flush tables: 1  Open tables: 1000  Queries per second avg: 2402.935
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 284376204
                            [warning_count] => 0
                        )

                    [nameQuote:protected] => `
                    [nullDate:protected] => 0000-00-00 00:00:00
                    [_database:JDatabaseDriver:private] => alumiacz1
                    [count:protected] => 289
                    [cursor:protected] => 
                    [debug:protected] => 
                    [limit:protected] => 1000
                    [log:protected] => Array
                        (
                        )

                    [timings:protected] => Array
                        (
                        )

                    [callStacks:protected] => Array
                        (
                        )

                    [offset:protected] => 0
                    [options:protected] => Array
                        (
                            [driver] => mysqli
                            [host] => 127.0.0.1
                            [user] => alumia.cz.1
                            [password] => hUhatej45*akJel
                            [database] => alumiacz1
                            [prefix] => ej30_
                            [select] => 1
                            [port] => 3306
                            [socket] => 
                        )

                    [sql:protected] => SELECT  p.`virtuemart_product_id` FROM `#__virtuemart_products` as p  
 LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28  
 LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
 LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14 
 WHERE ( `pc`.`virtuemart_category_id` = 88 AND  `c`.`published` = 1  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND  p.`published`="1"  AND  cfl.`customfield_value` = "1" ) 
 group by p.`virtuemart_product_id` 
 ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
                    [tablePrefix:protected] => ej30_
                    [utf:protected] => 1
                    [utf8mb4:protected] => 1
                    [errorNum:protected] => 0
                    [errorMsg:protected] => 
                    [transactionDepth:protected] => 0
                    [disconnectHandlers:protected] => Array
                        (
                        )

                )

            [*_rules] => 
            [*_trackAssets] => 
            [*_locked] => 
            [*_loggable] => 1
            [_xParams] => 0
            [_varsToPushParam] => Array
                (
                )

            [_translatable] => 1
            [*_translatableFields] => Array
                (
                    [0] => category_name
                    [1] => category_description
                    [2] => metadesc
                    [3] => metakey
                    [4] => customtitle
                    [slug] => slug
                )

            [_cryptedFields] => 
            [*_langTag] => cs_cz
            [_ltmp] => 
            [_loaded] => 
            [*_updateNulls] => 
            [_tablePreFix] => c.
            [_autoincrement] => 1
            [_observers] => JObserverUpdater Object
                (
                    [observers:protected] => Array
                        (
                        )

                    [doCallObservers:protected] => 1
                )

            [created_on] => 2016-07-29 12:43:26
            [created_by] => 0
            [modified_on] => 2020-07-05 09:34:30
            [modified_by] => 0
            [id] => 68840582
        )

    [2] => Array
        (
            [virtuemart_category_id] => 88
            [virtuemart_vendor_id] => 1
            [category_name] => 4,5W
            [slug] => 4-5w
            [category_description] => 
            [category_template] => 0
            [category_layout] => 0
            [category_product_layout] => 0
            [products_per_row] => 6
            [ordering] => 0
            [shared] => 0
            [limit_list_step] => 10
            [limit_list_initial] => 0
            [metadesc] => 
            [customtitle] => 4,5W
            [metakey] => 4,5W
            [metarobot] => 
            [metaauthor] => 
            [published] => 1
            [VmTable_lhash] => 77ea7439e5614a15dda0a8a5de419c66
            [*_tbl] => #__virtuemart_categories
            [*_tbl_lang] => #__virtuemart_categories_cs_cz
            [*_tbl_key] => virtuemart_category_id
            [*_tbl_keys] => Array
                (
                    [0] => virtuemart_category_id
                )

            [*_pkey] => virtuemart_category_id
            [*_pkeyForm] => cid
            [*_obkeys] => Array
                (
                    [category_name] => 1
                    [slug] => 1
                )

            [*_unique] => 1
            [*_unique_name] => Array
                (
                    [slug] => 1
                )

            [*_orderingKey] => ordering
            [*_slugAutoName] => category_name
            [*_slugName] => slug
            [*_db] => JDatabaseDriverMysqli Object
                (
                    [name] => mysqli
                    [serverType] => mysql
                    [connection:protected] => mysqli Object
                        (
                            [affected_rows] => -1
                            [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
                            [client_version] => 50011
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 0
                            [error] => 
                            [error_list] => Array
                                (
                                )

                            [field_count] => 1
                            [host_info] => 127.0.0.1 via TCP/IP
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.6.33
                            [server_version] => 50633
                            [stat] => Uptime: 54189479  Threads: 8  Questions: 130213797990  Slow queries: 85766  Opens: 672402485  Flush tables: 1  Open tables: 1000  Queries per second avg: 2402.935
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 284376204
                            [warning_count] => 0
                        )

                    [nameQuote:protected] => `
                    [nullDate:protected] => 0000-00-00 00:00:00
                    [_database:JDatabaseDriver:private] => alumiacz1
                    [count:protected] => 289
                    [cursor:protected] => 
                    [debug:protected] => 
                    [limit:protected] => 1000
                    [log:protected] => Array
                        (
                        )

                    [timings:protected] => Array
                        (
                        )

                    [callStacks:protected] => Array
                        (
                        )

                    [offset:protected] => 0
                    [options:protected] => Array
                        (
                            [driver] => mysqli
                            [host] => 127.0.0.1
                            [user] => alumia.cz.1
                            [password] => hUhatej45*akJel
                            [database] => alumiacz1
                            [prefix] => ej30_
                            [select] => 1
                            [port] => 3306
                            [socket] => 
                        )

                    [sql:protected] => SELECT  p.`virtuemart_product_id` FROM `#__virtuemart_products` as p  
 LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28  
 LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
 LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14 
 WHERE ( `pc`.`virtuemart_category_id` = 88 AND  `c`.`published` = 1  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND  p.`published`="1"  AND  cfl.`customfield_value` = "1" ) 
 group by p.`virtuemart_product_id` 
 ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
                    [tablePrefix:protected] => ej30_
                    [utf:protected] => 1
                    [utf8mb4:protected] => 1
                    [errorNum:protected] => 0
                    [errorMsg:protected] => 
                    [transactionDepth:protected] => 0
                    [disconnectHandlers:protected] => Array
                        (
                        )

                )

            [*_rules] => 
            [*_trackAssets] => 
            [*_locked] => 
            [*_loggable] => 1
            [_xParams] => 0
            [_varsToPushParam] => Array
                (
                )

            [_translatable] => 1
            [*_translatableFields] => Array
                (
                    [0] => category_name
                    [1] => category_description
                    [2] => metadesc
                    [3] => metakey
                    [4] => customtitle
                    [slug] => slug
                )

            [_cryptedFields] => 
            [*_langTag] => cs_cz
            [_ltmp] => 
            [_loaded] => 1
            [*_updateNulls] => 
            [_tablePreFix] => c.
            [_autoincrement] => 1
            [_observers] => JObserverUpdater Object
                (
                    [observers:protected] => Array
                        (
                        )

                    [doCallObservers:protected] => 1
                )

            [created_on] => 2020-06-22 07:33:42
            [created_by] => 0
            [modified_on] => 2020-07-05 09:34:30
            [modified_by] => 0
            [id] => 68840583
        )

)
Základní cena:
Základní cena pro tuto variantu:
Modifikátor variant cen
Prodejní cena
Cena bez DPH:
Sleva:
Hodnota DPH
Cena / m: