79 : SELECT p_id AS id, cat_id, title, spot, resim0 ,
(SELECT title FROM paket_cat WHERE lang = 'ru' AND status = '1' AND cat_id=p.cat_id) AS cat_title ,
(SELECT title FROM hospital WHERE lang = 'ru' AND status = '1' AND h_id = p.h_id) AS hastane_name
FROM paket p WHERE lang = 'ru' AND status = '1' ORDER BY title ASC