select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=177
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=177
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=177
union all
select adid, link, image, imgtitle, imgalt, rank+100, showgoogle
from ad
where status is null and rank is not null
order by rank limit 10
select guidelink from categories where id=177
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=177 and enabled is not null
select count(id) records from (
select p.id, p.priority from product p, organization o, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=177 and pending is null and (p.pricecheck is null or (p.pricecheck!=3 and p.pricecheck!=404))
union select p.id, p.priority from product p, organization o, categories c, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=c.id and c.parent=177 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select id, url, name, orgname, type, price, phone, email, title, priority, price1, followlink, descr, city, state, address, orgcity, orgstate, zip, orgphone, fax, orgemail, country, loctype, showprice from (
select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=177
union select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, categories c, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=c.id and c.parent=177 ) x order by ifnull(priority,999), freesort limit 0 , 10
|
|
|
|
|
|
|
|
|
|
select pagename from contactvendors where prodid=193503 Personality Assessment
|
Personality Net |
The most detailed personality assessment on the Internet. Take the Test. |
|
|
|
|
select pagename from contactvendors where prodid=193920 Love Tests
|
Tests.com |
The top 3 love tests. |
|
|
|
|
select pagename from contactvendors where prodid=9303 The Myers-Briggs Type Indicator® Online
|
Career and Personality Tests Online 858-5
71-3931 |
Myers-Briggs Personality Test Online, MBTI, Online Group and Team Testing, Test Packages |
|
|
|
|
select pagename from contactvendors where prodid=30164 Personality Tests
|
Psychometric Success |
How Personality Tests Work |
|
|
|
|
select pagename from contactvendors where prodid=57874 The Personality Profile
|
Personality Online |
Personality Online - Online personality,relationship and apptitude tests, find out who you |
|
|
|
|
select pagename from contactvendors where prodid=96700 AMPM Personality Test
|
Psychology Today 212-260-7210 |
Self Tests by Psychology Today |
|
|
|
|
select pagename from contactvendors where prodid=97338 Conners Comprehensive Behavior Rating Scales (Conners CBRS)
|
Pearson Assessment 0845-630-88-88 |
Conners Comprehensive Behavior Rating Scales (Conners CBRS) from Pearson Assessment |
|
|
|
|
select pagename from contactvendors where prodid=97390 Millon Pre-Adolescent Clinical Inventory (M-PACI)
|
Pearson Assessment 0845-630-88-88 |
Millon Pre-Adolescent Clinical Inventory (M-PACI) from Pearson Assessment |
|
|
|
|
select pagename from contactvendors where prodid=103453 Extroversion/Introversion Test
|
Discovery Health 240-662-2000 |
Discovery Health :: Personality Assessments: Extroversion/Introversion |
|
|
|
|
select pagename from contactvendors where prodid=103463 Leadership Test
|
Discovery Health 240-662-2000 |
Discovery Health :: Personality Assessments: Leadership |
|
|