Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql-temptable-24182-91de5089-100be6.MAI' (Errcode: 28 "No space left on device") in /var/www/vhosts/silverseaships.com/httpdocs/classes.php on line 1833
1: Can't create/write to file '/tmp/#sql-temptable-24182-91de5089-100be6.MAI' (Errcode: 28 "No space left on device")SELECT `s`.*, `sv`.`special_amount`, `sv`.`cruise_category` FROM `specials_voyages` `sv` RIGHT JOIN `specials` `s` ON ( `sv`.`special_id` = `s`.`id` ) WHERE ( `s`.`cruise_line_id` = '3' AND `s`.`type` = 'earlybooking' AND '2024-05-13' > DATE_ADD(NOW(), INTERVAL `s`.`search_query` MONTH ) ) OR ( `s`.`cruise_line_id` = '3' AND `s`.`type` = 'lastminute' AND '2024-05-13' < DATE_ADD(NOW(), INTERVAL 2 MONTH) ) OR ( ( DATE( `s`.`start_date` ) <= CURDATE() AND DATE( `s`.`end_date` ) >= CURDATE() ) AND ( ( `sv`.`cruise_date` = '2024-05-13' AND `sv`.`cruise_ship` = '14' AND `sv`.`cruise_length` = '11' ) OR ( `s`.`cruise_line_id` = '3' AND `s`.`all_cruises` = '1' ) ) ) GROUP BY `s`.`id` ORDER BY `s`.`order` ASC