CREATE DEFINER=CURRENT_USER PROCEDURE `SlciGetAllPartners`(IN i_limit VARCHAR(255))
BEGIN
			DECLARE d_podId INT;
            DECLARE d_imagepodId INT;
			SET d_podId = GETPODTYPEID('slci_partner');
            SET d_imagepodId = GETPODTYPEID('slci_partner_logo_slider');
			
            SELECT * 
            FROM inno_lci_2_pods_slci_partner p,
            (SELECT * 
            FROM inno_lci_2_podsrel
            WHERE pod_id = d_podId) pr,
            (SELECT *
            FROM inno_lci_2_posts
            ) img
            WHERE pr.item_id = p.id
            AND img.ID = pr.related_item_id
            AND pr.field_id = d_imagepodId;
        END