jwarren

@msaari When I search for "web developer", there absolutely is:

(SELECT ID FROM wp_posts as p, wp_term_relationships as r, wp_term_taxonomy as s, wp_terms as t WHERE r.term_taxonomy_id = s.term_taxonomy_id AND s.term_id = t.term_id AND p.ID = r.object_id AND s.taxonomy IN ('category','people_position') AND t.name LIKE '%web developer%' AND p.post_status IN ('publish','draft','private','pending','future','inherit'))

It’s part of a much larger query. There aer several queries very similar to this one:

SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 15 +
				relevanssi.content * 1 + relevanssi.comment * 0.75 +
				relevanssi.tag * 0.75 + relevanssi.link * 0 +
				relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
				relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
				FROM wp_relevanssi AS relevanssi  WHERE  relevanssi.term = 'web'   AND (relevanssi.doc IN (SELECT ID FROM wp_posts
			WHERE (post_content LIKE '%web developer%' OR post_title LIKE '%web developer%' )
			AND post_status IN ('publish','draft','private','pending','future','inherit')) OR relevanssi.doc IN (SELECT ID FROM wp_posts as p, wp_term_relationships as r, wp_term_taxonomy as s, wp_terms as t
				WHERE r.term_taxonomy_id = s.term_taxonomy_id AND s.term_id = t.term_id AND p.ID = r.object_id
				AND s.taxonomy IN ('category','people_position')
				AND t.name LIKE '%web developer%' AND p.post_status IN ('publish','draft','private','pending','future','inherit')) OR relevanssi.doc IN (SELECT ID
				FROM wp_posts AS p, wp_postmeta AS m
				WHERE p.ID = m.post_id
				AND (m.meta_key NOT LIKE '_%' OR m.meta_key = '_relevanssi_pdf_content')
				AND m.meta_value LIKE '%web developer%'
				AND p.post_status IN ('publish','draft','private','pending','future','inherit'))) ORDER BY tf DESC LIMIT 500

However, when I search for just web developer, I get several smaller queries, like these two:

SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 15 +
				relevanssi.content * 1 + relevanssi.comment * 0.75 +
				relevanssi.tag * 0.75 + relevanssi.link * 0 +
				relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
				relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
				FROM wp_relevanssi AS relevanssi  WHERE  relevanssi.term = 'web'   ORDER BY tf DESC LIMIT 500

SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 15 +
				relevanssi.content * 1 + relevanssi.comment * 0.75 +
				relevanssi.tag * 0.75 + relevanssi.link * 0 +
				relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
				relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
				FROM wp_relevanssi AS relevanssi  WHERE  relevanssi.term = 'developer'   ORDER BY tf DESC LIMIT 500

Jordy, thank you very much! You’re a star. Btw, is there any idea of how to identify which files are malformed? We have approx 500 images in this site, so can’t realistically go through one by one.

Thanks for your quick response, Tobias.

In this particular case, I’ve got a table being used as a timetable, with the x axis as days of the week, and the y axis as rough timeslots. Within each cell needs to sit three items. Let’s call them startingtime, subject (which may well wrap onto the next line), and teacher.

Now, ideally there would be a decent amount of room between each of those three attributes. However, adjusting the line-height will push wrapped subject lines apart, as it should do. How I’d ideally do it, is put a bit of margin on the td ps, and a border-top and border-bottom on the td p:nth-child(2) for the non-IE users.

Unfortunately, <br> is an non-stylable element, so unless I use some javascript to style it up, I’ve got no options.

——

In a mostly unrelated feature request, another useful feature would be to be able to set a custom id and/or class for each table, simply to help in transferring CSS from static files.

By the way, thank you so much for your time, Tobias. I and many others really appreciate the work that plugin authors like you do.