SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT * FROM `LogCompany` WHERE `company_id`='%d' AND `flag`='%d' OREDR BY `id` ASC LIMIT 0,100; |
| 1 | + | SELECT `lc`.*,`k`.`Nick` |
| 2 | FROM `LogCompany` `lc` | |
| 3 | LEFT JOIN `Konta` `k` ON `lc`.`user_id`=`k`.`id` | |
| 4 | WHERE `lc`.`company_id`='%d' AND `lc`.`flag`='%d' | |
| 5 | ORDER BY `lc`.`id` DESC | |
| 6 | LIMIT 0,100; |
