SELECT i.* FROM xps_karate__webphoto_item i  INNER JOIN xps_karate__webphoto_cat c  ON i.item_cat_id = c.cat_id  WHERE  i.item_status &gt; 0  AND  ( i.item_perm_read=&#039;*&#039; OR i.item_perm_read LIKE &#039;%&amp;3&amp;%&#039; )  AND  ( c.cat_perm_read=&#039;*&#039; OR c.cat_perm_read LIKE &#039;%&amp;3&amp;%&#039; )  ORDER BY i.item_time_update DESC, i.item_id DESC: limit=100 :offset=0<br />
SELECT i.* FROM xps_karate__webphoto_item i  INNER JOIN xps_karate__webphoto_cat c  ON i.item_cat_id = c.cat_id  WHERE  i.item_status &gt; 0  AND  ( i.item_perm_read=&#039;*&#039; OR i.item_perm_read LIKE &#039;%&amp;3&amp;%&#039; )  AND  ( c.cat_perm_read=&#039;*&#039; OR c.cat_perm_read LIKE &#039;%&amp;3&amp;%&#039; )  ORDER BY i.item_time_update DESC, i.item_id DESC: limit=100 :offset=0<br />