« Anterior 271 272 273 274 275 276 277 278 279 280 281 Siguiente »

SELECT productos1.*,rubrosorden.rubroso_orden as rubroso_orden, subrorden.subro_orden as subro_orden,SUBSTRING_INDEX(prd_imp_descripcion, ' ', 1) as prim FROM (productos1 inner join rubrosorden on productos1.prd_imp_codrubro=rubrosorden.prd_imp_codrubro) inner join subrorden on productos1.prd_imp_codsubrubro=subrorden.prd_imp_codsubrubro WHERE (prd_imp_descripcion LIKE '%%' OR prd_imp_obs LIKE '%%' OR prd_imp_codigo LIKE '%%') AND prd_imp_webtico='A' AND prd_imp_PrecioVentaMA3>0.01 AND 1=1 ORDER BY rubroso_orden, subro_orden,prim,prd_imp_I DESC,prd_imp_descripcion LIMIT 8250,30

Si no podés visualizar este video hacé click Aqui