27 maggio 2017 a Firenze
Festival della disabilità con musica, ballo e tecnologia


Disabili Abili Fest è il festival della disabilità per abbattere le barriere mentali, fisiche e architettoniche realizzato dalla Disabili Abili con il patrocinio del Comune di Firenze, del CONI Toscana del Csen Firenze e Prato, dell'Unione Nazionale Veterani dello Sport e Redattore Sociale.


  • 10.00 Apertura del Festival
  • 11.00 Tempo di sport
  • 13.00 Pranzo
  • 14.00 Tempo di sport
    • Prova a giocare a Basket con le Volpi Rosse Wheelchair Firenze Menarini
    • Prova a giocare a Tennis con l’Ass. Sportiva FunTennis Incisa Valdarno
    • Prova a giocare a bocce con Polisportiva Handicappati Fiorentini e Cooperativa La Fortezza
  • 14.00 Inizio del Talent Show
    Presenterà: LuluRimmel (cantante romana)
    Presidente di giuria: Valentina Acciardi (concorrente del Grande Fratello 13)
    Giuria: Maximiliano Ulivieri (ass. Love Ability), Cris Brave (rapper), Andrea Mura e Giacomo Betti (testimonial Disabili Abili)
  • 17.45 Esibizione di danza con Wheelchair Dance Firenze - Centro Toscano di danza Integrata
  • 18.00 Premiazione Talent Show
  • 18.30 Concerto L'uluLele

Corìma Produzioni & Casting selezionarà storie e volti per le proprie trasmissioni televisivie dedicate alla disabilità.

Durante tutta la giornata potrete provare le attività sportive per persone con disabilità, le carrozzine sportive e le carrozzine altamente tecnologiche offerte dalla Disabili Abili.


L'evento "disabili abili Fest 2017" si terrà presso l' Unione Sportiva Affrico - Viale Manfredo Fanti, 20, 50137 Firenze (www.usaffrico.it). Vedi mappa


ISCRIVITI   avrai in regalo il Kit del Festival!


Risparmia da subito ed ottieni crediti e sconti per i prossimi acquisti Clicca qui!

disabili abili : Prodotti in promozione


Hai diritto all'IVA agevolata al 4% ai sensi della legge 104/92?

