fam id: (string)3070
@displayAdditionalFormats: 2
current product get :15332
SELECT `e`.*, `at_small_image`.`value` AS `small_image`, `at_onix_availabilitycode`.`value` AS `onix_availabilitycode`, `at_onix_format`.`value` AS `onix_format`, `at_onix_product_family`.`value` AS `onix_product_family`, `at_status`.`value` AS `status`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_entity_varchar` AS `at_small_image` ON (`at_small_image`.`entity_id` = `e`.`entity_id`) AND (`at_small_image`.`attribute_id` = '88') AND (`at_small_image`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_int` AS `at_onix_availabilitycode` ON (`at_onix_availabilitycode`.`entity_id` = `e`.`entity_id`) AND (`at_onix_availabilitycode`.`attribute_id` = '197') AND (`at_onix_availabilitycode`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_int` AS `at_onix_format` ON (`at_onix_format`.`entity_id` = `e`.`entity_id`) AND (`at_onix_format`.`attribute_id` = '177') AND (`at_onix_format`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_varchar` AS `at_onix_product_family` ON (`at_onix_product_family`.`entity_id` = `e`.`entity_id`) AND (`at_onix_product_family`.`attribute_id` = '205') AND (`at_onix_product_family`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 0)
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (at_small_image.value != 'no_selection') AND (at_small_image.value != '') AND (at_small_image.value != 'default/ImageComingSoonShambhala_1_1.png') AND (at_small_image.value IS NOT NULL) AND (at_onix_availabilitycode.value != 150) AND (at_onix_format.value != 8) AND (at_onix_product_family.value = '3070') AND (at_status.value = '1')

Additional Formats

Paperback (05/13/2014)

$9.95

The Pocket Haiku

By Linda Schierse Leonard and Sam Hamill