| | ['args'] =>
Array (1) (
| | | ['0'] = String(5190) "SELECT banner.bannerid AS id,
special_desc AS description,
address1,
special_mon as mon,
CONCAT(establishment.establishment, ' ', establishment.establishment_subheader) AS estname,
establishment.custom_page_url as custom_page_url,
establishment.gmap_lat,
establishment.gmap_long,
establishment.photo_logo,
establishment.establishmentid AS estid,
establishment.establishmenttypeid AS primarytypeid,
establishmenttype.establishmenttypeid AS esttype1Id,
establishmenttype.establishmenttype AS esttype1,
establishmenttype.url AS esturl1,
establishment.cuisinetypeid AS rtype1Id, r1.cuisinetype AS rtype1,
r1.url AS rurl1,
establishment.cuisinetype2 AS rtype2Id, r2.cuisinetype AS rtype2,
r2.url AS rurl2,
establishment.cuisinetype3 AS rtype3Id, r3.cuisinetype AS rtype3,
r3.url AS rurl3,
establishment.cuisinetype4 AS rtype4Id, r4.cuisinetype AS rtype4,
r4.url AS rurl4,
establishment.bartypeid AS btype1Id, b1.bartype AS btype1,
b1.url AS burl1,
establishment.cuisinetype4 AS btype2Id, b2.bartype AS btype2,
b2.url AS burl2,
establishment.cuisinetype5 AS btype3Id, b3.bartype AS btype3,
b3.url AS burl3,
establishment.coffeetypeid AS ctype1Id, c1.coffeetype AS ctype1,
c1.url AS curl1,
establishment.caterer_type_id AS cttype1Id, ct1.caterer_type AS cttype1,
ct1.url AS cturl1,
establishment.caterer_type2_id AS cttype2Id, ct2.caterer_type AS cttype2,
ct2.url AS cturl2,
establishment.caterer_type3_id AS cttype3Id, ct3.caterer_type AS cttype3,
ct3.url AS cturl3,
establishment.caterer_type4_id AS cttype4Id, ct4.caterer_type AS cttype4,
ct4.url AS cturl4,
establishment.banquet_type_id AS bhtype1Id, bh1.banquet_type AS bhtype1,
bh1.url AS bhurl1,
establishment.banquet_type2_id AS bhtype2Id, bh2.banquet_type AS bhtype2,
bh2.url AS bhurl2,
establishment.banquet_type3_id AS bhtype3Id, bh3.banquet_type AS bhtype3,
bh3.url AS bhurl3,
establishment.banquet_type4_id AS bhtype4Id, bh4.banquet_type AS bhtype4,
bh4.url AS bhurl4,
establishment.hotel_type_id AS htype1Id, h1.hotel_type AS htype1,
h1.url AS hurl1,
establishment.hotel_type2_id AS htype2Id, h1.hotel_type AS htype2,
h1.url AS hurl2,
establishment.attraction_type_id AS atype1Id, a1.attraction_type AS atype1,
a1.url AS aurl1,
establishment.attraction_type2_id AS atype2Id, a2.attraction_type AS atype2,
a2.url AS aurl2,
establishment.attraction_type3_id AS atype3Id, a3.attraction_type AS atype3,
a3.url AS aurl3
, ( 6371 * acos( cos( radians(0) ) * cos( radians( establishment.gmap_lat ) ) * cos( radians( establishment.gmap_long ) - radians(0) ) + sin( radians(0) ) * sin( radians( establishment.gmap_lat ) ) ) ) AS distance
FROM establishment_specials as banner
LEFT JOIN establishment ON establishment.establishmentid = banner.establishmentid
LEFT JOIN establishmenttype ON establishmenttype.establishmenttypeid = establishment.establishmenttypeid
LEFT JOIN cuisinetype AS r1 ON establishment.cuisinetypeid = r1.cuisinetypeid
LEFT JOIN cuisinetype AS r2 ON establishment.cuisinetype2 = r2.cuisinetypeid
LEFT JOIN cuisinetype AS r3 ON establishment.cuisinetype3 = r3.cuisinetypeid
LEFT JOIN cuisinetype AS r4 ON establishment.cuisinetype6 = r4.cuisinetypeid
LEFT JOIN bartype AS b1 ON establishment.bartypeid = b1.bartypeid
LEFT JOIN bartype AS b2 ON establishment.cuisinetype5 = b2.bartypeid
LEFT JOIN bartype AS b3 ON establishment.cuisinetype4 = b3.bartypeid
LEFT JOIN coffeetype AS c1 ON establishment.coffeetypeid = c1.coffeetypeid
LEFT JOIN caterer_types AS ct1 ON establishment.caterer_type_id = ct1.id
LEFT JOIN caterer_types AS ct2 ON establishment.caterer_type2_id = ct2.id
LEFT JOIN caterer_types AS ct3 ON establishment.caterer_type3_id = ct3.id
LEFT JOIN caterer_types AS ct4 ON establishment.caterer_type4_id = ct4.id
LEFT JOIN banquet_types AS bh1 ON establishment.banquet_type_id = bh1.id
LEFT JOIN banquet_types AS bh2 ON establishment.banquet_type2_id = bh2.id
LEFT JOIN banquet_types AS bh3 ON establishment.banquet_type3_id = bh3.id
LEFT JOIN banquet_types AS bh4 ON establishment.banquet_type4_id = bh4.id
LEFT JOIN hotel_types AS h1 ON establishment.hotel_type_id = h1.id
LEFT JOIN hotel_types AS h2 ON establishment.hotel_type2_id = h2.id
LEFT JOIN attraction_types AS a1 ON establishment.attraction_type_id = a1.id
LEFT JOIN attraction_types AS a2 ON establishment.attraction_type2_id = a2.id
LEFT JOIN attraction_types AS a3 ON establishment.attraction_type3_id = a3.id
WHERE banner.flag_is_special = 1 AND establishment.published = 1 AND special_mon = 1 "
| | )