Source Code for Me (s-c.me)

Code's Tags

- TSQL
Your Codes

None
Reffers

None
-------------------
Linked Codes

- 7045. using System; using System.Da
- 7044. // Adding the following attrib
- 5885. <?php $temp = $array[0]; ?>
- 5884. <?php $temp = $array[0]; ?>
- 5883. public static class Server
- 5775. asdfasdfsadf
- 5391. [StructLayout(LayoutKind.S
- 5377. body { height: 100%; backg
- 5107. /* Columns section */ #column
- 5106. /* Columns section */ #column

Code:

SELECT
	face_image,
	first_name,
	last_name,
	phone_number
FROM
	humanity
WHERE
	gender = 'woman' -- Под понятие идеальной девушки попадает только женский пол, я думаю…
 
	AND NOT married -- не замужем, не женатая
	AND (SELECT COUNT(*) FROM humanity WHERE mother_id = humanity.id) = 0 -- без детей
	AND social_status IN ('student', 'employee', 'business lady') -- не сидит впросидь дома
 
	AND weight / POW(height, 2) BETWEEN 17 AND 22 -- Индекс Массы Тела
	AND breast_size BETWEEN 2 AND 4 -- Рамер груди
 
	AND iq_index BETWEEN 95 AND 110 -- Не глупая, но и не перегибая палку
	AND (SELECT COUNT(DISTINCT word) FROM spoken_words WHERE human_id = humanity.id) > 6000 -- Есть, о чём поговорить
 
	AND cooking_level /*+ football_interesting*/ + computer_education > /*220*/ 180 -- Любые комбинации приветствуются
 
	AND (
		SELECT
			COUNT(*)
		FROM
			books
			JOIN bag_content ON bag_content.object_id = books.id AND bag_content.object_type = 'books'
			JOIN bag ON bag.id = bag_content.bag_id
		WHERE
			bag.owner_id = humanity.id
			AND books.author_last_name = 'Донцова'
	) = 0 -- Без комментариев
 
	AND NOT smoking -- !!!

Copy to clipboard (IE,FF)

As HTMLAs CSS Selected Language:
Show Linenumbers:

Short link for Twitter:

HTML:

<blockquote><code><a href="http://s-c.me/3536/s">Copy&nbsp;Source</a>&nbsp;|&nbsp;<a href="http://s-c.me/3536/h">Copy&nbsp;HTML</a><ol><li>SELECT</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;face_image,</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;first_name,</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;last_name,</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;phone_number</li>
<li>FROM</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;humanity</li>
<li>WHERE</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;gender = 'woman' --&nbsp;Под&nbsp;понятие&nbsp;идеальной&nbsp;девушки&nbsp;попадает&nbsp;только&nbsp;женский&nbsp;пол,&nbsp;я&nbsp;думаю…</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND NOT married --&nbsp;не&nbsp;замужем,&nbsp;не&nbsp;женатая</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND (SELECT COUNT(*) FROM humanity WHERE mother_id = humanity.id) = 0 --&nbsp;без&nbsp;детей</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND social_status IN ('student', 'employee', 'business&nbsp;lady') --&nbsp;не&nbsp;сидит&nbsp;впросидь&nbsp;дома</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND weight / POW(height, 2) BETWEEN 17 AND 22 --&nbsp;Индекс&nbsp;Массы&nbsp;Тела</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND breast_size BETWEEN 2 AND 4 --&nbsp;Рамер&nbsp;груди</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND iq_index BETWEEN 95 AND 110 --&nbsp;Не&nbsp;глупая,&nbsp;но&nbsp;и&nbsp;не&nbsp;перегибая&nbsp;палку</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND (SELECT COUNT(DISTINCT word) FROM spoken_words WHERE human_id = humanity.id) &gt; 6000 --&nbsp;Есть,&nbsp;о&nbsp;чём&nbsp;поговорить</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND cooking_level /*+ football_interesting*/ + computer_education &gt; /*220*/ 180 --&nbsp;Любые&nbsp;комбинации&nbsp;приветствуются</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND (</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNT(*)</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;books</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JOIN bag_content ON bag_content.object_id = books.id AND bag_content.object_type = 'books'</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JOIN bag ON bag.id = bag_content.bag_id</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bag.owner_id = humanity.id</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND books.author_last_name = 'Донцова'</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;) = 0 --&nbsp;Без&nbsp;комментариев</li>
<li>&nbsp;</li>
<li>&nbsp;&nbsp;&nbsp;&nbsp;AND NOT smoking --&nbsp;!!!&nbsp;</li>
</ol></code></blockquote>

Copy to clipboard (IE,FF)

HTML view:

Copy Source | Copy HTMLSELECT face_image, first_name, last_name, phone_number FROM humanity WHERE gender = 'woman' -- Под понятие идеальной девушки попадает только женский пол, я думаю… AND NOT married -- не замужем, не женатая AND (SELECT COUNT(*) FROM humanity WHERE mother_id = humanity.id) = 0 -- без детей AND social_status IN ('student', 'employee', 'business lady') -- не сидит впросидь дома AND weight / POW(height, 2) BETWEEN 17 AND 22 -- Индекс Массы Тела AND breast_size BETWEEN 2 AND 4 -- Рамер груди AND iq_index BETWEEN 95 AND 110 -- Не глупая, но и не перегибая палку AND (SELECT COUNT(DISTINCT word) FROM spoken_words WHERE human_id = humanity.id) > 6000 -- Есть, о чём поговорить AND cooking_level /*+ football_interesting*/ + computer_education > /*220*/ 180 -- Любые комбинации приветствуются AND ( SELECT COUNT(*) FROM books JOIN bag_content ON bag_content.object_id = books.id AND bag_content.object_type = 'books' JOIN bag ON bag.id = bag_content.bag_id WHERE bag.owner_id = humanity.id AND books.author_last_name = 'Донцова' ) = 0 -- Без комментариев AND NOT smoking -- !!!

Source Code for Me (s-c.me)

Code's Tags

Your Codes

Reffers

Linked Codes