HELLA

HELLA
Mostra:
I codici evidenziati hanno alternativi.
#0 tep_db_query(SELECT l.text_desc, t.id_tipologia_cliente_web, t.text_visualizzazione , t.text_categories, t.text_manufacturers, t.text_famiglia, t.text_categoria_sconto, t.text_precodici, t.text_colonna, t.text_data_ini FROM products_text_tes t LEFT JOIN products_text_lang l ON (t.text_id = l.text_id AND l.language_id = 4) WHERE t.text_status = 1 AND '2025-02-05' BETWEEN t.text_data_ini AND t.text_data_fin AND IF(t.text_manufacturers != '', CONCAT(',', t.text_manufacturers, ',') REGEXP ',(502),',1) AND IF(t.text_precodici != '', CONCAT(',', t.text_precodici, ',') REGEXP ',(HEL),',1) AND IF(t.text_categories != '', CONCAT(',', t.text_categories, ',') REGEXP ',(24),',1) AND IF(t.text_famiglia != '', CONCAT(',', t.text_famiglia, ',') REGEXP ',(54),',1) AND IF(t.text_categoria_sconto != '', CONCAT(',', t.text_categoria_sconto, ',') REGEXP ',(+),',1) AND NOT EXISTS(select ptd.text_products_model from products_text_det ptd where ptd.text_id=t.text_id) AND if(id_tipologia_cliente_web<>'', if( tipologia_clienti_web_inclescl=1, CONCAT(',', id_tipologia_cliente_web, ',') NOT REGEXP ',(),', CONCAT(',', id_tipologia_cliente_web, ',') REGEXP ',(),' ), 1) ORDER BY t.text_data_ini DESC) called at [/u/www/boa/includes/functions/gestionale.php4:4700] #1 products_text(HEL8GA 002 071-121, 24, HEL, 502) called at [/u/www/boa/includes/modules/product_listing.php:1726] #2 include(/u/www/boa/includes/modules/product_listing.php) called at [/u/www/boa/default.php:1408]
2025-02-05 06:54:08 1139 - Got error 'repetition-operator operand invalid' from regexp

SELECT l.text_desc, t.id_tipologia_cliente_web, t.text_visualizzazione , t.text_categories, t.text_manufacturers, t.text_famiglia, t.text_categoria_sconto, t.text_precodici, t.text_colonna, t.text_data_ini FROM products_text_tes t LEFT JOIN products_text_lang l ON (t.text_id = l.text_id AND l.language_id = 4) WHERE t.text_status = 1 AND '2025-02-05' BETWEEN t.text_data_ini AND t.text_data_fin AND IF(t.text_manufacturers != '', CONCAT(',', t.text_manufacturers, ',') REGEXP ',(502),',1) AND IF(t.text_precodici != '', CONCAT(',', t.text_precodici, ',') REGEXP ',(HEL),',1) AND IF(t.text_categories != '', CONCAT(',', t.text_categories, ',') REGEXP ',(24),',1) AND IF(t.text_famiglia != '', CONCAT(',', t.text_famiglia, ',') REGEXP ',(54),',1) AND IF(t.text_categoria_sconto != '', CONCAT(',', t.text_categoria_sconto, ',') REGEXP ',(+),',1) AND NOT EXISTS(select ptd.text_products_model from products_text_det ptd where ptd.text_id=t.text_id) AND if(id_tipologia_cliente_web<>'', if( tipologia_clienti_web_inclescl=1, CONCAT(',', id_tipologia_cliente_web, ',') NOT REGEXP ',(),', CONCAT(',', id_tipologia_cliente_web, ',') REGEXP ',(),' ), 1) ORDER BY t.text_data_ini DESC

[TEP STOP]