Enter a trade or a company name
My postcode is
Home » Search results » Kitchen Design and Installation in London E1

0 tradesmen found for Kitchen Design And Installation in London E1
  • user warning: Deadlock found when trying to get lock; try restarting transaction query: CREATE TEMPORARY TABLE IF NOT EXISTS ks_results73fec6c605f0647d70fe745ff5cb36ba AS ( SELECT u.uid, u.name, p.id, p.uid AS userID, p.firstname, p.lastname, p.company, p.url, p.completed as completed, p.postcode, p.description, p.avatar as avatar, p.membership_type, ku.num as coreTrade, pv.post_town as location, ( SELECT MAX(id) FROM areas_to_users WHERE uid = p.uid AND location = 'Greater London' AND location_type = 'COUNTY') as max_a_id, ( SELECT is_primary FROM areas_to_users WHERE id = max_a_id) as cprimary_location, ( SELECT is_primary FROM areas_to_users WHERE uid = p.uid AND location = 'LONDON' AND location_type = 'TOWN' ) as tprimary_location, ( SELECT SQRT(POW(ABS(535200 - pv.east),2) + POW(ABS(181000 - pv.north),2))) as distance, ( SELECT keyword FROM keywords k WHERE k.id = (SELECT kid FROM keywords_to_users ku WHERE ku.uid = p.uid AND ku.num = '0' LIMIT 0,1 ) ) as trade, ( SELECT COUNT(id) FROM reviews WHERE user_id = p.uid AND status = 1 LIMIT 0, 1 ) as review_count, ( SELECT MAX(review_date) FROM reviews WHERE user_id = p.uid AND status = 1 ) as rdate, ( SELECT MAX(id) FROM reviews WHERE user_id=p.uid AND status = 1 AND review_date = rdate) as review_id, ( SELECT good_review FROM reviews WHERE id = review_id AND status = 1 ) as good_review, ( SELECT review_text FROM reviews WHERE id = review_id AND status = 1 ) as review_text, ( SELECT review_title FROM reviews WHERE id = review_id AND status = 1 ) as review_title, ( SELECT reviewed_by FROM reviews WHERE id = review_id AND status = 1 ) as reviewed_by, ( SELECT money_rate FROM reviews WHERE id = review_id AND status = 1 ) as money_rate, ( SELECT service_rate FROM reviews WHERE id = review_id AND status = 1 ) as service_rate, ( SELECT work_rate FROM reviews WHERE id=review_id AND status = 1 ) as work_rate, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 7776000) AND good_review = 1 AND user_id = p.uid AND status = 1 ) as goodLess3M, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 15552000) AND review_date < (UNIX_TIMESTAMP() - 7776000) AND good_review = 1 AND user_id = p.uid AND status = 1 ) as goodLess6M, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 31104000) AND review_date < (UNIX_TIMESTAMP() - 15552000) AND good_review = 1 AND user_id = p.uid AND status = 1 ) as goodLess12M, (SELECT COUNT(id) FROM reviews WHERE review_date < (UNIX_TIMESTAMP() - 31104000) AND good_review =1 AND user_id = p.uid AND status = 1 ) as goodMore12M, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 7776000) AND good_review = 0 AND user_id = p.uid AND status = 1 ) as badLess3M, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 15552000) AND review_date < (UNIX_TIMESTAMP() - 7776000) AND good_review = 0 AND user_id = p.uid AND status = 1 ) as badLess6M, (SELECT COUNT(id) FROM reviews WHERE review_date > (UNIX_TIMESTAMP() - 31104000) AND review_date < (UNIX_TIMESTAMP() - 15552000) AND good_review = 0 AND user_id = p.uid AND status = 1 ) as badLess12M, (SELECT COUNT(id) FROM reviews WHERE review_date < (UNIX_TIMESTAMP() - 31104000) AND good_review = 0 AND user_id = p.uid AND status = 1 ) as badMore12M, ( SELECT IF(completed > 64 , 1, 0) + IF(coreTrade < 6, 2, 0) + (goodLess3M * 3 + goodLess6M * 2 + goodLess12M * 1 + goodMore12M * 0.5) - ( badLess3M * 3 + badLess6M * 2 + badLess12M * 1 + badMore12M * 0.5) + IF(distance <= 2000 , 6, IF(distance <= 5000 , 4, IF(distance <= 10000 , 2, IF(distance <= 20000 , 1, IF(distance <= 30000 , 0.5, 0 ) ) ) ) ) ) as points FROM users u LEFT JOIN keywords_to_users ku ON (u.uid = ku.uid) LEFT JOIN profile p ON (p.uid = u.uid ) LEFT JOIN post_viewpoints pv ON (pv.postcode = p.postcode ) WHERE u.status = 1 AND kid = '77' AND p.uid IN (SELECT uid FROM areas_to_users WHERE location = 'LONDON' OR location = 'Greater London') GROUP BY p.uid ) in /var/www/html/includes/database.mysqli.inc on line 151.
  • user warning: Table 'problemsolved.ks_results73fec6c605f0647d70fe745ff5cb36ba' doesn't exist query: SELECT COUNT(*) FROM ks_results73fec6c605f0647d70fe745ff5cb36ba WHERE ((membership_type != 'Free') OR (membership_type = 'Free' AND coreTrade = 0 AND (cprimary_location = 1 OR tprimary_location = 1) ) ) in /var/www/html/includes/database.mysqli.inc on line 151.
  • user warning: Table 'problemsolved.ks_results73fec6c605f0647d70fe745ff5cb36ba' doesn't exist query: SELECT * FROM ks_results73fec6c605f0647d70fe745ff5cb36ba WHERE ((membership_type != 'Free') OR (membership_type = 'Free' AND coreTrade = 0 AND (cprimary_location = 1 OR tprimary_location = 1) ) ) ORDER BY points DESC LIMIT 0, 10 in /var/www/html/includes/database.mysqli.inc on line 151.
  • user warning: Table 'problemsolved.ks_results73fec6c605f0647d70fe745ff5cb36ba' doesn't exist query: SELECT COUNT(uid) as userTotal FROM ks_results73fec6c605f0647d70fe745ff5cb36ba WHERE (membership_type != 'Free') OR (membership_type = 'Free' AND coreTrade = 0 AND (cprimary_location = 1 OR tprimary_location = 1)) in /var/www/html/includes/database.mysqli.inc on line 151.