DELIMITER |
DROP PROCEDURE IF EXISTS DisplayPress;
CREATE PROCEDURE DisplayPress(IN TypePress NUMERIC(1,0))
BEGIN
    SELECT Pr.id_press, UNIX_TIMESTAMP(Pr.date_press) AS date_press, TP.desc_press, Pr.place, Pr.title, Pr.content, Q.desc_quality, P.nom, P.prenom, P.email
    FROM person AS P, quality AS Q, type_press AS TP, press AS Pr
    WHERE P.id_person = Pr.fk_id_author
    AND P.fk_id_quality = Q.id_quality
    AND TP.id_type_press = Pr.fk_id_type_press
    AND TP.id_type_press = TypePress
        AND Pr.state = 1
    ORDER BY Pr.date_press DESC;
END
|