Download
Webboard

FAQ/





MySQL.RU - Webboard




? (seyfer) 13/12/2011 - 07:39:28
      Re: ? (seyfer) 13/12/2011 - 09:08:11
      Re: ? (seyfer) 13/12/2011 - 10:51:24
      Re: ? (Akina) 13/12/2011 - 18:05:22
      Re: ? (seyfer) 14/12/2011 - 04:56:35
      Re: ? (seyfer) 15/12/2011 - 12:39:18

> Original message text:
> From: seyfer - 13/12/2011 - 07:39:28
> Subject: ?
> -----------------
> .
>
> 5000 20000 :
>
> --
> -- Table structure for table `debtors`
> --
>
> CREATE TABLE IF NOT EXISTS `debtors` (
> `users_id` int(11) NOT NULL DEFAULT '0',
> `full_name` varchar(255) NOT NULL,
> `actual_address` varchar(255) NOT NULL,
> `building` varchar(15) NOT NULL,
> `flat_number` varchar(15) NOT NULL,
> `work_telephone` varchar(100) NOT NULL,
> `home_telephone` varchar(100) NOT NULL,
> `mobile_telephone` varchar(100) NOT NULL,
> `balance` float NOT NULL DEFAULT '0',
> `credit` float NOT NULL DEFAULT '0',
> `services` varchar(255) NOT NULL,
> `tariff_name` varchar(120) NOT NULL DEFAULT ' ',
> `account_id` int(11) NOT NULL DEFAULT '0',
> `block_start_date` int(11) NOT NULL DEFAULT '0',
> `is_juridical` int(11) NOT NULL DEFAULT '0',
> KEY `users_id` (`users_id`),
> KEY `users_id__is_juridical` (`users_id`,`is_juridical`),
> KEY `is_juridical__block_start_date` (`is_juridical`,`block_start_date`)
> ) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
>
> -- --------------------------------------------------------
>
> --
> -- Table structure for table `rayon`
> --
>
> CREATE TABLE IF NOT EXISTS `rayon` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `street` varchar(255) NOT NULL,
> `area_id` int(5) NOT NULL,
> `house` varchar(100) NOT NULL,
> PRIMARY KEY (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21984 ;
>
> , , .
> area_id = 1 AND house = building
>
> - , / . , , , , , 77-22.
>
> - :
>
> SELECT debtors.*, FROM_UNIXTIME(block_start_date) AS date
> FROM debtors, rayon
> WHERE area_id = 1 AND house = building
> AND actual_address LIKE '%street%'
> ORDER BY date DESC
>
>
> street , 0 . , .
>
> php .
> ?
>


From: seyfer - 13/12/2011 - 10:51:24
Subject: ?
-----------------
. , , . - . , :


SELECT DISTINCT debtors.*, FROM_UNIXTIME(block_start_date) AS date FROM debtors, rayon, area WHERE area.id = 2 AND house = building AND area_id = area.id AND ( actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% 3-%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%60 %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '% . %' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' OR actual_address LIKE '%%' ) AND ( street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% 3-%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%60 %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '% . %' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' OR street LIKE '%%' ) ORDER BY date DESC LIMIT 0, 20


, . , .
Showing rows 0 - 19 (20 total, Query took 11.0257 sec).

?


[ - !]



MySQL.RU!
, , :
- - FAQ
-
-
, ( , MySQL, , , , .)
, , .
 :
 E-mail:
 :
 :
: Code
40825



  | |