Uno Motos | Accesorios


IMG-LOGO

Warning: preg_replace(): No ending delimiter ';' found in /usr/local/sites/zanella/accesorios/includes/db.class.php on line 126

Empresa : _Main_Empresa_
Fecha : 15/07/2024 07:51:44
Error en: /?q=BUSQUEDA&valor_busqueda=&s_categorias=9,2p_categoria=-1&s_marcas=-1&s_color=-1&s_talles=18
Pais :
Servidor: 67.205.166.5

Descripcion Error: 1054: Unknown column '2p_categoria' in 'where clause'

Query:
SELECT p.id as id_producto, count(fecha_llegada) as cant_stock, m.denominacion as id_marca_txt, p.descripcion, acp.id, p.precio_efectivo,t.denominacion as nombre_talle,IF(co.denominacion is NOT NULL, co.denominacion,co2.denominacion) as nombre_color,s.id_moneda FROM acc_stock s LEFT JOIN acc_producto p on p.id = s.id_producto LEFT JOIN acc_categoria c on c.id = p.id_acc_categoria LEFT JOIN acc_marca m on m.id = p.id_acc_marca LEFT JOIN acc_talle t on t.id = s.id_acc_talle LEFT JOIN acc_color co on co.id = s.id_acc_color LEFT JOIN acc_color co2 on co2.id = s.id_acc_color2 LEFT JOIN acc_zona az on az.id = s.id_zona_acc LEFT JOIN acc_categoria_principal acp on acp.id = c.id_acc_categoria_principal WHERE s.id_acc_estado IN (1) and az.id_sucursal=1 and m.id NOT IN (115,164,113,121,82,67,148,119,63,96,112,108,120,135,70,165) AND p.id_acc_categoria IN (9,2p_categoria=-1) AND s.id_acc_talle= 18 and p.es_repuesto != 1 GROUP BY s.id_producto order by p.precio_efectivo DESC LIMIT 2000

Query completo:
SELECT p.id as id_producto, count(fecha_llegada) as cant_stock, m.denominacion as id_marca_txt, p.descripcion, acp.id, p.precio_efectivo,t.denominacion as nombre_talle,IF(co.denominacion is NOT NULL, co.denominacion,co2.denominacion) as nombre_color,s.id_moneda FROM acc_stock s LEFT JOIN acc_producto p on p.id = s.id_producto LEFT JOIN acc_categoria c on c.id = p.id_acc_categoria LEFT JOIN acc_marca m on m.id = p.id_acc_marca LEFT JOIN acc_talle t on t.id = s.id_acc_talle LEFT JOIN acc_color co on co.id = s.id_acc_color LEFT JOIN acc_color co2 on co2.id = s.id_acc_color2 LEFT JOIN acc_zona az on az.id = s.id_zona_acc LEFT JOIN acc_categoria_principal acp on acp.id = c.id_acc_categoria_principal WHERE s.id_acc_estado IN (1) and az.id_sucursal=1 and m.id NOT IN (115,164,113,121,82,67,148,119,63,96,112,108,120,135,70,165) AND p.id_acc_categoria IN (9,2p_categoria=-1) AND s.id_acc_talle= 18 and p.es_repuesto != 1 GROUP BY s.id_producto order by p.precio_efectivo DESC LIMIT 2000

Referer:

Session:
WhatsApp