Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/functions/base.php on line 143
The UPGRADED READ [ get_loop() ] SQL statement:
SELECT c.slug AS cityslug, c.name AS cityname, s.name AS statename, s.slug AS stateslug, pc.slug AS catslug, pc.name AS catname, p.*, (SELECT u.screenname FROM users u WHERE u.id=p.userid) AS screenname, (SELECT nb.naughtyurl FROM naughty_backlinks nb WHERE nb.postid=p.id) AS naughtyurl, (SELECT CONCAT(co.email,'||++**++||',co.phone,'||++**++||',co.website) FROM post_contact co WHERE co.postid=p.id) AS contact_concat, (SELECT CONCAT(ps.reviewlink1,'||++**++||',ps.reviewlink2,'||++**++||',ps.reviewlink3,'||++**++||',ps.reviewlink4,'||++**++||',ps.incall,'||++**++||',ps.outcall,'||++**++||',ps.hair,'||++**++||',ps.eyes,'||++**++||',ps.height,'||++**++||',ps.weight,'||++**++||',ps.cup,'||++**++||',ps.bust,'||++**++||',ps.waist,'||++**++||',ps.hips,'||++**++||',ps.build) FROM post_stats ps WHERE ps.postid=p.id) AS stats_concat, (SELECT CONCAT(il.street1,'||++**++||',il.street1_type,'||++**++||',il.street2,'||++**++||',il.street2_type,'||++**++||',il.zipcode,'||++**++||',il.address) FROM incall_locations il WHERE il.postid=p.id) AS incall_concat, (SELECT po.id FROM post po WHERE po.city=p.city AND po.category=p.category AND po.createdate > 0 AND po.createdate < p.createdate ORDER BY po.createdate DESC LIMIT 1) AS postid_older, (SELECT pn.id FROM post pn WHERE pn.city=p.city AND pn.category=p.category AND pn.createdate > 0 AND pn.createdate > p.createdate ORDER BY pn.createdate LIMIT 1) AS postid_newer FROM post p, city c, states s, category_post pc WHERE p.id=3516311 AND p.city=c.id AND c.state=s.id AND p.category=pc.id
Generated an error:Out of resources when opening file './myproviderguide/naughty_backlinks.MYD' (Errcode: 24)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/functions/base.php on line 143
The UPGRADED READ [ get_loop() ] SQL statement:
SELECT c.slug AS cityslug, c.name AS cityname, s.name AS statename, s.slug AS stateslug, pc.slug AS catslug, pc.name AS catname, p.*, (SELECT u.screenname FROM users u WHERE u.id=p.userid) AS screenname, (SELECT nb.naughtyurl FROM naughty_backlinks nb WHERE nb.postid=p.id) AS naughtyurl, (SELECT CONCAT(co.email,'||++**++||',co.phone,'||++**++||',co.website) FROM post_contact co WHERE co.postid=p.id) AS contact_concat, (SELECT CONCAT(ps.reviewlink1,'||++**++||',ps.reviewlink2,'||++**++||',ps.reviewlink3,'||++**++||',ps.reviewlink4,'||++**++||',ps.incall,'||++**++||',ps.outcall,'||++**++||',ps.hair,'||++**++||',ps.eyes,'||++**++||',ps.height,'||++**++||',ps.weight,'||++**++||',ps.cup,'||++**++||',ps.bust,'||++**++||',ps.waist,'||++**++||',ps.hips,'||++**++||',ps.build) FROM post_stats ps WHERE ps.postid=p.id) AS stats_concat, (SELECT CONCAT(il.street1,'||++**++||',il.street1_type,'||++**++||',il.street2,'||++**++||',il.street2_type,'||++**++||',il.zipcode,'||++**++||',il.address) FROM incall_locations il WHERE il.postid=p.id) AS incall_concat, (SELECT po.id FROM post po WHERE po.city=p.city AND po.category=p.category AND po.createdate > 0 AND po.createdate < p.createdate ORDER BY po.createdate DESC LIMIT 1) AS postid_older, (SELECT pn.id FROM post pn WHERE pn.city=p.city AND pn.category=p.category AND pn.createdate > 0 AND pn.createdate > p.createdate ORDER BY pn.createdate LIMIT 1) AS postid_newer FROM post p, city c, states s, category_post pc WHERE p.id=3516311 AND p.city=c.id AND c.state=s.id AND p.category=pc.id
Generated an error:Out of resources when opening file './myproviderguide/naughty_backlinks.MYD' (Errcode: 24)