mysql> select * from user limit 25; +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ | user_id | device_name | sec_answer | sec_question | age_range | gender | home_page_item | email_address | user_account | password | username | +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ | 3445 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 2K04GY6181ALC39HWXPV | NULL | NULL | | 3519 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | SOLAWZ4SPSZPVK0BRB9N | NULL | NULL | | 3809 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | ETV8ZCII8OJSF8XQ9XIG | NULL | NULL | | 2963 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | L7M36WAWS1C49HRFSCJQ | NULL | NULL | | 3035 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | DGRDSJXMEOH8SBIXH7PA | NULL | NULL | | 3066 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | GVFBV50PRCCT5WRQ6J9O | NULL | NULL | | 3088 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | I6THOZ5KW9PJO9N01OF8 | NULL | NULL | | 3279 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | CNPXAR2490R18A9QEYGV | NULL | NULL | | 3328 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 3NGYT2RY5SRI1P7W7R4O | NULL | NULL | | 3431 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | PNJTRUTUJI3T5TXISLUJ | NULL | NULL | | 3557 | NULL | abc | NULL | NULL | NULL | NULL | NULL | YQL0L1VOTEE1E0YJVX5G | NULL | NULL | | 3821 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 93J2JEVVEI7BNNPL1Y6X | NULL | NULL | | 3010 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | S49UIZDKFJ87J8L3JM9T | NULL | NULL | | 3253 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | CM095JY5WJXJY8HP0YFT | NULL | NULL | | 3316 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 1LL1S97XL7MU4JR0Y5TB | NULL | NULL | | 3393 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | WUM8MEVI5R0HAGQTHW8U | NULL | NULL | | 3461 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | H552BDBSTR677Q0JI8I9 | NULL | NULL | | 3617 | NULL | abc | NULL | NULL | NULL | NULL | NULL | HZ70N7JLDU2DHCNE3W45 | NULL | NULL | | 3671 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | WU8CJYQ4QLASLKYP57WA | NULL | NULL | | 3717 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | MU28DHUS9OD81SRE5OHH | NULL | NULL | | 3719 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | DUXQ6FJL6OGW68PTVV1L | NULL | NULL | | 3792 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | RSK9ZCB49MIG5H64WO5Q | NULL | NULL | | 3016 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | UCNPW4OJHI5SPU1U322U | NULL | NULL | | 3032 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 9X5M48A86E9D92JGMEEN | NULL | NULL | | 3031 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | N93XDJ4IX8NYPFSWCTHE | NULL | NULL | +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ 25 rows in set (0.00 sec) mysql> select * from user_setting limit 25; +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ | us_id | location | user_id | user_config_time | ieautolaunch | oeautolaunch | olautolaunch | lastCountry | +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ | 4649 | home | 3083 | 1138651697014 | true | true | true | United Kingdom | | 5073 | home | 3491 | 1138651804127 | true | true | true | United Kingdom | | 5156 | home | 3677 | 1138651811347 | true | true | true | United Kingdom | | 4642 | home | 3069 | 1138651696943 | true | true | true | United Kingdom | | 4826 | home | 3259 | 1138651730281 | true | true | true | United Kingdom | | 5006 | home | 3439 | 1138651747324 | true | true | true | United Kingdom | | 5060 | home | 3546 | 1138651802779 | true | true | true | United Kingdom | | 4722 | home | 3153 | 1138651699660 | true | true | true | United Kingdom | | 5158 | home | 3684 | 1138651811435 | true | true | true | United Kingdom | | 4584 | home | 3014 | 1138651694217 | true | true | true | United Kingdom | | 5088 | home | 3620 | 1138651804961 | true | true | true | United Kingdom | | 5245 | home | 3850 | 1138651846928 | true | true | true | United Kingdom | | 4742 | home | 3176 | 1138651700583 | true | true | true | United Kingdom | | 4778 | home | 3211 | 1138651702250 | true | true | true | United Kingdom | | 4793 | home | 3226 | 1138651702726 | true | true | true | United Kingdom | | 4819 | home | 3252 | 1138651723278 | true | true | true | United Kingdom | | 4865 | home | 3287 | 1138651736366 | true | true | true | United Kingdom | | 4869 | home | 3265 | 1138651736851 | true | true | true | United Kingdom | | 4874 | home | 3305 | 1138651737198 | true | true | true | United Kingdom | | 4878 | home | 3316 | 1138651737301 | true | true | true | United Kingdom | | 4911 | home | 3299 | 1138651737560 | true | true | true | United Kingdom | | 4935 | home | 3381 | 1138651737745 | true | true | true | United Kingdom | | 4950 | home | 3384 | 1138651738718 | true | true | true | United Kingdom | | 5023 | home | 3462 | 1138651800809 | true | true | true | United Kingdom | | 5111 | home | 3554 | 1138651806583 | true | true | true | United Kingdom | +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ 25 rows in set (0.00 sec) mysql> select * from user_country_setting limit 25; +--------+----------------+---------------+---------------+--------------------+-------+----------+ | ucs_id | country | navigationURL | currentFolder | lastClassification | us_id | rssTopic | +--------+----------------+---------------+---------------+--------------------+-------+----------+ | 35 | United States | NULL | NULL | NULL | 33 | Music | | 222 | United Kingdom | NULL | NULL | NULL | 201 | Business | | 336 | United Kingdom | NULL | NULL | NULL | 317 | Business | | 453 | United Kingdom | NULL | NULL | NULL | 432 | Business | | 481 | United Kingdom | NULL | NULL | NULL | 460 | Business | | 965 | United Kingdom | NULL | NULL | NULL | 944 | Business | | 1369 | United Kingdom | NULL | NULL | NULL | 1348 | Business | | 1386 | United Kingdom | NULL | NULL | NULL | 1365 | Business | | 1450 | United Kingdom | NULL | NULL | NULL | 1429 | Business | | 1456 | United Kingdom | NULL | NULL | NULL | 1435 | Business | | 1758 | United Kingdom | NULL | NULL | NULL | 4267 | Business | | 1766 | United Kingdom | NULL | NULL | NULL | 4278 | Business | | 1798 | United Kingdom | NULL | NULL | NULL | 4308 | Business | | 1848 | United Kingdom | NULL | NULL | NULL | 4357 | Business | | 1871 | United Kingdom | NULL | NULL | NULL | 4381 | Business | | 1917 | United Kingdom | NULL | NULL | NULL | 4427 | Business | | 2108 | United Kingdom | NULL | NULL | NULL | 4619 | Business | | 2109 | United Kingdom | NULL | NULL | NULL | 4620 | Business | | 2157 | United Kingdom | NULL | NULL | NULL | 4669 | Business | | 2208 | United Kingdom | NULL | NULL | NULL | 4718 | Business | | 2433 | United Kingdom | NULL | NULL | NULL | 4944 | Business | | 2581 | United Kingdom | NULL | NULL | NULL | 5092 | Business | | 2780 | United Kingdom | NULL | NULL | NULL | 5291 | Business | | 19 | Argentina | NULL | NULL | NULL | 17 | Music | | 111 | United Kingdom | NULL | NULL | NULL | 91 | Business | +--------+----------------+---------------+---------------+--------------------+-------+----------+ 25 rows in set (0.00 sec) mysql> select * from user_country_link_setting limit 25; +---------+--------+---------+----------+ | ucls_id | ucs_id | link_id | state | +---------+--------+---------+----------+ | 2803 | 307 | 107326 | disabled | | 21458 | 2172 | 112590 | disabled | | 965 | 112 | 112647 | disabled | | 8010 | 817 | 107326 | disabled | | 1848 | 199 | 114348 | disabled | | 7941 | 811 | 107325 | disabled | | 20977 | 2133 | 114349 | disabled | | 18647 | 1901 | 114343 | disabled | | 18158 | 1886 | 112647 | disabled | | 4332 | 447 | 107326 | disabled | | 13406 | 1353 | 113864 | disabled | | 24967 | 2529 | 113864 | disabled | | 17564 | 1808 | 114349 | disabled | | 603 | 70 | 113864 | disabled | | 15867 | 1721 | 107326 | disabled | | 4826 | 498 | 112590 | disabled | | 11936 | 1206 | 112590 | disabled | | 11854 | 1201 | 114348 | disabled | | 9607 | 975 | 112142 | disabled | | 3431 | 340 | 112142 | disabled | | 9104 | 925 | 114343 | disabled | | 6520 | 664 | 107326 | disabled | | 24058 | 2445 | 112590 | disabled | | 26383 | 2667 | 114343 | disabled | | 27562 | 2785 | 114349 | disabled | +---------+--------+---------+----------+ 25 rows in set (0.00 sec) mysql> s -> mysql> select * from user limit 25; +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ | user_id | device_name | sec_answer | sec_question | age_range | gender | home_page_item | email_address | user_account | password | username | +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ | 3445 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 2K04GY6181ALC39HWXPV | NULL | NULL | | 3519 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | SOLAWZ4SPSZPVK0BRB9N | NULL | NULL | | 3809 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | ETV8ZCII8OJSF8XQ9XIG | NULL | NULL | | 2963 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | L7M36WAWS1C49HRFSCJQ | NULL | NULL | | 3035 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | DGRDSJXMEOH8SBIXH7PA | NULL | NULL | | 3066 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | GVFBV50PRCCT5WRQ6J9O | NULL | NULL | | 3088 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | I6THOZ5KW9PJO9N01OF8 | NULL | NULL | | 3279 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | CNPXAR2490R18A9QEYGV | NULL | NULL | | 3328 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 3NGYT2RY5SRI1P7W7R4O | NULL | NULL | | 3431 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | PNJTRUTUJI3T5TXISLUJ | NULL | NULL | | 3557 | NULL | abc | NULL | NULL | NULL | NULL | NULL | YQL0L1VOTEE1E0YJVX5G | NULL | NULL | | 3821 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 93J2JEVVEI7BNNPL1Y6X | NULL | NULL | | 3010 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | S49UIZDKFJ87J8L3JM9T | NULL | NULL | | 3253 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | CM095JY5WJXJY8HP0YFT | NULL | NULL | | 3316 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 1LL1S97XL7MU4JR0Y5TB | NULL | NULL | | 3393 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | WUM8MEVI5R0HAGQTHW8U | NULL | NULL | | 3461 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | H552BDBSTR677Q0JI8I9 | NULL | NULL | | 3617 | NULL | abc | NULL | NULL | NULL | NULL | NULL | HZ70N7JLDU2DHCNE3W45 | NULL | NULL | | 3671 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | WU8CJYQ4QLASLKYP57WA | NULL | NULL | | 3717 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | MU28DHUS9OD81SRE5OHH | NULL | NULL | | 3719 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | DUXQ6FJL6OGW68PTVV1L | NULL | NULL | | 3792 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | RSK9ZCB49MIG5H64WO5Q | NULL | NULL | | 3016 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | UCNPW4OJHI5SPU1U322U | NULL | NULL | | 3032 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | 9X5M48A86E9D92JGMEEN | NULL | NULL | | 3031 | NULL | abc | NULL | 13 - 18 | Male | Business | NULL | N93XDJ4IX8NYPFSWCTHE | NULL | NULL | +---------+-------------+------------+--------------+-----------+--------+----------------+---------------+----------------------+----------+----------+ 25 rows in set (0.00 sec) mysql> select * from user_setting limit 25; +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ | us_id | location | user_id | user_config_time | ieautolaunch | oeautolaunch | olautolaunch | lastCountry | +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ | 4649 | home | 3083 | 1138651697014 | true | true | true | United Kingdom | | 5073 | home | 3491 | 1138651804127 | true | true | true | United Kingdom | | 5156 | home | 3677 | 1138651811347 | true | true | true | United Kingdom | | 4642 | home | 3069 | 1138651696943 | true | true | true | United Kingdom | | 4826 | home | 3259 | 1138651730281 | true | true | true | United Kingdom | | 5006 | home | 3439 | 1138651747324 | true | true | true | United Kingdom | | 5060 | home | 3546 | 1138651802779 | true | true | true | United Kingdom | | 4722 | home | 3153 | 1138651699660 | true | true | true | United Kingdom | | 5158 | home | 3684 | 1138651811435 | true | true | true | United Kingdom | | 4584 | home | 3014 | 1138651694217 | true | true | true | United Kingdom | | 5088 | home | 3620 | 1138651804961 | true | true | true | United Kingdom | | 5245 | home | 3850 | 1138651846928 | true | true | true | United Kingdom | | 4742 | home | 3176 | 1138651700583 | true | true | true | United Kingdom | | 4778 | home | 3211 | 1138651702250 | true | true | true | United Kingdom | | 4793 | home | 3226 | 1138651702726 | true | true | true | United Kingdom | | 4819 | home | 3252 | 1138651723278 | true | true | true | United Kingdom | | 4865 | home | 3287 | 1138651736366 | true | true | true | United Kingdom | | 4869 | home | 3265 | 1138651736851 | true | true | true | United Kingdom | | 4874 | home | 3305 | 1138651737198 | true | true | true | United Kingdom | | 4878 | home | 3316 | 1138651737301 | true | true | true | United Kingdom | | 4911 | home | 3299 | 1138651737560 | true | true | true | United Kingdom | | 4935 | home | 3381 | 1138651737745 | true | true | true | United Kingdom | | 4950 | home | 3384 | 1138651738718 | true | true | true | United Kingdom | | 5023 | home | 3462 | 1138651800809 | true | true | true | United Kingdom | | 5111 | home | 3554 | 1138651806583 | true | true | true | United Kingdom | +-------+----------+---------+------------------+--------------+--------------+--------------+----------------+ 25 rows in set (0.00 sec) mysql> select * from user_country_setting limit 25; +--------+----------------+---------------+---------------+--------------------+-------+----------+ | ucs_id | country | navigationURL | currentFolder | lastClassification | us_id | rssTopic | +--------+----------------+---------------+---------------+--------------------+-------+----------+ | 35 | United States | NULL | NULL | NULL | 33 | Music | | 222 | United Kingdom | NULL | NULL | NULL | 201 | Business | | 336 | United Kingdom | NULL | NULL | NULL | 317 | Business | | 453 | United Kingdom | NULL | NULL | NULL | 432 | Business | | 481 | United Kingdom | NULL | NULL | NULL | 460 | Business | | 965 | United Kingdom | NULL | NULL | NULL | 944 | Business | | 1369 | United Kingdom | NULL | NULL | NULL | 1348 | Business | | 1386 | United Kingdom | NULL | NULL | NULL | 1365 | Business | | 1450 | United Kingdom | NULL | NULL | NULL | 1429 | Business | | 1456 | United Kingdom | NULL | NULL | NULL | 1435 | Business | | 1758 | United Kingdom | NULL | NULL | NULL | 4267 | Business | | 1766 | United Kingdom | NULL | NULL | NULL | 4278 | Business | | 1798 | United Kingdom | NULL | NULL | NULL | 4308 | Business | | 1848 | United Kingdom | NULL | NULL | NULL | 4357 | Business | | 1871 | United Kingdom | NULL | NULL | NULL | 4381 | Business | | 1917 | United Kingdom | NULL | NULL | NULL | 4427 | Business | | 2108 | United Kingdom | NULL | NULL | NULL | 4619 | Business | | 2109 | United Kingdom | NULL | NULL | NULL | 4620 | Business | | 2157 | United Kingdom | NULL | NULL | NULL | 4669 | Business | | 2208 | United Kingdom | NULL | NULL | NULL | 4718 | Business | | 2433 | United Kingdom | NULL | NULL | NULL | 4944 | Business | | 2581 | United Kingdom | NULL | NULL | NULL | 5092 | Business | | 2780 | United Kingdom | NULL | NULL | NULL | 5291 | Business | | 19 | Argentina | NULL | NULL | NULL | 17 | Music | | 111 | United Kingdom | NULL | NULL | NULL | 91 | Business | +--------+----------------+---------------+---------------+--------------------+-------+----------+ 25 rows in set (0.00 sec) mysql> select * from user_country_link_setting limit 25; +---------+--------+---------+----------+ | ucls_id | ucs_id | link_id | state | +---------+--------+---------+----------+ | 2803 | 307 | 107326 | disabled | | 21458 | 2172 | 112590 | disabled | | 965 | 112 | 112647 | disabled | | 8010 | 817 | 107326 | disabled | | 1848 | 199 | 114348 | disabled | | 7941 | 811 | 107325 | disabled | | 20977 | 2133 | 114349 | disabled | | 18647 | 1901 | 114343 | disabled | | 18158 | 1886 | 112647 | disabled | | 4332 | 447 | 107326 | disabled | | 13406 | 1353 | 113864 | disabled | | 24967 | 2529 | 113864 | disabled | | 17564 | 1808 | 114349 | disabled | | 603 | 70 | 113864 | disabled | | 15867 | 1721 | 107326 | disabled | | 4826 | 498 | 112590 | disabled | | 11936 | 1206 | 112590 | disabled | | 11854 | 1201 | 114348 | disabled | | 9607 | 975 | 112142 | disabled | | 3431 | 340 | 112142 | disabled | | 9104 | 925 | 114343 | disabled | | 6520 | 664 | 107326 | disabled | | 24058 | 2445 | 112590 | disabled | | 26383 | 2667 | 114343 | disabled | | 27562 | 2785 | 114349 | disabled | +---------+--------+---------+----------+ 25 rows in set (0.00 sec) mysql> select * from initial_links limit 25; +----+---------+------------+----------------+-----------+----------+ | id | link_id | criteria | match_value | show_link | location | +----+---------+------------+----------------+-----------+----------+ | 35 | 112647 | age_gender | Female_13 - 18 | 0 | NULL | | 19 | 107325 | age_gender | Male_13 - 18 | 0 | NULL | | 54 | 107904 | age_gender | Female_36 - 55 | 0 | NULL | | 27 | 114348 | age_gender | Male_13 - 18 | 0 | NULL | | 61 | 114138 | age_gender | Male_55+ | 0 | NULL | | 22 | 112426 | age_gender | Male_13 - 18 | 0 | NULL | | 39 | 114348 | age_gender | Female_13 - 18 | 0 | NULL | | 44 | 114348 | age_gender | Male_19 - 35 | 0 | NULL | | 48 | 114348 | age_gender | Female_19 - 35 | 0 | NULL | | 42 | 114138 | age_gender | Male_19 - 35 | 0 | NULL | | 68 | 114343 | age_gender | Female_55+ | 0 | NULL | | 46 | 107904 | age_gender | Female_19 - 35 | 0 | NULL | | 58 | 107326 | age_gender | Male_55+ | 0 | NULL | | 30 | 107904 | age_gender | Female_13 - 18 | 0 | NULL | | 33 | 112426 | age_gender | Female_13 - 18 | 0 | NULL | | 51 | 114138 | age_gender | Male_36 - 55 | 0 | NULL | | 59 | 112539 | age_gender | Male_55+ | 0 | NULL | | 32 | 112142 | age_gender | Female_13 - 18 | 0 | NULL | | 21 | 112142 | age_gender | Male_13 - 18 | 0 | NULL | | 66 | 112590 | age_gender | Female_55+ | 0 | NULL | | 64 | 107904 | age_gender | Female_55+ | 0 | NULL | | 25 | 113864 | age_gender | Male_13 - 18 | 0 | NULL | | 40 | 114349 | age_gender | Female_13 - 18 | 0 | NULL | | 56 | 114343 | age_gender | Female_36 - 55 | 0 | NULL | | 45 | 114349 | age_gender | Male_19 - 35 | 0 | NULL | +----+---------+------------+----------------+-----------+----------+ 25 rows in set (0.00 sec) mysql> exit