Bloga uzklausa.
		SELECT 
			g_v.prid AS 'Key',
			g_v.pgs_id AS 'GroupId',
			pg_s.pg_id_t AS 'ExtraGroupKey',
			substring(pg_s.poz_str,2,1) AS 'withProperties',
			IF ((pr_z_k.kalba_id = 1 OR pr_z.kalba_id = 1) AND (pr_z_k.pavad <>'' OR pr_z_k.pavad IS NOT NULL),
				pr_z_k.pavad, pr_z.pr_pavad) AS 'Name',
			goods_details.image As 'Image',
			goods_details.features As 'Text',
			gamintojas.g_pavad AS 'VendorName',					
			gamintojas.id AS 'VendorKey',
			
			g_v.gprice,
			g_v.iprice,
			g_v.gd1_price,
			g_v.gd2_price,
			g_v.gd3_price,
			g_v.pvm,
			g_v.g_kodas AS 'Code',
			UPPER(g_v.k_kodas) as k_kodas,
			g_v.descriptio AS 'ShortDescription',
			g_v.gvnt AS 'Unity',
			g_v.tipas,
			g_v.kompl_t
		FROM 
			pr_zodynas AS pr_z
		LEFT JOIN pr_zodynas_kalba AS pr_z_k ON
			(pr_z.pr_id = pr_z_k.pr_id AND pr_z_k.kalba_id = 1)
		INNER JOIN goods_v AS g_v ON
			g_v.pr_id=pr_z.pr_id AND g_v.del_date IS NULL
		INNER JOIN pg_seima AS pg_s ON
			g_v.pgs_id=pg_s.pgs_id AND  pg_s.del_date IS NULL
		LEFT JOIN goods_details ON
			(g_v.prid = goods_details.prid) AND goods_details.kalba_id = 1
		LEFT JOIN gamintojas ON
			(g_v.adrid_ga = gamintojas.id)
		WHERE 
			g_v.specpas = 1 AND (g_v.spec_iki >= NOW() AND g_v.spec_iki IS NOT NULL) AND g_v.pgs_id = 
		ORDER BY
			formatas,gamintojas.g_pavad, gprice,Name DESC