Exception Object
(
    [message:protected] => Unknown column 'count_views' in 'order clause'
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /var/www/erp/erp/admin/include/functions.inc.php
    [line:protected] => 621
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/dbmysql.inc.php
                    [line] => 146
                    [function] => t_ex
                    [args] => Array
                        (
                            [0] => Unknown column 'count_views' in 'order clause'
                        )

                )

            [1] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 3383
                    [function] => query
                    [class] => DB
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT p.*,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text,(SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers,(SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories,(SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list,(SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations,(SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values,(SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices,(SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos,(SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos,(SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id,(SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite,(SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews,(SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category,(SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name,(SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name,(SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos,(SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text,(SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions,(SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values,(SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls,(SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections FROM product p,product_supplier ps WHERE ps.product_id = p.product_id AND supplier_id = '10' AND enabled = '1' AND p.product_deleted = 0 GROUP BY p.product_id  ORDER BY count_views DESC
                        )

                )

            [2] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 3437
                    [function] => qa
                    [args] => Array
                        (
                            [0] => SELECT p.*,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text,(SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers,(SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories,(SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list,(SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations,(SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values,(SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices,(SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos,(SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos,(SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id,(SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite,(SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews,(SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category,(SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name,(SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name,(SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos,(SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text,(SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions,(SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values,(SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls,(SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections FROM product p,product_supplier ps WHERE ps.product_id = p.product_id AND supplier_id = '10' AND enabled = '1' AND p.product_deleted = 0 GROUP BY p.product_id  ORDER BY count_views DESC
                            [1] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 2000
                    [function] => query
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [select] => Array
                                        (
                                            [0] => p.*
                                            [1] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text
                                            [2] => (SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers
                                            [3] => (SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories
                                            [4] => (SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list
                                            [5] => (SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations
                                            [6] => (SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values
                                            [7] => (SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices
                                            [8] => (SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos
                                            [9] => (SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos
                                            [10] => (SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id
                                            [11] => (SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite
                                            [12] => (SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews
                                            [13] => (SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews
                                            [14] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category
                                            [15] => (SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name
                                            [16] => (SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name
                                            [17] => (SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos
                                            [18] => (SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability
                                            [19] => (SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text
                                            [20] => (SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text
                                            [21] => (SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions
                                            [22] => (SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values
                                            [23] => (SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext
                                            [24] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls
                                            [25] => (SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections
                                        )

                                    [limit] => 
                                    [from] => Array
                                        (
                                            [0] => product p
                                            [1] => product_supplier ps
                                        )

                                    [where] => Array
                                        (
                                            [0] => ps.product_id = p.product_id
                                            [1] => supplier_id = '10'
                                            [2] => enabled = '1'
                                            [3] => p.product_deleted = 0
                                        )

                                    [group_by] => Array
                                        (
                                            [0] => p.product_id
                                        )

                                    [order_by] => Array
                                        (
                                            [0] => count_views DESC
                                        )

                                )

                            [1] => 1
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/erp/erp/disabiliabili/index.php
                    [line] => 167
                    [function] => get_products
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [where] => Array
                                        (
                                            [supplier_id] => 10
                                            [enabled] => 1
                                        )

                                    [order_by] => Array
                                        (
                                            [0] => count_views DESC
                                        )

                                )

                        )

                )

        )

    [previous:Exception:private] => 
)
Exception Object
(
    [message:protected] => Unknown column 'count_views' in 'order clause'
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /var/www/erp/erp/admin/include/functions.inc.php
    [line:protected] => 621
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/dbmysql.inc.php
                    [line] => 146
                    [function] => t_ex
                    [args] => Array
                        (
                            [0] => Unknown column 'count_views' in 'order clause'
                        )

                )

            [1] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 3383
                    [function] => query
                    [class] => DB
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT p.*,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text,(SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers,(SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories,(SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list,(SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations,(SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values,(SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices,(SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos,(SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos,(SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id,(SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite,(SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews,(SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category,(SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name,(SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name,(SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos,(SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text,(SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions,(SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values,(SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls,(SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections FROM product p,product_supplier ps WHERE ps.product_id = p.product_id AND supplier_id = '10' AND enabled = '1' AND p.product_deleted = 0 GROUP BY p.product_id  ORDER BY count_views DESC 
                        )

                )

            [2] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 3449
                    [function] => qa
                    [args] => Array
                        (
                            [0] => SELECT p.*,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text,(SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers,(SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories,(SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list,(SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations,(SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values,(SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices,(SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos,(SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos,(SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id,(SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite,(SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews,(SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category,(SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name,(SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name,(SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos,(SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text,(SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text,(SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions,(SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values,(SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext,(SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls,(SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections FROM product p,product_supplier ps WHERE ps.product_id = p.product_id AND supplier_id = '10' AND enabled = '1' AND p.product_deleted = 0 GROUP BY p.product_id  ORDER BY count_views DESC 
                            [1] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /var/www/erp/erp/admin/include/functions.inc.php
                    [line] => 2000
                    [function] => query
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [select] => Array
                                        (
                                            [0] => p.*
                                            [1] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.product_id AND text_context = 'product' GROUP BY text_id LIMIT 1) as text
                                            [2] => (SELECT GROUP_CONCAT(supplier_id) FROM product_supplier sp WHERE sp.product_id = p.product_id GROUP BY product_id) as suppliers
                                            [3] => (SELECT GROUP_CONCAT(category_id) FROM product_category pc WHERE pc.product_id = p.product_id GROUP BY product_id) as categories
                                            [4] => (SELECT GROUP_CONCAT(combination_id ORDER BY c.combination_sort_order) FROM combination c WHERE c.product_id = p.product_id GROUP BY product_id) as combination_id_list
                                            [5] => (SELECT GROUP_CONCAT(attribute_value_id SEPARATOR '-') FROM (SELECT cav.product_id, CONCAT(cav.combination_id,':',GROUP_CONCAT(CONCAT(attribute_id,';',attribute_value_id) ORDER BY attribute_sort_order)) as attribute_value_id FROM combination_attribute_value cav LEFT JOIN attribute a USING(attribute_id) LEFT JOIN combination comb USING(combination_id) GROUP BY cav.combination_id ORDER BY comb.combination_sort_order) as tmp_1 WHERE tmp_1.product_id = p.product_id GROUP BY tmp_1.product_id) as combinations
                                            [6] => (SELECT GROUP_CONCAT(CONCAT('combination_id','§',c.combination_id,'ç','combination_status','§',c.combination_status,'ç','reference_code','§',c.reference_code,'ç','ean_code','§',c.ean_code,'ç','upc_barcode','§',c.upc_barcode,'ç','product_package_weight','§',c.product_package_weight,'ç','combination_default','§',c.combination_default)  ORDER BY c.combination_sort_order ASC SEPARATOR '££') FROM combination c WHERE c.product_id = p.product_id) combination_values
                                            [7] => (SELECT GROUP_CONCAT(CONCAT(zone_id,',',combination_id,',',supplier_id,',','§', price_deal,',',price_discount,',',price_retail,',',price_sell_out,',',price_wholesale) SEPARATOR '-') FROM price  WHERE price.product_id = p.product_id GROUP BY price.product_id)as prices
                                            [8] => (SELECT GROUP_CONCAT(CONCAT(combination_id,'§',file_id) ORDER BY product_file_sort_order) FROM combination_file cf LEFT JOIN product_file pf USING(file_id) WHERE cf.product_id = p.product_id AND pf.product_id = p.product_id GROUP BY cf.product_id) as combination_photos
                                            [9] => (SELECT GROUP_CONCAT(CONCAT(f.file_id,'§',f.formats) ORDER BY product_file_sort_order SEPARATOR '-') FROM file f LEFT JOIN product_file pf USING(file_id) WHERE pf.product_id = p.product_id ) as photos
                                            [10] => (SELECT combination_id FROM combination c WHERE c.product_id = p.product_id AND combination_default = 1 LIMIT 1) as default_combination_id
                                            [11] => (SELECT COUNT(*) count_product_favorite FROM client_product pc WHERE pc.product_id = p.product_id AND pc.client_product_status = 1 GROUP BY pc.product_id) as count_product_favorite
                                            [12] => (SELECT AVG(pr.review_score) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as avg_reviews
                                            [13] => (SELECT COUNT(*) FROM product_review pr WHERE pr.enabled=1 AND pr.product_id = p.product_id GROUP BY pr.product_id) as count_reviews
                                            [14] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',text_type,'___',text_value) SEPARATOR '---') FROM text t WHERE t.text_id = p.default_category AND text_context = 'category' GROUP BY text_id ) as text_main_category
                                            [15] => (SELECT text_value FROM text t WHERE t.text_id = p.default_category AND t.lang_id = 1 AND t.text_type = 'product_category_name') as default_category_name
                                            [16] => (SELECT text_value FROM text t WHERE t.text_id = p.product_id AND text_type = 'product_name' AND lang_id = 1) as product_name
                                            [17] => (SELECT COUNT(*) FROM product_file pf WHERE pf.product_id = p.product_id) as count_product_photos
                                            [18] => (SELECT GROUP_CONCAT(combination_id,':',quantity) FROM combination c WHERE c.product_id = p.product_id GROUP BY c.product_id) as total_combination_availability
                                            [19] => (SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id,'___',cav.attribute_id)) ORDER BY attribute_sort_order SEPARATOR '---') as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_value_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'attribute_value_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_value_text
                                            [20] => (SELECT GROUP_CONCAT(DISTINCT(CONCAT(lang_id,'___',text_type,'___',text_value,'___',text_id)) ORDER BY attribute_sort_order SEPARATOR '---' ) as text FROM text t LEFT JOIN combination_attribute_value cav ON t.text_id = cav.attribute_id LEFT JOIN attribute a USING(attribute_id) WHERE t.text_value !='' AND t.text_type = 'product_attribute_name' AND cav.product_id = p.product_id GROUP BY cav.product_id ) as attribute_text
                                            [21] => (SELECT GROUP_CONCAT(CONCAT(pe.extension_id,'___',e.extension_label,'___',pe.product_extension_price)) FROM product_extension pe LEFT JOIN extension e USING(extension_id) WHERE pe.product_id = p.product_id) as product_extensions
                                            [22] => (SELECT GROUP_CONCAT(CONCAT(tax_rate_id,'___',tax_rate_value)) FROM product_tax_rate ptr LEFT JOIN tax_rate tr USING(tax_rate_id) WHERE ptr.product_id = p.product_id GROUP BY product_id) as tax_rate_values
                                            [23] => (SELECT GROUP_CONCAT(CONCAT(supplier_id,'§',combination_id,'§',extension_id,'§',product_extension_price,'§',product_extension_price_retail) SEPARATOR '-') FROM product_extension pe WHERE pe.product_id = p.product_id GROUP BY pe.product_id) as product_ext
                                            [24] => (SELECT GROUP_CONCAT(CONCAT(lang_id,'___',supplier_id,'___',url_value) SEPARATOR '---') FROM url u WHERE u.url_id = p.product_id AND u.url_type = 'product' AND u.supplier_id IS NOT NULL GROUP BY url_id) as urls
                                            [25] => (SELECT GROUP_CONCAT(CONCAT(collection_id,'___',supplier_id,'___',collection_label) SEPARATOR '---') FROM collection_product cp LEFT JOIN collection c USING(collection_id) WHERE cp.product_id = p.product_id GROUP BY p.product_id) as collections
                                        )

                                    [limit] => 
                                    [from] => Array
                                        (
                                            [0] => product p
                                            [1] => product_supplier ps
                                        )

                                    [where] => Array
                                        (
                                            [0] => ps.product_id = p.product_id
                                            [1] => supplier_id = '10'
                                            [2] => enabled = '1'
                                            [3] => p.product_deleted = 0
                                        )

                                    [group_by] => Array
                                        (
                                            [0] => p.product_id
                                        )

                                    [order_by] => Array
                                        (
                                            [0] => count_views DESC
                                        )

                                )

                            [1] => 1
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/erp/erp/disabiliabili/index.php
                    [line] => 167
                    [function] => get_products
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [where] => Array
                                        (
                                            [supplier_id] => 10
                                            [enabled] => 1
                                        )

                                    [order_by] => Array
                                        (
                                            [0] => count_views DESC
                                        )

                                )

                        )

                )

        )

    [previous:Exception:private] => 
)
€ 49,92 - € 4,99

€ 44,93

€ 70,61 - € 7,06

€ 63,55

€ 11,59 - € 1,16

€ 10,43

€ 183,78 - € 15,68

€ 168,10

€ 67,10 - € 6,71

€ 60,39

€ 0,45 - € 0,05

€ 0,40

€ 0,00 - € 0,00

€ 0,00

€ 0,00 - € 0,00

€ 0,00

€ 223,66 - € 22,36

€ 201,30

€ 425,78 - € 42,58

€ 383,20

€ 79,30 - € 7,93

€ 71,37

€ 110,64 - € 11,07

€ 99,57

HAI BISOGNO DI AIUTO?
ASSISTENZA ON LINE
NON PERDERTI LA PROSSIMA OFFERTA
CI TROVI ANCHE SU