All pastes #100078 Raw Edit

Phazorx

public sql v1 · immutable
#100078 ·published 2006-07-25 21:00 UTC
rendered paste body
mysql> SELECT p2.DbId, p2.happiness, p2.user_DbId  FROM `pet` AS p1 JOIN pet AS p2 ON ( p1.user_DbId = p2.user_DbId )  WHERE p2.user_DbId =142;+------+-----------+-----------+| DbId | happiness | user_DbId |+------+-----------+-----------+|  482 |         0 |       142 ||  484 |         0 |       142 ||  482 |         0 |       142 ||  484 |         0 |       142 |+------+-----------+-----------+4 rows in set (0.00 sec)