CREATE TABLE IF NOT EXISTS offers (
  id int(11) NOT NULL AUTO_INCREMENT,
  user_id int(11) DEFAULT NULL,
  service_request_id int(11) DEFAULT NULL,
  accepted tinyint(1) DEFAULT '0',
  created_at datetime DEFAULT NULL,
  updated_at datetime DEFAULT NULL,
  PRIMARY KEY (id),
  KEY index_offers_on_service_request_id (service_request_id) USING BTREE,
  KEY index_offers_on_user_id (user_id) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1259 ;

BEGIN
  INSERT INTO relationships (created_at, followed_id, follower_id, updated_at) VALUES ('2015-12-10 05:47:01', 2, 1, '2015-12-10 05:47:01')
COMMIT

UPDATE users SET name = 'Super Admin', updated_at = '2015-12-10 05:53:12' WHERE users.id = 1

  DELETE FROM relationships WHERE relationships.id = 89

SELECT  service_requests.* FROM service_requests 
  INNER JOIN services 
  ON services.service_request_id = service_requests.id 
  WHERE (LOWER(title) like '%test%' ) 
  GROUP BY service_requests.id  
  ORDER BY created_at DESC 
  LIMIT 5 
  OFFSET 0

SELECT service_requests.* 
  FROM service_requests 
  INNER JOIN services 
  ON services.service_request_id = service_requests.id 
  INNER JOIN services_tags 
  ON services_tags.service_id = services.id 
  INNER JOIN tags ON tags.id = services_tags.tag_id 
  WHERE tags.id 
  IN (1, 2) 
  GROUP BY service_requests.id 
  ORDER BY created_at DESC 
  LIMIT 5 
  OFFSET 0

  SELECT COUNT(*) FROM users 
  INNER JOIN relationships 
  ON users.id = relationships.follower_id 
  WHERE relationships.followed_id = 2

DROP function IF EXISTS humanize_arrangement_status;
DELIMITER //
CREATE FUNCTION humanize_arrangement_status(status TINYINT)
  returns varchar(20)
  BEGIN
    DECLARE human_status varchar(20);
    if status = 0 then
      set human_status= "Incompleto";
    else
      set human_status="Completado";
    end if;

    return(human_status);
  end;
//
DELIMITER ;

SELECT  humanize_arrangement_status(completed) AS status 
    FROM service_arrangements 
    WHERE service_arrangements.id = 15 
    LIMIT 1;

CREATE OR REPLACE VIEW latest_requests AS
  SELECT  service_requests.* 
  FROM service_requests 
  ORDER BY created_at DESC LIMIT 3;

SELECT * FROM latest_requests;