Prepare failed: Unknown column 'ph.randimgID' in 'SELECT'<br>SQL: WITH photo_random AS (
	SELECT
	  p.randimgID AS plane_photo_id,
	  p.img_lvm AS lvmcode,
	  p.img_nmr AS reg,
	  p.img_folder,
	  p.img_file_thumb,
	  p.img_creator,
	  p.img_approve,
	  p.img_approve_date,
	  p.img_hits,
	  p.frameID,
	  p.operatorID,
	  ROW_NUMBER() OVER (PARTITION BY p.operatorID ORDER BY RAND()) AS rn
	FROM tbl_photos p
	WHERE p.mediatype = 'image'
  )
  
  SELECT 
	ats.ticketseg_id,
	ats.sched_departure_time,
	ats.operating_airline,
	lvm.luchtvaartmaatschappij,
	lvm.luchtvaartmaatschappijID,
	t.toestelID,
	t.toestel,
	ats.reg_nmr,
	lh.luchthavenID AS vlhid,
	lh.luchthavencode,
	lh.luchthavennaam,
	c1.flag_svg AS departureflag,
	lh2.luchthavenID AS alhid,
	lh2.luchthavencode AS aankomstluchthavencode,
	lh2.luchthavennaam AS aankomstnaam,
	c2.flag_svg AS arrivalflag,
	lvm.IATACode,
	ph.randimgID,
	ph.lvmcode,
	ph.img_folder,
	ph.img_file_thumb,
	ph.img_creator,
	ph.img_approve,
	ph.img_approve_date,
	ph.img_hits,
	ph.frameID,
	ph.operatorID
  
  FROM tbl_airline_ticket_seg ats
  
  LEFT JOIN tbl_luchtvaartmaatschappij lvm
	ON ats.operating_airline = lvm.luchtvaartmaatschappijID
  
  LEFT JOIN tbl_toestel t
	ON ats.aircraft_id = t.toestelID
  
  LEFT JOIN tbl_luchthaven lh
	ON ats.departure_airport = lh.luchthavenID
  
  LEFT JOIN tbl_luchthaven lh2
	ON ats.arrival_airport = lh2.luchthavenID
  
  LEFT JOIN tbl_countries c1
	ON lh.countryID = c1.countryID
  
  LEFT JOIN tbl_countries c2
	ON lh2.countryID = c2.countryID
  
  LEFT JOIN photo_random ph
	ON ats.operator_id = ph.operatorID AND ph.rn = 1
  
  WHERE ats.sched_departure_time &lt;= NOW()
	AND ats.flight_status IN ('1','2')
  
  ORDER BY ats.sched_departure_time DESC 
  LIMIT ? OFFSET ?