SELECT * FROM productos WHERE (
cve_prod LIKE '%TIGUAN%' OR
sub_cse LIKE '%TIGUAN%' OR
sub_subcse LIKE '%TIGUAN%' OR
desc_cse LIKE '%TIGUAN%' OR
desc_prod LIKE '%TIGUAN%' OR
sku1 LIKE '%TIGUAN%' OR
sku2 LIKE '%TIGUAN%' OR
sku3 LIKE '%TIGUAN%' OR
sku4 LIKE '%TIGUAN%' OR
sku5 LIKE '%TIGUAN%' OR
sku6 LIKE '%TIGUAN%' ) AND activo = 1 ORDER BY desc_prod LIMIT 120 , 15
Imagen |
Clave |
Video |
Producto |
Precio con IVA |
Inventario |
Cantidad |