>
> SELECT *,  prd_price  as prd_price,  CONCAT_WS(',', ed.del_price, ed.del_price_spb, ed.del_price_nn) as delivery,
> 	CASE 
>         WHEN prd_status = 1  THEN 1 
>         WHEN prd_status_post = 1  THEN 2 
> 	    ELSE 3
> 	END AS sort 
> FROM 
> 	categories ec, 
> 	products ep, 
> 	vendors ev,
>     delivery ed
> 
> WHERE
> 	ec.cat_path LIKE '002002%' AND 
>     ep.prd_deliv_id = ed.del_id AND
> 	ep.prd_cat_id=ec.cat_id AND 
> 	ep.prd_ven_id=ev.ven_id AND
> 	ep.prd_active > 0 AND 
> 	ec.cat_active > 0 AND
> 	ev.ven_active > 0 AND
> 	prd_price > 0
> 	
> 	
> 
> ORDER by
>     sort  ,sort, ep.prd_price
>  LIMIT 340,20
>