OK, I am getting a better response from the query but it still cuts off midway through one of the results. Could this be for some reason other than a bad query?
here is what is being returned. As I hope is clear, the room2_6.jpg text is not complete and the image and data for room2_7.jpg is completely missing.
The data for image2_7.jpg and its text, is in keeping with what the query is looking for.
$VAR1 = [
'room2_2.jpg,We have completely re-furnished this room, including with a new bed and mattress, for April 2010. ',
'room2_3.jpg,The period feature fireplace in The Large Double. ',
'room2_4.jpg,Space aplenty in our large double. ',
'room2_5.jpg,Fresh, luxury mono-grammed towelling, including toothpastes, shampoos and shower gels. ',
here is the query:
) ORDER BY fp.facility_category asc
SEPARATOR ';' ) AS facilities
from products_stock ps
JOIN facilities_products as fp
ON fp.live_product_id = ps.id
AND fp.business_id = ps.business_id
JOIN ( SELECT business_id
SEPARATOR ';' ) AS image_data
where business_id = '153'
and gallery_name = 'Double (Standard)'
and active = 1
) as im
on im.business_id = fp.business_id
join product_live pl
on pl.product_id = ps.id
and pl.start_date <= curdate()
and pl.end_date > curdate()
and priority = 'b'
where ps.business_id = '153'
and ps.room_type = 'Double (Standard)