•db error
- Error number 1030
- Got error 28 from storage engine
- SELECT
ctime,
property_id,
`lat`,`long`,
number_bedrooms,
number_bathrooms,
max_guests,
featured,
location,
indoor_facilities,
outdoor_facilities,
vrs4_properties.currency_id,
vrs4_currencies.symbol_lft,
vrs4_currencies.symbol_rgt,
IF(
vrs4_property_types.title_1<>'',
vrs4_property_types.title_1,
vrs4_property_types.title_1
) as property_type_title,
IF(summary_1<>'',summary_1,summary_1) as summary,
IF(
vrs4_properties.title_1<>'',
vrs4_properties.title_1,
vrs4_properties.title_1
) as title,
IF(
vrs4_properties.summary_1<>'',
vrs4_properties.summary_1,
vrs4_properties.summary_1
) as summary,
grade,
show_availability,
late_availability,
property_type2
FROM (`vrs4_properties`)
INNER JOIN `vrs4_property_types` ON vrs4_property_types.property_type_id=vrs4_properties.property_type
INNER JOIN `vrs4_currencies` ON vrs4_currencies.currency_id=vrs4_properties.currency_id
WHERE vrs4_properties.active = '1'
AND `location` LIKE '%836%'
AND `location` REGEXP '[[:<:]]836[[:>:]]'
ORDER BY `featured` desc, RAND(), `property_id`
LIMIT 10