Consulta Basica

[TavoRossal]

<?php
$usuario =& JFactory::getUser();
$user= JFactory::getUser();
$id = $user->id;

defined('_JEXEC') or die( 'Restricted access' );
$db = &JFactory::getDBO();

$path = $PHP_SELF."?option=".$_GET["option"]."&view=".$_GET["view"]."&id=".$_GET["id"]."&Itemid=".$_GET["Itemid"];
$num = 0 ;
$pag = 1;
$dir = "" ;
$pri = 1 ;
$query = "select a.id as id from jos153_properties_lightbox a where a.uid = '".$id."'" ;
$db->setQuery($query);
$rows = $db->loadObjectList();

foreach($rows AS $row){
if($pri == 1){
$dir .="<a href = '".$path."&pag=".$row->id."'>".$pag."</a>&nbsp&nbsp" ;
$pag++;
$pri = 0;
}

if($num == 3){
$dir .="<a href = '".$path."&pag=".$row->id."'>".$pag."</a>&nbsp&nbsp" ;
$pag++;
$num = 0;
}
$num++;
}


$pp = $_GET["pag"];

$query = "select * from jos153_properties_lightbox a join jos153_properties_products b on a.propid = b.id where ";
if(isset($_GET["pag"])){
$query.="a.id >=".$_GET["pag"]. " and " ;
}
$query.="a.uid = '".$id."' limit 3" ;
$db->setQuery($query);
$rows = $db->loadObjectList();
?>
esta es mi consulta como vez tengo que me muestre 3 resultados por pagina asi de una vez hice la paginacion.
que opinas?