#!/usr/bin/php -q
<?
	$mysqli = mysqli_connect("127.0.0.1", "translingo", "translingo", "translingo");

	$query = "select * from `translations` order by `id`";
	$res = mysqli_query($mysqli, $query);
	while($row = mysqli_fetch_assoc($res))
	{
		$query = "select * from `base` where `id`='".$row['baseid']."' and `pid`='".$row['pid']."'";
		$dres = mysqli_query($mysqli, $query);
		if(mysqli_num_rows($dres) <= 0)
		{
			$query = "delete from `translations` where `id`='".$row['id']."'";
echo $query."\n";
			mysqli_query($mysqli, $query);
		}
	}
?>