Revision: 19420
Updated Code
at October 23, 2009 08:12 by pavel_voronin
Updated 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 -- !!!
Revision: 19419
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 23, 2009 08:09 by pavel_voronin
Initial 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 != 'Донцова' ) -- Без комментариев AND NOT smoking -- !!!
Initial URL
Initial Description
Initial Title
ПоиÑк идеальной девушки
Initial Tags
Initial Language
MySQL