Navigation
- MySQL server version: 5.0.67-0ubuntu6 collapsCat options: Array ( [title] => Navigation [showPostCount] => [inExclude] => exclude [inExcludeCats] => [showPosts] => 1 [showPages] => [linkToCat] => [olderThan] => 0 [excludeAll] => 0 [catSortOrder] => ASC [catSort] => catName [postSortOrder] => DESC [postSort] => postDate [expand] => 3 [defaultExpand] => General Information,Grape varieties,News and Events,Our offers [debug] => 1 [postTitleLength] => [animate] => 1 [catfeed] => none [catTag] => cat [postDateAppend] => after [postDateFormat] => m/d [showPostDate] => [useCookies] => 1 [postsBeforeCats] => [showTopLevel] => 1 [customExpand] => [customCollapse] => [number] => 3 [includeCatArray] => Array ( ) ) postsToExclude: Array ( ) CATEGORY QUERY: SELECT t.*, tt.* FROM wp_en_terms AS t INNER JOIN wp_en_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND t.slug!='blogroll' ORDER BY t.name ASC CATEGORY QUERY RESULTS Array ( [0] => stdClass Object ( [term_id] => 3 [name] => General Information [slug] => info [term_group] => 0 [term_taxonomy_id] => 3 [taxonomy] => category [description] => [parent] => 0 [count] => 4 ) [1] => stdClass Object ( [term_id] => 6 [name] => Grape varieties [slug] => table-grapes-varieties [term_group] => 0 [term_taxonomy_id] => 6 [taxonomy] => category [description] => [parent] => 0 [count] => 9 ) [2] => stdClass Object ( [term_id] => 4 [name] => News and Events [slug] => company-industry-news [term_group] => 0 [term_taxonomy_id] => 4 [taxonomy] => category [description] => [parent] => 0 [count] => 8 ) [3] => stdClass Object ( [term_id] => 7 [name] => Our offers [slug] => our-offers [term_group] => 0 [term_taxonomy_id] => 7 [taxonomy] => category [description] => [parent] => 0 [count] => 1 ) [4] => stdClass Object ( [term_id] => 1 [name] => Uncategorized [slug] => uncategorized [term_group] => 0 [term_taxonomy_id] => 1 [taxonomy] => category [description] => [parent] => 0 [count] => 0 ) ) POST QUERY: select ID, slug, date(post_date) as date, post_status, post_date, post_author, post_title, post_name, name, object_id, t.term_id from wp_en_term_relationships AS tr, wp_en_posts AS p, wp_en_terms AS t, wp_en_term_taxonomy AS tt WHERE tt.term_id = t.term_id AND object_id=ID AND post_status='publish' AND tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy IN ('category') AND p.post_type='post' ORDER BY p.post_date DESC POST QUERY RESULTS Array ( [0] => stdClass Object ( [ID] => 205 [slug] => company-industry-news [date] => 2010-05-04 [post_status] => publish [post_date] => 2010-05-04 08:19:23 [post_author] => 1 [post_title] => risks for heart disease and diabetes reduced by grapes [post_name] => risks-heart-disease-diabetes-reduced-grapes [name] => News and Events [object_id] => 205 [term_id] => 4 ) [1] => stdClass Object ( [ID] => 202 [slug] => company-industry-news [date] => 2010-04-16 [post_status] => publish [post_date] => 2010-04-16 10:28:04 [post_author] => 1 [post_title] => Table grapes damaged by frosts [post_name] => table-grapes-damaged-by-frosts [name] => News and Events [object_id] => 202 [term_id] => 4 ) [2] => stdClass Object ( [ID] => 198 [slug] => company-industry-news [date] => 2010-03-09 [post_status] => publish [post_date] => 2010-03-09 20:17:20 [post_author] => 1 [post_title] => Concord Grape Juice Shown to Improve Nocturnal Blood Pressure [post_name] => concord-grape-juice-shown-to-improve-nocturnal-blood-pressure [name] => News and Events [object_id] => 198 [term_id] => 4 ) [3] => stdClass Object ( [ID] => 145 [slug] => our-offers [date] => 2009-10-31 [post_status] => publish [post_date] => 2009-10-31 11:46:17 [post_author] => 1 [post_title] => Table grapes offers for 2010 [post_name] => table-grapes-offers-2010 [name] => Our offers [object_id] => 145 [term_id] => 7 ) [4] => stdClass Object ( [ID] => 141 [slug] => company-industry-news [date] => 2009-10-26 [post_status] => publish [post_date] => 2009-10-26 13:40:12 [post_author] => 1 [post_title] => Belarusian market to be open for export of Moldovan grapes, wines [post_name] => piata-belarusa-deschisa-pentru-struguri-si-vin [name] => News and Events [object_id] => 141 [term_id] => 4 ) [5] => stdClass Object ( [ID] => 138 [slug] => company-industry-news [date] => 2009-09-18 [post_status] => publish [post_date] => 2009-09-18 14:29:00 [post_author] => 1 [post_title] => Paradoxul viticulturii în RM: recoltă bună, probleme mari [post_name] => paradoxul-viticulturii-in-rm-recolta-buna-probleme-mari [name] => News and Events [object_id] => 138 [term_id] => 4 ) [6] => stdClass Object ( [ID] => 133 [slug] => company-industry-news [date] => 2009-08-17 [post_status] => publish [post_date] => 2009-08-17 12:26:09 [post_author] => 1 [post_title] => The independent experts propose the way out from the crisis faced by the Moldavian wineries [post_name] => the-independent-experts-propose-the-way-out-from-the-crisis-faced-by-the-moldavian-wineries [name] => News and Events [object_id] => 133 [term_id] => 4 ) [7] => stdClass Object ( [ID] => 103 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 19:05:59 [post_author] => 1 [post_title] => Arcadia [post_name] => arcadia-tables-grapes [name] => Grape varieties [object_id] => 103 [term_id] => 6 ) [8] => stdClass Object ( [ID] => 99 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 18:54:06 [post_author] => 1 [post_title] => Codreanca [post_name] => codreanca-grapes [name] => Grape varieties [object_id] => 99 [term_id] => 6 ) [9] => stdClass Object ( [ID] => 93 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 18:34:54 [post_author] => 1 [post_title] => Flame Seedless [post_name] => flame-seedless-grapes [name] => Grape varieties [object_id] => 93 [term_id] => 6 ) [10] => stdClass Object ( [ID] => 89 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 17:04:28 [post_author] => 1 [post_title] => LORA variety [post_name] => lora-grapes-variety [name] => Grape varieties [object_id] => 89 [term_id] => 6 ) [11] => stdClass Object ( [ID] => 85 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 16:56:20 [post_author] => 1 [post_title] => Moldova [post_name] => moldova-grapes-variety [name] => Grape varieties [object_id] => 85 [term_id] => 6 ) [12] => stdClass Object ( [ID] => 76 [slug] => table-grapes-varieties [date] => 2009-07-09 [post_status] => publish [post_date] => 2009-07-09 15:10:20 [post_author] => 1 [post_title] => Sashenka [post_name] => sasenka-%d1%81%d0%b0%d1%88%d0%b5%d0%bd%d1%8c%d0%ba%d0%b0 [name] => Grape varieties [object_id] => 76 [term_id] => 6 ) [13] => stdClass Object ( [ID] => 42 [slug] => table-grapes-varieties [date] => 2009-07-07 [post_status] => publish [post_date] => 2009-07-07 10:39:54 [post_author] => 1 [post_title] => Victoria [post_name] => victoria [name] => Grape varieties [object_id] => 42 [term_id] => 6 ) [14] => stdClass Object ( [ID] => 32 [slug] => company-industry-news [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 22:42:39 [post_author] => 1 [post_title] => "Barza Alba" to resume wine material deliveries to Russia [post_name] => resume-wine-material-deliveries-russia [name] => News and Events [object_id] => 32 [term_id] => 4 ) [15] => stdClass Object ( [ID] => 30 [slug] => company-industry-news [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 22:38:59 [post_author] => 1 [post_title] => Decision to liquidate the investment mortgage company Moldvinipoteca [post_name] => lichidarea-companiei-de-investitii-ipotecare-moldvinipoteca [name] => News and Events [object_id] => 30 [term_id] => 4 ) [16] => stdClass Object ( [ID] => 26 [slug] => table-grapes-varieties [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 22:34:29 [post_author] => 1 [post_title] => Talisman [post_name] => talisman [name] => Grape varieties [object_id] => 26 [term_id] => 6 ) [17] => stdClass Object ( [ID] => 15 [slug] => info [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 16:01:00 [post_author] => 1 [post_title] => Contact us [post_name] => contact-us [name] => General Information [object_id] => 15 [term_id] => 3 ) [18] => stdClass Object ( [ID] => 13 [slug] => info [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 16:00:41 [post_author] => 1 [post_title] => Our activities [post_name] => constimax-activities [name] => General Information [object_id] => 13 [term_id] => 3 ) [19] => stdClass Object ( [ID] => 11 [slug] => info [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 16:00:11 [post_author] => 1 [post_title] => For our clients [post_name] => clients [name] => General Information [object_id] => 11 [term_id] => 3 ) [20] => stdClass Object ( [ID] => 9 [slug] => info [date] => 2009-07-02 [post_status] => publish [post_date] => 2009-07-02 15:20:03 [post_author] => 1 [post_title] => About us [post_name] => about-constimax-ltd [name] => General Information [object_id] => 9 [term_id] => 3 ) [21] => stdClass Object ( [ID] => 131 [slug] => table-grapes-varieties [date] => 2009-06-29 [post_status] => publish [post_date] => 2009-06-29 14:21:32 [post_author] => 1 [post_title] => Cardinal [post_name] => table-grapes-cardinal [name] => Grape varieties [object_id] => 131 [term_id] => 6 ) )
- General Information
- Grape varieties
  - Arcadia
  - Codreanca
  - Flame Seedless
  - LORA variety
  - Moldova
  - Sashenka
  - Victoria
  - Talisman
  - Cardinal
- News and Events
- Our offers
  - Table grapes offers for 2010

For our clients

CONSTiMAX ltd will do all the best to assure benefits for our clients and partners.

Useful information:

Customers paying in advance will benefit of essential price discounts.
The transportation is up to our clients. However we could bring the products to the destination with transportation costs included in the price.
For abroad clients we are concluding all required papers and documents.
The grapes are harvested in the day of delivering.
Packing: wooden crates, european standards (0,30×0,50×0,13). 6-7 kg.
Other detailes will be discussed and negociated on real situations before signing the agreement.

Please, don`t hesitate to contact the administration of Constimax ltd…

Navigation

For our clients