You have a Pending Reference from USER NAME(s)
To clear this message, scroll down the page and Give Reference or Reject the request.
Hover over the Review, click to expand and read entire review, click to collapse
Legend: E = Experience, # = Number of Reviews, Date = Review Submitted
Provider | E | # | Date | |
---|---|---|---|---|
Sunny Phillips | Yes | 37 | 11/22/22 | |
Seen on 11/12/22
Time: 1 hr Location: Fort CollinsIn-Call/Out-Call: In-Call Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Unknown Additional Website Link: https://www.preferred411.com/P115 Experience Description: First time seeing Sunny and she made me feel like we've known each other for years! Everything about her is great and I can't wait to see her again Age: 55 Hair Color: Red Tattoos: None Piercings: None Body Type: Curvy Ethnicity: Caucasian Eyes: Brown Grooming: Trimmed Smoker: No Breasts: Natural Measurements: 40D-N/A-N/A |
||||
Bettie Bangs | Yes | 12 | 2/19/22 | |
Seen on 2/12/22
Time: 1 hr Location: WestminsterIn-Call/Out-Call: In-Call Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Yes Experience Description: Was able to see Bettie today and it was as great as the first time I saw her! She's so easy going and makes you feel comfortable as soon as you walk in. Everything done with great enthusiasm and I can't wait to see her again! Age: 45 Hair Color: Auburn Tattoos: Lots Piercings: Some Body Type: Average Ethnicity: Caucasian Eyes: Blue Grooming: Bare Smoker: Yes Breasts: Natural Measurements: 36B-N/A-N/A |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
select * from `users` where `users`.`id` = '140589' limit 1
480μsParams | |
---|---|
0 | 140589 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `reviewers` where `user_id` in ('140589')
290μsParams | |
---|---|
0 | 140589 |
hints | Use SELECT * only if you need all columns from table |
select * from `images` where `images`.`id` in ('0')
170μsParams | |
---|---|
0 | 0 |
hints | Use SELECT * only if you need all columns from table |
select * from `reviews` where `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `reviews`.`reviewer_id` in ('140589')
850μsParams | |
---|---|
0 | 2 |
1 | 0 |
2 | 0 |
3 | 140589 |
hints | Use SELECT * only if you need all columns from tableThe != operator is not standard. Use the <> operator to test for inequality instead. |
select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('93394', '95501')
360μsParams | |
---|---|
0 | 1 |
1 | 93394 |
2 | 95501 |
hints | Use SELECT * only if you need all columns from table |
select * from `providers` where `providers`.`user_id` in ('136600', '90646')
420μsParams | |
---|---|
0 | 136600 |
1 | 90646 |
hints | Use SELECT * only if you need all columns from table |
select * from `users` where `users`.`userable_id` in ('90646', '136600') and `users`.`userable_type` = 'Provider'
620μsParams | |
---|---|
0 | 90646 |
1 | 136600 |
2 | Provider |
hints | Use SELECT * only if you need all columns from table |
select provider_id, COUNT(*) as review_count from (SELECT provider_id, COUNT(*) FROM `reviews` WHERE `status` = 1 AND `approved_at` <= '2025-04-18T00:13:58+0000' GROUP BY `provider_id`, `reviewer_id`) as reviews where `reviews`.`provider_id` in ('90646', '136600') group by `provider_id`
137.76msParams | |
---|---|
0 | 90646 |
1 | 136600 |
select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('')
220μsParams | |
---|---|
0 | 1 |
1 | |
hints | Use SELECT * only if you need all columns from table |
select * from `cities` where `cities`.`id` in ('774', '25')
310μsParams | |
---|---|
0 | 774 |
1 | 25 |
hints | Use SELECT * only if you need all columns from table |
select count(*) as aggregate from `referrals` where `user_from_id` is null and `user_to_id` = '140589' limit 1
300μsParams | |
---|---|
0 | 140589 |
hints | LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select count(*) as aggregate from `referral_permissions` where `reviewer_id` = '140589' and `provider_id` is null limit 1
250μsParams | |
---|---|
0 | 140589 |
hints | LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `cities` where `cities`.`id` = '25' limit 1
180μsParams | |
---|---|
0 | 25 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select count(*) as aggregate from `referral_permissions` where `reviewer_id` = '140589' and `provider_id` is null limit 1
180μsParams | |
---|---|
0 | 140589 |
hints | LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `reviews` where `reviews`.`reviewer_id` = '140589' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'
720μsParams | |
---|---|
0 | 140589 |
1 | 2 |
2 | 0 |
3 | 0 |
4 | 1 |
hints | Use SELECT * only if you need all columns from tableThe != operator is not standard. Use the <> operator to test for inequality instead. |
select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('93394', '95501')
250μsParams | |
---|---|
0 | 1 |
1 | 93394 |
2 | 95501 |
hints | Use SELECT * only if you need all columns from table |
select `id` from `reviews` where `reviews`.`reviewer_id` = '140589' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 order by `created_at` desc limit 16 offset 0
680μsParams | |
---|---|
0 | 140589 |
1 | 2 |
2 | 0 |
3 | 0 |
hints | The != operator is not standard. Use the <> operator to test for inequality instead. |
select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('95501', '93394')
330μsParams | |
---|---|
0 | 1 |
1 | 95501 |
2 | 93394 |
hints | Use SELECT * only if you need all columns from table |
select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '95501'
380μsParams | |
---|---|
0 | 95501 |
select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1
170μsParams | |
---|---|
0 | 1 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1
160μsParams | |
---|---|
0 | 2 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1
140μsParams | |
---|---|
0 | 3 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1
110μsParams | |
---|---|
0 | 4 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1
120μsParams | |
---|---|
0 | 5 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1
130μsParams | |
---|---|
0 | 6 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1
120μsParams | |
---|---|
0 | 7 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1
130μsParams | |
---|---|
0 | 8 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1
120μsParams | |
---|---|
0 | 9 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '93394'
340μsParams | |
---|---|
0 | 93394 |
select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1
160μsParams | |
---|---|
0 | 1 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1
110μsParams | |
---|---|
0 | 2 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1
110μsParams | |
---|---|
0 | 3 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1
110μsParams | |
---|---|
0 | 4 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1
110μsParams | |
---|---|
0 | 5 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1
110μsParams | |
---|---|
0 | 6 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1
110μsParams | |
---|---|
0 | 7 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1
110μsParams | |
---|---|
0 | 8 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1
110μsParams | |
---|---|
0 | 9 |
hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |