Catálogo

SELECT * FROM productos WHERE ( cve_prod LIKE '%DGJOTM11%' OR sub_cse LIKE '%DGJOTM11%' OR sub_subcse LIKE '%DGJOTM11%' OR desc_cse LIKE '%DGJOTM11%' OR desc_prod LIKE '%DGJOTM11%' OR sku1 LIKE '%DGJOTM11%' OR sku2 LIKE '%DGJOTM11%' OR sku3 LIKE '%DGJOTM11%' OR sku4 LIKE '%DGJOTM11%' OR sku5 LIKE '%DGJOTM11%' OR sku6 LIKE '%DGJOTM11%' ) AND activo = 1 ORDER BY desc_prod LIMIT 0 , 15