',
'statement' => 'SELECT boat.categ,boat.categ3,boat.boat_id,boat.manufacturer,boat.description,boat.feet,boat.inches,boat.year,boat.model,boat.state_loc,boat.country_loc,boat.boat_type,boat.material,boat.seller_telephone,boat.seller_email,boat.price,boat.trailer_year,boat.trailer_model,boat.trailer_make, SUBSTRing( MIN( CONCAT( RPAD(pic.pic_id,6,\' \'),pic.web_loc)),7) as show_image, boat.categ,boat.city_loc,boat.engine_info,boat.deck_info,boat.electronic_info,boat.date_entered,boat.date_modified,broker.broker_name,boat.broker_id,boat.price_type, boat.old_price, boat.blow_out_price, boat.beam, boat.draft, boat.displacement, boat.boat_number, boat.reg_number, boat.engine_serial_number, boat.hull_id_number, boat.draft_inches, boat.trailer_year, boat.trailer_model, boat.trailer_make, boat.boat_ref FROM classf_boats as boat, classf_brokers as broker, classf_pics as pic WHERE boat.boat_id = \'35581\' AND (boat.broker_id = \'63\')AND (boat.broker_id = broker.broker_id) AND (boat.boat_id = pic.boat_id) AND boat.cloak = 0 GROUP BY boat.boat_id ORDER BY date_modified desc',
'FORM' => {
'boat_id' => '35581',
'return' => 'class_search.pl?categ=boat&categ2=used'
},
'reldir' => undef,
'max_pic_ul' => '6',
'commify' => sub { "DUMMY" },
'boat' => {
'description' => 'End of Season Sale Price!',
'date_modified' => '20220802151150',
'seller_telephone' => '203-245-7242',
'material' => 'Fiberglass',
'city_loc' => 'Madison',
'engine_info' => '300 hp Volvo Penta',
'electronic_info' => '',
'trailer_make' => '',
'seller_email' => 'goodboating@theboatcenter.biz',
'show_image0' => 'http://www.theboatcenter.biz/boatsforsale/images/IMG_6690-62019.jpg',
'country_loc' => 'USA',
'draft' => '',
'categ3' => '',
'show_image1' => 'http://www.theboatcenter.biz/boatsforsale/images/IMG_6691-43854.jpg',
'show_image' => 'http://www.theboatcenter.biz/boatsforsale/images/IMG_6690-62019.jpg',
'engine_serial_number' => '',
'categ' => 'boat',
'state_loc' => 'CT',
'beam' => '',
'date_out' => 'August 02 2022',
'price' => '13500',
'displacement' => '',
'inches' => 0,
'old_price' => 0,
'deck_info' => '',
'boat_type' => 'power',
'manufacturer' => 'Pickerell',
'blow_out_price' => 0,
'year' => 2002,
'model' => '22 Downeast',
'price_type' => 0,
'trailer_model' => '',
'boat_id' => 35581,
'draft_inches' => 0,
'hull_id_number' => 'Express',
'broker_id' => 63,
'feet' => 0,
'boat_ref' => '',
'broker_name' => 'The Boat Center',
'trailer_year' => 'Blue',
'reg_number' => 'Fiberglass',
'boat_number' => '',
'date_entered' => '20220210154624'
}
};
|
|
|||||||||||||||||||||
