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