-- MySQL dump 10.11
--
-- Host: localhost    Database: prunti-24oct08-3
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `friendship`
--

DROP TABLE IF EXISTS `friendship`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `friendship` (
  `id` int(11) NOT NULL default '0',
  `befriender_id` int(11) default NULL,
  `friend_id` int(11) default NULL,
  `status` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `friend_facebook_uid` varchar(255) collate utf8_unicode_ci default NULL,
  `title_request_id` int(11) default NULL,
  KEY `friendship_FI_2` (`friend_id`),
  KEY `friendship_befriender_id` (`befriender_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `friendship`
--

LOCK TABLES `friendship` WRITE;
/*!40000 ALTER TABLE `friendship` DISABLE KEYS */;
INSERT INTO `friendship` VALUES (66,11,62,2,NULL,NULL,NULL,NULL),(304,62,65,2,NULL,NULL,NULL,NULL),(327,32,62,1,NULL,NULL,NULL,NULL),(401,259,62,1,NULL,NULL,NULL,NULL),(453,62,289,1,NULL,NULL,NULL,NULL),(666,62,441,2,NULL,NULL,NULL,NULL),(733,463,62,1,NULL,NULL,NULL,NULL),(812,62,479,1,NULL,NULL,NULL,NULL),(891,11,508,2,NULL,NULL,NULL,NULL),(1068,508,65,2,NULL,NULL,NULL,NULL),(1069,508,32,2,NULL,NULL,NULL,NULL),(1070,508,259,2,NULL,NULL,NULL,NULL),(1071,508,463,2,NULL,NULL,NULL,NULL),(1072,508,506,2,NULL,NULL,NULL,NULL),(1073,508,1,2,NULL,NULL,NULL,NULL),(1074,508,50,2,NULL,NULL,NULL,NULL),(1223,62,615,1,NULL,NULL,NULL,NULL),(1240,11,619,2,NULL,NULL,NULL,NULL),(1262,619,32,2,NULL,NULL,NULL,NULL),(1263,619,65,2,NULL,NULL,NULL,NULL),(1264,619,259,2,NULL,NULL,NULL,NULL),(1265,619,506,2,NULL,NULL,NULL,NULL),(1266,619,1,2,NULL,NULL,NULL,NULL),(1267,619,50,2,NULL,NULL,NULL,NULL),(20,9,11,2,NULL,NULL,NULL,NULL),(21,11,21,2,NULL,NULL,NULL,NULL),(27,11,25,1,NULL,NULL,NULL,NULL),(28,11,29,2,NULL,NULL,NULL,NULL),(31,11,31,2,NULL,NULL,NULL,NULL),(33,11,33,2,NULL,NULL,NULL,NULL),(41,11,38,2,NULL,NULL,NULL,NULL),(42,11,39,2,NULL,NULL,NULL,NULL),(43,11,40,2,NULL,NULL,NULL,NULL),(44,11,41,2,NULL,NULL,NULL,NULL),(47,11,43,2,NULL,NULL,NULL,NULL),(48,11,44,2,NULL,NULL,NULL,NULL),(49,11,45,2,NULL,NULL,NULL,NULL),(50,11,46,2,NULL,NULL,NULL,NULL),(51,11,47,2,NULL,NULL,NULL,NULL),(52,11,48,2,NULL,NULL,NULL,NULL),(53,11,49,2,NULL,NULL,NULL,NULL),(64,11,60,2,NULL,NULL,NULL,NULL),(65,11,61,2,NULL,NULL,NULL,NULL),(66,11,62,2,NULL,NULL,NULL,NULL),(67,11,63,2,NULL,NULL,NULL,NULL),(70,11,65,2,NULL,NULL,NULL,NULL),(126,81,11,2,NULL,NULL,NULL,NULL),(128,11,106,2,NULL,NULL,NULL,NULL),(129,11,107,2,NULL,NULL,NULL,NULL),(130,11,108,2,NULL,NULL,NULL,NULL),(131,11,109,1,NULL,NULL,NULL,NULL),(132,11,110,2,NULL,NULL,NULL,NULL),(133,11,111,2,NULL,NULL,NULL,NULL),(134,11,112,2,NULL,NULL,NULL,NULL),(135,11,113,1,NULL,NULL,NULL,NULL),(136,11,114,1,NULL,NULL,NULL,NULL),(137,11,115,1,NULL,NULL,NULL,NULL),(138,11,116,1,NULL,NULL,NULL,NULL),(139,11,117,1,NULL,NULL,NULL,NULL),(140,11,118,2,NULL,NULL,NULL,NULL),(141,11,119,2,NULL,NULL,NULL,NULL),(142,11,120,1,NULL,NULL,NULL,NULL),(143,11,121,1,NULL,NULL,NULL,NULL),(144,11,122,1,NULL,NULL,NULL,NULL),(145,11,123,2,NULL,NULL,NULL,NULL),(146,11,124,1,NULL,NULL,NULL,NULL),(147,11,125,1,NULL,NULL,NULL,NULL),(148,11,126,1,NULL,NULL,NULL,NULL),(149,11,127,1,NULL,NULL,NULL,NULL),(150,11,128,2,NULL,NULL,NULL,NULL),(151,11,129,1,NULL,NULL,NULL,NULL),(152,11,130,1,NULL,NULL,NULL,NULL),(153,11,131,1,NULL,NULL,NULL,NULL),(154,11,132,1,NULL,NULL,NULL,NULL),(155,11,133,2,NULL,NULL,NULL,NULL),(156,11,134,2,NULL,NULL,NULL,NULL),(157,11,135,2,NULL,NULL,NULL,NULL),(158,11,136,1,NULL,NULL,NULL,NULL),(159,11,137,2,NULL,NULL,NULL,NULL),(160,11,138,1,NULL,NULL,NULL,NULL),(161,11,139,2,NULL,NULL,NULL,NULL),(162,11,140,1,NULL,NULL,NULL,NULL),(163,11,141,1,NULL,NULL,NULL,NULL),(164,11,142,1,NULL,NULL,NULL,NULL),(165,11,143,1,NULL,NULL,NULL,NULL),(166,11,144,1,NULL,NULL,NULL,NULL),(167,11,145,1,NULL,NULL,NULL,NULL),(168,11,146,1,NULL,NULL,NULL,NULL),(170,11,147,2,NULL,NULL,NULL,NULL),(171,11,148,2,NULL,NULL,NULL,NULL),(173,11,150,2,NULL,NULL,NULL,NULL),(174,11,151,1,NULL,NULL,NULL,NULL),(175,11,152,1,NULL,NULL,NULL,NULL),(176,11,153,1,NULL,NULL,NULL,NULL),(178,11,155,1,NULL,NULL,NULL,NULL),(179,11,156,2,NULL,NULL,NULL,NULL),(180,11,157,2,NULL,NULL,NULL,NULL),(181,11,158,2,NULL,NULL,NULL,NULL),(182,11,159,2,NULL,NULL,NULL,NULL),(183,11,160,2,NULL,NULL,NULL,NULL),(184,11,161,1,NULL,NULL,NULL,NULL),(185,11,162,2,NULL,NULL,NULL,NULL),(186,11,163,1,NULL,NULL,NULL,NULL),(187,11,164,2,NULL,NULL,NULL,NULL),(188,11,165,1,NULL,NULL,NULL,NULL),(189,11,166,1,NULL,NULL,NULL,NULL),(190,11,167,1,NULL,NULL,NULL,NULL),(191,11,168,1,NULL,NULL,NULL,NULL),(192,11,169,2,NULL,NULL,NULL,NULL),(193,11,55,2,NULL,NULL,NULL,NULL),(195,11,170,1,NULL,NULL,NULL,NULL),(196,11,171,2,NULL,NULL,NULL,NULL),(197,11,172,2,NULL,NULL,NULL,NULL),(198,11,173,2,NULL,NULL,NULL,NULL),(199,11,174,2,NULL,NULL,NULL,NULL),(249,11,223,2,NULL,NULL,NULL,NULL),(273,11,242,1,NULL,NULL,NULL,NULL),(274,11,243,2,NULL,NULL,NULL,NULL),(275,11,244,1,NULL,NULL,NULL,NULL),(276,11,245,1,NULL,NULL,NULL,NULL),(283,11,249,2,NULL,NULL,NULL,NULL),(309,11,258,1,NULL,NULL,NULL,NULL),(310,11,32,2,NULL,NULL,NULL,NULL),(311,11,259,2,NULL,NULL,NULL,NULL),(312,11,260,1,NULL,NULL,NULL,NULL),(335,179,11,2,NULL,NULL,NULL,NULL),(366,1,11,2,NULL,NULL,NULL,NULL),(367,11,268,1,NULL,NULL,NULL,NULL),(371,11,2,1,NULL,NULL,NULL,NULL),(377,11,239,2,NULL,NULL,NULL,NULL),(383,11,277,2,NULL,NULL,NULL,NULL),(384,11,278,2,NULL,NULL,NULL,NULL),(385,11,279,1,NULL,NULL,NULL,NULL),(386,272,11,2,NULL,NULL,NULL,NULL),(431,273,11,2,NULL,NULL,NULL,NULL),(436,274,11,2,NULL,NULL,NULL,NULL),(451,175,11,2,NULL,NULL,NULL,NULL),(452,269,11,2,NULL,NULL,NULL,NULL),(457,11,290,2,NULL,NULL,NULL,NULL),(460,11,293,2,NULL,NULL,NULL,NULL),(461,11,294,2,NULL,NULL,NULL,NULL),(477,11,304,2,NULL,NULL,NULL,NULL),(478,11,305,1,NULL,NULL,NULL,NULL),(479,11,306,1,NULL,NULL,NULL,NULL),(480,11,307,1,NULL,NULL,NULL,NULL),(481,11,308,1,NULL,NULL,NULL,NULL),(482,11,309,1,NULL,NULL,NULL,NULL),(483,11,250,1,NULL,NULL,NULL,NULL),(484,11,310,1,NULL,NULL,NULL,NULL),(485,11,311,2,NULL,NULL,NULL,NULL),(486,11,312,1,NULL,NULL,NULL,NULL),(487,11,313,1,NULL,NULL,NULL,NULL),(488,11,314,1,NULL,NULL,NULL,NULL),(489,11,315,1,NULL,NULL,NULL,NULL),(490,11,316,1,NULL,NULL,NULL,NULL),(491,11,317,1,NULL,NULL,NULL,NULL),(492,11,318,1,NULL,NULL,NULL,NULL),(493,11,319,1,NULL,NULL,NULL,NULL),(494,11,191,2,NULL,NULL,NULL,NULL),(495,11,320,1,NULL,NULL,NULL,NULL),(496,11,321,1,NULL,NULL,NULL,NULL),(497,11,87,1,NULL,NULL,NULL,NULL),(498,11,322,1,NULL,NULL,NULL,NULL),(499,11,323,1,NULL,NULL,NULL,NULL),(500,11,324,1,NULL,NULL,NULL,NULL),(501,11,325,1,NULL,NULL,NULL,NULL),(502,11,326,1,NULL,NULL,NULL,NULL),(503,11,327,1,NULL,NULL,NULL,NULL),(504,11,328,1,NULL,NULL,NULL,NULL),(505,11,329,2,NULL,NULL,NULL,NULL),(506,11,330,1,NULL,NULL,NULL,NULL),(507,11,331,1,NULL,NULL,NULL,NULL),(508,11,332,1,NULL,NULL,NULL,NULL),(509,11,333,1,NULL,NULL,NULL,NULL),(510,11,334,1,NULL,NULL,NULL,NULL),(511,11,335,2,NULL,NULL,NULL,NULL),(512,11,336,1,NULL,NULL,NULL,NULL),(513,11,337,2,NULL,NULL,NULL,NULL),(514,11,338,1,NULL,NULL,NULL,NULL),(515,11,339,1,NULL,NULL,NULL,NULL),(516,11,340,1,NULL,NULL,NULL,NULL),(517,11,341,2,NULL,NULL,NULL,NULL),(518,11,342,1,NULL,NULL,NULL,NULL),(519,11,343,1,NULL,NULL,NULL,NULL),(520,11,344,1,NULL,NULL,NULL,NULL),(521,11,345,1,NULL,NULL,NULL,NULL),(522,11,346,1,NULL,NULL,NULL,NULL),(523,11,347,1,NULL,NULL,NULL,NULL),(524,11,348,1,NULL,NULL,NULL,NULL),(525,11,349,1,NULL,NULL,NULL,NULL),(526,11,350,1,NULL,NULL,NULL,NULL),(527,11,351,1,NULL,NULL,NULL,NULL),(528,11,352,1,NULL,NULL,NULL,NULL),(529,11,187,1,NULL,NULL,NULL,NULL),(530,11,353,1,NULL,NULL,NULL,NULL),(531,11,193,1,NULL,NULL,NULL,NULL),(532,11,264,1,NULL,NULL,NULL,NULL),(534,11,355,1,NULL,NULL,NULL,NULL),(535,11,356,1,NULL,NULL,NULL,NULL),(536,11,357,2,NULL,NULL,NULL,NULL),(537,11,358,1,NULL,NULL,NULL,NULL),(538,11,359,1,NULL,NULL,NULL,NULL),(539,11,200,1,NULL,NULL,NULL,NULL),(540,11,360,1,NULL,NULL,NULL,NULL),(541,11,361,1,NULL,NULL,NULL,NULL),(542,11,362,1,NULL,NULL,NULL,NULL),(543,11,363,1,NULL,NULL,NULL,NULL),(544,11,364,1,NULL,NULL,NULL,NULL),(545,11,365,1,NULL,NULL,NULL,NULL),(546,11,366,1,NULL,NULL,NULL,NULL),(547,11,367,1,NULL,NULL,NULL,NULL),(548,11,368,1,NULL,NULL,NULL,NULL),(549,11,369,1,NULL,NULL,NULL,NULL),(550,11,370,1,NULL,NULL,NULL,NULL),(551,11,371,1,NULL,NULL,NULL,NULL),(552,11,372,1,NULL,NULL,NULL,NULL),(553,11,373,1,NULL,NULL,NULL,NULL),(554,11,374,1,NULL,NULL,NULL,NULL),(555,11,375,2,NULL,NULL,NULL,NULL),(556,11,376,1,NULL,NULL,NULL,NULL),(557,11,377,1,NULL,NULL,NULL,NULL),(558,11,378,1,NULL,NULL,NULL,NULL),(559,11,379,1,NULL,NULL,NULL,NULL),(560,11,380,1,NULL,NULL,NULL,NULL),(561,11,381,1,NULL,NULL,NULL,NULL),(562,11,382,1,NULL,NULL,NULL,NULL),(563,11,383,1,NULL,NULL,NULL,NULL),(564,11,384,1,NULL,NULL,NULL,NULL),(565,11,385,1,NULL,NULL,NULL,NULL),(566,11,386,1,NULL,NULL,NULL,NULL),(567,11,387,1,NULL,NULL,NULL,NULL),(568,11,388,1,NULL,NULL,NULL,NULL),(569,11,389,2,NULL,NULL,NULL,NULL),(570,11,390,2,NULL,NULL,NULL,NULL),(571,11,391,1,NULL,NULL,NULL,NULL),(572,11,392,1,NULL,NULL,NULL,NULL),(573,11,393,1,NULL,NULL,NULL,NULL),(574,11,394,2,NULL,NULL,NULL,NULL),(575,11,395,1,NULL,NULL,NULL,NULL),(576,11,396,1,NULL,NULL,NULL,NULL),(577,11,397,1,NULL,NULL,NULL,NULL),(578,11,398,1,NULL,NULL,NULL,NULL),(579,11,399,2,NULL,NULL,NULL,NULL),(582,11,402,2,NULL,NULL,NULL,NULL),(583,11,403,1,NULL,NULL,NULL,NULL),(632,11,426,2,NULL,NULL,NULL,NULL),(641,424,11,2,NULL,NULL,NULL,NULL),(664,11,439,1,NULL,NULL,NULL,NULL),(665,11,440,1,NULL,NULL,NULL,NULL),(685,11,241,1,NULL,NULL,NULL,NULL),(688,11,458,1,NULL,NULL,NULL,NULL),(689,11,459,1,NULL,NULL,NULL,NULL),(695,78,11,2,NULL,NULL,NULL,NULL),(708,11,18,1,NULL,NULL,NULL,NULL),(787,466,11,2,NULL,NULL,NULL,NULL),(792,11,471,1,NULL,NULL,NULL,NULL),(794,472,11,2,NULL,NULL,NULL,NULL),(819,11,481,2,NULL,NULL,NULL,NULL),(832,464,11,2,NULL,NULL,NULL,NULL),(834,11,484,1,NULL,NULL,NULL,NULL),(845,11,487,1,NULL,NULL,NULL,NULL),(846,11,478,2,NULL,NULL,NULL,NULL),(847,11,488,2,NULL,NULL,NULL,NULL),(848,456,11,2,NULL,NULL,NULL,NULL),(855,11,490,2,NULL,NULL,NULL,NULL),(877,11,502,1,NULL,NULL,NULL,NULL),(887,11,506,2,NULL,NULL,NULL,NULL),(890,11,507,2,NULL,NULL,NULL,NULL),(891,11,508,2,NULL,NULL,NULL,NULL),(892,11,509,1,NULL,NULL,NULL,NULL),(893,11,510,1,NULL,NULL,NULL,NULL),(908,11,525,1,NULL,NULL,NULL,NULL),(909,11,526,1,NULL,NULL,NULL,NULL),(910,11,527,2,NULL,NULL,NULL,NULL),(911,11,528,1,NULL,NULL,NULL,NULL),(913,516,11,2,NULL,NULL,NULL,NULL),(915,11,531,2,NULL,NULL,NULL,NULL),(916,11,532,2,NULL,NULL,NULL,NULL),(917,11,486,2,NULL,NULL,NULL,NULL),(918,11,533,1,NULL,NULL,NULL,NULL),(919,11,534,2,NULL,NULL,NULL,NULL),(920,50,11,2,NULL,NULL,NULL,NULL),(935,11,535,1,NULL,NULL,NULL,NULL),(937,11,537,1,NULL,NULL,NULL,NULL),(949,11,542,2,NULL,NULL,NULL,NULL),(957,11,543,2,NULL,NULL,NULL,NULL),(979,513,11,2,NULL,NULL,NULL,NULL),(980,11,544,1,NULL,NULL,NULL,NULL),(981,11,545,1,NULL,NULL,NULL,NULL),(982,11,546,2,NULL,NULL,NULL,NULL),(998,76,11,2,NULL,NULL,NULL,NULL),(1014,11,555,2,NULL,NULL,NULL,NULL),(1051,425,11,2,NULL,NULL,NULL,NULL),(1052,514,11,2,NULL,NULL,NULL,NULL),(1055,11,564,2,NULL,NULL,NULL,NULL),(1063,511,11,2,NULL,NULL,NULL,NULL),(1083,23,11,2,NULL,NULL,NULL,NULL),(1085,11,570,1,NULL,NULL,NULL,NULL),(1087,538,11,2,NULL,NULL,NULL,NULL),(1107,580,11,2,NULL,NULL,NULL,NULL),(1110,11,583,1,NULL,NULL,NULL,NULL),(1115,586,11,2,NULL,NULL,NULL,NULL),(1117,587,11,2,NULL,NULL,NULL,NULL),(1125,11,594,1,NULL,NULL,NULL,NULL),(1126,11,595,2,NULL,NULL,NULL,NULL),(1127,11,596,1,NULL,NULL,NULL,NULL),(1129,11,598,2,NULL,NULL,NULL,NULL),(1142,11,194,1,NULL,NULL,NULL,NULL),(1155,11,599,2,NULL,NULL,NULL,NULL),(1162,601,11,2,NULL,NULL,NULL,NULL),(1164,11,443,2,NULL,NULL,NULL,NULL),(1165,11,224,2,NULL,NULL,NULL,NULL),(1166,11,54,1,NULL,NULL,NULL,NULL),(1167,11,100,1,NULL,NULL,NULL,NULL),(1177,11,467,2,NULL,NULL,NULL,NULL),(1186,11,605,1,NULL,NULL,NULL,NULL),(1187,11,606,1,NULL,NULL,NULL,NULL),(1188,11,607,2,NULL,NULL,NULL,NULL),(1189,11,295,1,NULL,NULL,NULL,NULL),(1190,11,562,1,NULL,NULL,NULL,NULL),(1191,11,563,1,NULL,NULL,NULL,NULL),(1192,11,608,2,NULL,NULL,NULL,NULL),(1193,11,609,1,NULL,NULL,NULL,NULL),(1195,11,611,2,NULL,NULL,NULL,NULL),(1196,11,612,2,NULL,NULL,NULL,NULL),(1197,11,613,2,NULL,NULL,NULL,NULL),(1224,11,616,2,NULL,NULL,NULL,NULL),(1240,11,619,2,NULL,NULL,NULL,NULL),(1268,176,11,2,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `friendship` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


CREATE TABLE `friendship_shortest_path` (
  `id` int(11) NOT NULL auto_increment,
  `from_id` int(11) default NULL,
  `to_id` int(11) default NULL,
  `distance` int(11) default NULL,
  `path` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `friendship_shortest_path_uq` (`from_id`,`to_id`),
  KEY `friendship_shortest_path_to_id` (`to_id`),
  KEY `friendship_shortest_path_distance` (`distance`),
  KEY `friendship_shortest_path_path` (`path`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO friendship_shortest_path (from_id, to_id, distance, path) SELECT distinct friend_id, befriender_id, 1, concat('-', friend_id, '-', befriender_id, '-') FROM friendship WHERE friend_id<>befriender_id and friendship.status=2;
INSERT INTO friendship_shortest_path (from_id, to_id, distance, path) SELECT distinct befriender_id, friend_id, 1, concat('-', befriender_id, '-', friend_id, '-') FROM friendship WHERE friend_id<>befriender_id and friendship.status=2;
INSERT INTO friendship_shortest_path (from_id, to_id, distance, path) SELECT f1.from_id, f2.to_id, 2, concat('-', f1.from_id, '-', f2.from_id, '-', f2.to_id, '-') FROM  friendship_shortest_path f1, friendship_shortest_path f2 WHERE  f1.to_id = f2.from_id AND f1.distance = 1 and f2.distance = 1 AND  NOT EXISTS (   SELECT * from friendship_shortest_path f3 where f3.from_id = f1.from_id and f3.to_id = f2.to_id) AND f1.from_id <> f2.to_id GROUP BY f1.from_id, f2.to_id;

select id,from_id,to_id,distance,path from friendship_shortest_path p where not exists (select * from friendship f0, friendship f1 where (f0.status in (2) AND f1.status in (2)) and ( (p.from_id = f0.befriender_id AND f0.friend_id = f1.befriender_id AND f1.friend_id = p.to_id) OR (p.from_id = f0.befriender_id AND f0.friend_id = f1.friend_id AND f1.befriender_id = p.to_id) OR (p.from_id = f0.friend_id AND f0.befriender_id = f1.befriender_id AND f1.friend_id = p.to_id) OR (p.from_id = f0.friend_id AND f0.befriender_id = f1.friend_id AND f1.befriender_id = p.to_id))) and p.distance=2;

/* gets 1474 rows, but expect none */

alter table friendship drop index friendship_befriender_id;

/* CORRECTLY gets Empty set */