Create a new bin
Language:
SQL/MySQL     Change language:
Pastebin: 70579
Author: Kynlem
Subject: Untitled
Created: 2007-07-09 22:17:00
Download and save
Toggle line numbers
1SELECT `Visit`.`id`, `Block`.`start_ip`, `Block`.`end_ip`, `Block`.`location_id` 
2  FROM `blocks` AS `Block` 
3    INNER JOIN `visits` AS `Visit` 
4      ON (`Visit`.`ip` BETWEEN `Block`.`start_ip` AND `Block`.`end_ip`) 
5  WHERE `Visit`.`user_id` = 5 AND `Visit`.`vtime` > 1184033067 
Thread:
[70579] Untitled by Kynlem at 2007-07-09 22:17:00
  [70580] Re: Untitled by Kynlem at 2007-07-09 22:21:44 (diff)
    [82474] ayxmjqwb zcfdlmy by xhcfe sencjapgh at 2008-02-17 06:45:34 (diff)
Tip: Click the line numbers to toggle highliting on that line.

Paste followup:

Language:
Author:
Subject:


    Tabstop:     bigger biggest
Note: You can prefix a line with "@@@" to highlight it.