select distinct wr_parent
, ( ACOS( COS( RADIANS( 37.566535 ) )
* COS( RADIANS( biz_gps1 ) )
* COS( RADIANS( biz_gps2 ) - RADIANS( 126.977969 ) )
+ SIN( RADIANS( 37.566535 ) )
* SIN( RADIANS( biz_gps1 ) )
)
* 6371
) AS distance_in_km from g5_write_bizlist_01 where wr_is_comment = 0 and ( ca_name = '������������������' or ca_name2 = '������������������' ) and ( biz_city_code = '1-304-481' or
biz_city_code like '1-304-481-%' or
biz_city_code like '1-304-481|%' or
biz_city_code like '%|1-304-481' or
biz_city_code like '%|1-304-481-%' or
biz_city_code like '%|1-304-481|%'
) and goods_status_admin = 1 and goods_status = 1 and goods_date >= '2024-04-26 19:22:28' and goods_date01 >= '2024-04-26 19:22:28' and biz_gps1 !='' HAVING distance_in_km <= 1000 order by distance_in_km ASC, wr_num, wr_reply and limit 0, 10
Deprecated: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 7794
Deprecated: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 15617
Deprecated: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 15617
Warning: Undefined variable $price1 in /myebiz247/www/module/gn/__bbs__list__bizlist.php on line 135
Warning: Undefined variable $price2 in /myebiz247/www/module/gn/__bbs__list__bizlist.php on line 136
Deprecated: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 7794
Deprecated: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 15617
Deprecated: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is deprecated in /myebiz247/www/board/plugin/htmlpurifier/HTMLPurifier.standalone.php on line 15617